energy data regarding temperature, electric use, electric cost, gas use, and gas cost for 19 months

1. Using the Excel spread sheet provided in this week’s lesson with energy data regarding temperature, electric use, electric cost, gas use, and gas cost for 19 months, make a scatter plot with titles comparing gas use and gas cost as explained

in the Week 5 presentation in slides 9-14. Copy and paste the scatter plot here: 

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 scatter plot with titles comparing temperature and gas use. (You may find it easiest to first delete the two intervening columns in the spreadsheet.) Copy and paste the scatter plot here: 

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?