forecast the expected guest count if $65000 is spent on advertising.

b) See the table and develop a least squares regression for the 10 months of data. Produce an equation for predicting guest count (in thousands) based on advertising costs (in thousands). You can use excelto do totals but please show calculations for computing a &b coefficients. (15 marks) Month Advertising Guest Count x2 Y2 XY X Y 1 14 21 2 17 24 3 25 27 4 25 32 5 35 29 6 35 37 7 45 43 8 50 43 on 60 54 10 60 66 c) Forecast the expected guest count if $65,000 is spent on advertising. (1 mark) d) Compute the forecast error if the actual guest count was 70,000 for the prediction above. (1 mark)