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.