Run a regression analysis on the following bivariate set of data with y as the response variable.
x | y |
---|---|
69 | 25.6 |
87.1 | 99.4 |
80.3 | 77.2 |
100.4 | 148 |
38.1 | 4.6 |
99.7 | 116.2 |
82.7 | 74.6 |
98 | 100.3 |
78.5 | 65.9 |
93.4 | 117.5 |
82.7 | 106.4 |
85 | 52.3 |
Find the correlation coefficient and report it accurate to three
decimal places.
r =
What proportion of the variation in y can be explained by
the variation in the values of x? Report answer as a
percentage accurate to one decimal place. (If the answer is
0.84471, then it would be 84.5%...you would enter 84.5 without the
percent symbol.)
r² = %
Find the correlation coefficient and report it accurate to three
decimal places.
r = 0.879
R2 population of proportion is 77.3
Use (="CORREL(array1,array2) formula to get correlation value
Get Answers For Free
Most questions answered within 1 hours.