Business Statistics

Business Statistics
Question 2
The data on A3_Question2.xls show the number of packs of cigarettes consumed per quarter per adult, for six years in a metropolitan city.
(a)  Using the regression technique, estimate a linear trend and seasonal indexes for cigarette consumption.
(b)  Forecast cigarette consumption for each of the quarters for Year 7.