Simple Linear Regression for Forecasting Sales

Question

1. Use the regression function in Excel to forecast sales for 1988 to 2015.
2. Use simple moving average (with k = 4) to forecast sales for 1992 to 2015.
3. Use Mean Absolute Percent Error (MAPE) to determine whether simple linear regression or simple moving average is more accurate in forecasting sales, making sure to clearly show the MAPE values for the two forecasts.
4. Plot the actual sales, and your forecasts in parts Q1 and Q2 above on a line graph.

Summary

This question belongs to statistics and discusses about simple linear regression.

Word count: NA