In: Statistics and Probability
The sample data below shows the average temperature (x, in degrees Fahrenheit) and monthly heating bill (y, in dollars) for 12 recent months. Use Excel to compute the correlation coefficient.
Enter your answer as a decimal rounded to three places.
Correlation coefficient =
Average temperature | Monthly heating bill |
29 | 326 |
36 | 295 |
42 | 241 |
58 | 196 |
62 | 154 |
70 | 93 |
74 | 33 |
77 | 0 |
68 | 62 |
57 | 184 |
45 | 263 |
33 | 302 |
Solution :
Let me know in the comment section if anything is not
clear. I will reply ASAP!
If you liked the answer, please give an upvote. This will be quite
encouraging for me.Thank-you!