The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one-month period.

1. Develop a spreadsheet model for forecasting Dow Jones Industrial Average prices using a simple two-period and three-period moving average. Compute MAD to determine which model is better?
2. Develop a spreadsheet model for forecasting Dow Jones Industrial Average prices using simple exponential smoothing with a smoothing constant of 0.1 and 0.5. Compute MAD to determine which model is better?

Show Steps