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. Using the Excel spreadsheet 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. Make the x-axis "gas use" and the y-axis "gas cost".Copy and paste the scatter plot here:

1. What is the Pearson r value for these two variables (do not round the answer)?

1. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?

1. What is the regression equation for the relationship between these two variables?

1. Using the same Excel spreadsheet, make a scatter plot with titles comparing temperature and gas use. Make the x-axis "temperature" and the y-axis "gas use". (You may find it easiest to first delete the two intervening columns in the spreadsheet.)Copy and paste the scatter plot here:

1. What is the Pearson r value for these two variables (do not round the answer)?

1. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?

1. What is the regression equation for the relationship between these two variables?