Please help!
The Excel le: OfceEnergyxlsx cohtains information recorded on a sample of 35 of the company's city branches. The le contains the amount of renewable energy (kWh) consumed in the previous year and the size (square metres) of each branch. Download these data and t a linear regression model for predicting W (Y) from Size (X). Use your Excel output, and any other information provided, to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. 10 Figural Figure 2 Figuru 3 0 im 21! 333 I I E ElEll] 3103 3370 35m Ell'llIIl] 35m] 0 ID 220 -1C I I I I I I I I . I I I I I I I I I I .400 lm 201] 100 n 100 200 300 20 3 3|] 35 20 25 3|] 35 W Size Sin Answer the following questions by choosing the most correct option or typing the answer 1. 2. (1 mark) The slope of the least m regression line '5 35W (3 marks) The assumptions for a linear model appear to be reasonable since (choose the figure that goes with each statement): 0 The relationship between Wand Size appears reasonably linear W 1 Figure 2Figure 3None of these 0 The residuals may be drawn from a normal distribution W 1Figure 2Figure 3None of these a The residuals may have a constant standard deviation across the range of branch sizes We 1Figure 2Figure 3None of these (1 mark) The largest branch in size used the greatest amount of renewable energy in the previous year W (2 marks) The branch with the largest residual had used 3241.787 kWh of renewable energy in the previous year and was 20 square metres in size. Calculate the value of the residual. Type your answer with 3% (2 marks) The absolute value of the test statistic for testing the slope of the regression line is: Answer (3dp) with degrees of freedom equal to: Answer Gnteger). (1 mark) The p-value for testing the slope of the regression line is less than 0-05- W 7. (2 marks) Select the most appropriate conclusion to the question "Is the size of the branch a useful predictor for the amount of renewable energy it uses annually?". mm is a signicant negative linear relationship between renewable energy consumption and the size of the W is not enough evidence to indicate that the size of the branch is a useful predictor of its renewable energy Wis a significant positive linear relationship between renewable energy consumption and the size of the branch 8. (1 mark) The correlation is: Answer (3dp - remember to include a negative sign if appropriate) 9. (2 marks) Use the regression equation to predict the renewable energy consumption for a branch that is 24 square metres in size (3dp): Answer 10. (3 marks) We are 95% confident that for each extra square metre in the size of a branch, the average annual renewable energy consumption is expected to WWW kWh (lower limit) and Answer kWh (upper limit). Type your answers with 3dp