I have been stuck on this for a week now and do not understand at all. I understand we are to use the equation given in the slides for regression but I don't understand how to apply this to the values given in question 1. Every logical way I have tried is wrong.
Question 3 is a matter of trial and error as its multiple choice.
For Question 1: you need to use a linear regression formula: y = a + bX1 + cX2 + dX3 + eX4
the values for a,b,c,e are contained within the question and X1 - X4 are contained within the spreadsheet.
Hope this helps!