In: Statistics and Probability
3) Use the data below to answer the questions that follow
X 7 9 11 15 15 17 21 21 21 29 33 34 35 35
Y 22 20 17 17 16 12 10 10 7 4 4 3 1 0
a) Calculate the correlation coefficient “r”
b) Explain what your value for r means for this data
c) Determine the equation for the linear regression line of this data
d) What does your equation predict for an x value 17?
e) How does that compare with the actual y value for x = 17?
f) What does your equation predict for an x value of 25?
g) How accurate do you think that prediction is? Why?
Following table shows the calculations:
X | Y | X^2 | Y^2 | XY | |
7 | 22 | 49 | 484 | 154 | |
9 | 20 | 81 | 400 | 180 | |
11 | 17 | 121 | 289 | 187 | |
15 | 17 | 225 | 289 | 255 | |
15 | 16 | 225 | 256 | 240 | |
17 | 12 | 289 | 144 | 204 | |
21 | 10 | 441 | 100 | 210 | |
21 | 10 | 441 | 100 | 210 | |
21 | 7 | 441 | 49 | 147 | |
29 | 4 | 841 | 16 | 116 | |
33 | 4 | 1089 | 16 | 132 | |
34 | 3 | 1156 | 9 | 102 | |
35 | 1 | 1225 | 1 | 35 | |
35 | 0 | 1225 | 0 | 0 | |
Total | 303 | 143 | 7849 | 2153 | 2172 |
(a)
(b)
Correlation coefficient is negative and it has high magnitude 0.976 so it shows that relationship between the variables is negative and strong.
(c)
(d)
(e)
The actual of y for X=17 is 12. That is predicted value is greater than actual value.
(f)
(g)
The prediction should be near to accurate because X=25 is within range of X used to make the model.