See the table below 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).

Guest Month. Advertising count X. Y. X^2. Y^2. XY. 1 14 21 2 17 24

3 25 27 4 25 32 5 35 29 6 35 37 7 45 43 8 50 43 9 60 54 10 60 66

DULU HUDULD Aabbccbo 15 whep. Baroneok1 Barononck 2 Floriarono... ... A6 1 3 4 5 6 810 11 13 17 18 12 14 15 16 b) See the table and develop a least squares regression for 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 coefficients. (15 marks) Month Advertising Guest Count X2 y2 XY X Y 1 14 21 1 2 17 24 3 25 27 4 25 32 5 35 29 6 35 37