Note before answer the question : I want my answer in detailed workings clearly and systematically.

If you ever answered a question like this, please do not answer it again.

Please give me the detaila answer corresponding to the desired marks.

A homeowner is interested in the effect that using the air conditioner and washing machine had on the electric bill. He recorded the number of hours the air conditioner and the number of times washing machine were used for 14 days. He also monitored the electric meter for these 14 days, and computed the amount of electricity used each day in kilowatt-hours. Data is shown in Table 3. Table 3 Air Conditioner Washing Machine Electricity Used (hours) (times] (kwh) 1.5 35 4.5 2 63 5.0 66 2.0 17 8.5 3 94 6.0 3 79 13.5 93 8.0 1 66 12.5 94 7.5 2 82 8.0 3 78 7.5 65 12.0 77 6.0 75a) Use Microsoft Excel to produce Analysis of Variance table for the multiple linear regression and state the model. b) Construct a complete hypothesis test to test whether the model in (a) is fit at o = 0.05. c) Construct a complete hypothesis test to test whether the regression coefficients, B and By, are significantly zero at a = 0.05. d) Based on your answer in (b) and (c) state a brief summary on the linear relationship between electricity used and the two factors. [Total: 20 / 60 marks]