Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

22. [35 marks] The Hamilton City Council (HCC) is very concerned about the amount of water that is required by Hamilton residents in the hot

image text in transcribed
22. [35 marks] The Hamilton City Council (HCC) is very concerned about the amount of water that is required by Hamilton residents in the hot summer months. Data has been collected on water use W, in millions of litres and on daily temperatures 7, in centigrade, for 15 days in January 2019. The following Excel Output (with two deliberate omissions) show the results from a simple regression that can be used to predict the amount of water required by Hamilton residents depending on expected temperature for that day. SUMMARY OUTPUT Regression Statistics Multiple R 0.91 R Square A Adjusted R Square 0.81 Standard Error 6.68 Observations 15 ANOVA Significance df SS MS F F Regression 2667.2 2667.2 59.7 3.2591E-06 Residual 13 580.6 44.7 Total 14 3247.7 Standard Upper Lower Uppe Coefficients Error t Stat P-value Lower 95% 95% 99.0% 99.0 Intercept 15.6 6.7 2.3 0.036 1.203 30.077 -4.49 35.7 Temp 2.1 0.3 B 3.26E-06 1.541 2.736 1.305 2.97 a) State the equation showing that water use is a function of the daily temperature. Give a brief interpretation of the equation and use it to predict how much water will be required if Hamilton if the temperature is 40 C. (6 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

9780135486221

Students also viewed these Economics questions