I need help with these questions asap please . I would really appreciate if the answers are typed in, written paper answer will be okay too. If Thanks in advance! If you want to share excel file, please share the screenshots. Thanks

INSTRUCTIONS

Perform the required calculations, present your findings, and prepare short written responses to the following questions. Please submit your answers in a single file.

Question 1 Simple linear regression (15 marks)

An educational designer is studying the relationships between student performance and the provision of online learning content. She collects data on student grades and the total time spent viewing online lecture content (table 2)

. (a) Use the least-squares method to calculate the regression coefficients b0 and b1. (1 mark)

(b) Interpret the meaning of the model parameters. (2 marks)

(c) Predict the grades of a student who views 100 minutes of online content. (2 marks)

(d) Is it appropriate to use the model to predict the marks for students viewing 500 minutes of content? Explain. (3 marks)

(e) Explain the R2 (2 marks)

(f) Plot the residuals against online time. Is there any evidence of a pattern in the residuals? Explain. (3 marks)

(g) At the 0.05 level of significance, is there evidence of a linear relationship between student grades and online viewing? (2 marks)

Question 2 Multiple linear regression (15 marks) A large produce distributor is analysing the supply of lamb in Western Australia. She hypothesises that the lamb supply would be a function of lamb feed price and beef supply in the market (table 1)

(a) Use the least-squares method to calculate the regression coefficients b0 and b1, and b2 (2 marks)

(b) Interpret the meaning of the model parameters. (3 marks)

(c) Predict the quantity of lamb supplied in Western Australia if the feed price is $5/kg and the beef supply is 7,800 kg. (2 marks)

(d) Perform a residual analysis to determine the adequacy of the model. Comment on the residual analysis. (3 marks)

(e) Is there a statistically significant relationship between the supply of lamb and the two independent variables at the 0.05 level of significance? Explain. (3 marks)

(f) Explain the adjusted R2 .(2 marks)

Lamb Table Online Lecture Table