Question: (15) Can the consumption of water in a city be predicted by air temperature?

a) (3) Use EXCEL to create a scatter diagram of the data and to estimate the regression equation. ATTACH A COPY OF THESE OUTPUTS.

b) (12) Test the significance of the model using EACH of the three possible methods. Use the p-value approach and α = 0.08.