|
Avg Temp
|
Elec Use
|
Elec Charge ($)
|
Gas Use
|
Gas Charge ($)
|
|
75
|
1589
|
177.55
|
22
|
29.25
|
|
72
|
920
|
107.21
|
15
|
22.50
|
|
67
|
699
|
83.00
|
9
|
16.59
|
|
52
|
704
|
83.31
|
64
|
76.04
|
|
46
|
807
|
90.28
|
96
|
112.08
|
|
32
|
904
|
99.35
|
155
|
181.96
|
|
28
|
888
|
96.93
|
200
|
245.45
|
|
33
|
1119
|
110.89
|
193
|
249.50
|
|
25
|
879
|
88.82
|
232
|
302.49
|
|
47
|
878
|
88.32
|
80
|
112.60
|
|
60
|
1111
|
115.60
|
27
|
42.84
|
|
71
|
1306
|
134.31
|
15
|
23.55
|
|
75
|
1778
|
179.60
|
17
|
23.40
|
|
75
|
1793
|
181.05
|
12
|
17.71
|
|
66
|
1113
|
115.08
|
16
|
21.33
|
|
50
|
742
|
77.79
|
69
|
75.51
|
|
47
|
834
|
81.70
|
71
|
77.38
|
|
30
|
833
|
78.60
|
161
|
157.74
|
|
30
|
833
|
78.60
|
161
|
157.70
|
1. Scatter plot of gas use vs. gas charge
2. what is the Pearson r value for these two variables (do not round the answer)?
3. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)
4. What is the regression equation for the relationship between these two variables?
5. using the same Excel spreadsheet, make a scatterplot with titles comparing temperature and gas use.
6. What is the Pearson r value for these two variables (do not round the answer)?
7. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?
8. What is the regression equation for the relationship between these two variables?