a) 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 excel to do totals but please show calculations for computing a & b coecients.

b) Forecast the expected guest count if $65,000 is spent on advertising.

c) Compute the forecast error if the actual guest count was 70,000 for the prediction above.

Hard Rock's Moscow Cafea Month 1 2 3 4 5 6 78 9 10 21 24 27 32 29 37 43 43 54 66 Guest count (in thousands) 14 17 25 25 35 35 45 50 60 60 Advertising (in $ thousands)