221k views
0 votes
You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the value. The regression equation is reported as Y = — 80.94x + 69.73And r ^ 2 = 0.81.What is the correlation for this data set?r=

User DWoldrich
by
6.7k points

1 Answer

4 votes

Given:

Coefficient of Determination = r² = 0.81

Recall, the relationship between coefficient of Determination and Correlation.


\text{ Coefficient of Determination = \lparen Correlation Coefficient\rparen}^2

We get,


\text{ r}^2\text{ = 0.81}
\text{ }√(r^2)\text{ = }√(81)
\text{ r = 0.9}

User Lllllll
by
6.4k points