In: Statistics and Probability
X | Y |
195 | 584 |
225 | 629 |
206 | 618 |
336 | 1312 |
274 | 1000 |
216 | 692 |
202 | 546 |
186 | 559 |
199 | 537 |
238 | 643 |
196 | 626 |
169 | 457 |
239 | 718 |
245 | 1615 |
195 | 520 |
201 | 562 |
214 | 578 |
232 | 811 |
471 | 2300 |
173 | 468 |
279 | 893 |
178 | 479 |
189 | 600 |
262 | 786 |
215 | 644 |
239 | 716 |
167 | 451 |
239 | 764 |
203 | 568 |
225 | 631 |
Use Excel to find the sample COV(X,Y) and sampleVAR(X). Compute the ratio:
sample COV(X,Y)/sampleVAR(X)
Where does this value appear in your output for the regression? Explain
We use Excel to solve this question-
the ratio = sample COV(X,Y)/sample VAR(X) = 5.729
This value is slope of the regression line.