The owner of a store wants to investigate the multiple linear regression between annual electricity bill ($000) with store opening hours and the temperature outside (degrees Celsius) . A random sample was taken (given below), and Excel was used to create the following multiple linear regression output.

The owner of a store wants to investigate the multiple linear regression between annual electricity bill ($000) with store opening hours and the temperature outside (degrees Celsius) . A random sample was taken (given below), and Excel was used to create the following multiple linear regression output.

image

image 1

a) Estimate the electricity bill when the store was open for 45 hours and the temperature outside was 40 degrees Celsius. COMMENT on the reliability of your estimate.

b) Using the 1% significance level, test whether this is a significant linear relationship between electricity bill and temperature; give hypotheses, your reasoning, decision, and conclusion.