OC Music Company has been in business for 4 years. Data about the sales of each quarter were collected below. The manager wants use these data to forecast sales of the 5th year. Please copy and paste it to Excel and run regression analysis. Answer the following 4 questions. Year Quarter Sales
1 Q1 7
Q2 2
Q3 4
Q4 10
2 Q1 6
Q2 3
Q3 8
Q4 14
3 Q1 10
Q2 3
Q3 5
Q4 16
4 Q1 12
Q2 4
Q3 7
Q4 22
1) Develop a model for trend and seasonality. Please clearly define your variables. How many independent variables do you have in your regression?
2) What is the intercept in your estimated regression model? Rounded to two decimal places.
3) Use the model to forecast for sales of last quarter in the 5th year. Rounded to two decimal places.
4) Calculate the MAE for this time series forecast.