1) calculate the correlation coefficient between all pairs of these eight variab
ID: 3170432 • Letter: 1
Question
1) calculate the correlation coefficient between all pairs of these eight variables. Report those correlation coefficients in the table below to the nearest three decimal places. There’s no need to report them twice (leave the X’s where they are).
Jan. High
Jan. Low
July High
July Low
Precip.
Days Precip.
Snow
Sun
Jan. High
X
X
X
X
X
X
X
X
Jan. Low
X
X
X
X
X
X
X
July High
X
X
X
X
X
X
July Low
X
X
X
X
X
Precip.
X
X
X
X
Days Precip.
X
X
X
Snow
X
X
Sun
X
2) Which pair of values has the strongest (either positive or negative) linear association (make sure to check the scatterplot)? What is the value of the correlation between those variables?
3) Which pair of values has the weakest (either positive or negative) linear association (make sure to check the scatterplot)? What is the value of the correlation between those variables?
4) Suppose you want to predict the annual snowfall for an American city and you are allowed to look at that city’s averages for these other variables. Which variable would be most useful to you? Which variable would be least useful? Support your answer with a short explanation.
Jan. High
Jan. Low
July High
July Low
Precip.
Days Precip.
Snow
Sun
Jan. High
X
X
X
X
X
X
X
X
Jan. Low
X
X
X
X
X
X
X
July High
X
X
X
X
X
X
July Low
X
X
X
X
X
Precip.
X
X
X
X
Days Precip.
X
X
X
Snow
X
X
Sun
X
Climate xlsx StatCrunch Applets Edit Data Stat Graph Help Row City Jan Hi Jan Lo July H July Lo Precip Prec days Snow sun var10 var 11 1 Atlanta 50.4 31.5 88 69.5 50.77 115 2 61 2 Baltimore 40.2 23.4 87.2 66.8 40.76 113 21.3 57 3 Boston 35.7 21.6 81.8 65.1 41.51 126 40.7 58 4 Chicago 29 12.9 83.7 62.6 35.82 126 38.7 55 5 Cleveland 31.9 17.6 82.4 61.4 36.63 156 54.3 49 6 Dallas 54.1 32.7 96.5 74.1 33.7 78 2.9 64 7 Denver 43.2 16.1 88.2 58.6 15.4 89 59.8 70 8 Detroit 30.3 15.6 83.3 61.3 32.62 135 41.5 53 9 Houston 61 39.7 92.7 72.4 46.07 104 0.4 56 16.7 88.7 68.2 37.62 104 20 62 10 Kansas City 34.7 11 Los Angeles 12.01 12 Miami 13 Minneapolis 20.7 2.8 84 63.1 28.32 114 49.2 58 14 Nashville 45.9 26.5 89.5 68.9 47.3 119 10.6 56 60.8 41.8 90.6 73.1 61.88 114 0.2 60 15 New Orleans 16 New York 37.6 25.3 85.2 68.4 47.25 121 28.4 58 37.9 22.8 82.6 67.2 41.41 117 21.3 56 17 Philadelphia 18 Phoenix 65.9 41.2 105.9 81 7.66 36 0 86 19 Pittsburgh 33.7 18.5 82.6 61.6 36.85 154 42.8 46 20 St. Louis 37.7 20.8 89.3 70.4 37.51 111 19.9 57 21 Salt Lake Cit 36.4 19.3 92.2 63.7 16.18 90 57.8 66 San Diego 65.7 23 San Francisc 24 Seattle 45 35.2 75.2 55.2 37.19 156 12.3 46 25 Washington 42.3 26.8 88.5 71.4 38.63 112 17.1 56Explanation / Answer
1)
Following is the correlation matrix generated by excel:
2)
Jan Lo and Jan Hi has highest positive correlation coefficient between them.
The correlation coeffcient between them is 0.965
3)
Correlaiton between Precip and Jan Lo is lowest. It is 0.002.
4)
The correlation between snow and Jan Lo is highest so it is most useful.
While correlation between snow and July Hi is lowest so it is least useful.
Correlation Matrix Jan hi Jan Lo July Hi July Lo Precip Precdays Snow Sun Jan hi 1.000 Jan Lo .965 1.000 July Hi .152 -.022 1.000 July Lo .554 .473 .712 1.000 Precip -.073 .002 .114 .243 1.000 Precdays -.572 -.460 -.130 -.345 .695 1.000 Snow -.807 -.825 -.080 -.613 -.157 .444 1.000 Sun .643 .512 .377 .521 -.506 -.826 -.363 1.000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.