Retail sales in Quarters 1-4 over a 10-year period for a department store are shown (in hundreds

Question:

Retail sales in Quarters 1-4 over a 10-year period for a department store are shown (in hundreds of thousands of dollars) in the table below.

Quarter Year 2 4 10.3 1 8.3 9.8 12.1 13.7 8.7 10.1 12.7 14.2 13.5 15.4 17.1 19.2 12.1 14.5 16.0 3 4 23.1 24.0 25.1 27.7

a. Write a regression model that contains trend and seasonal components to describe the sales data.
b. Use least squares regression to fit the model. Evaluate the fit of the model.
c. Use the regression model to forecast the quarterly sales during year 11. Give 95% prediction intervals for the forecasts.