Question

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=

Answer 1

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{ }\sqrt{r^2}\text{ = }\sqrt{81}$$\text{ r = 0.9}$