Learning Goal: I’m working on a statistics question and need the explanation and answer to help me learn.
- Develop spreadsheet models for forecasting pricesusing single moving average and single exponentialsmoothing.
- Using MAD, MSE, and MAPE as guidance, find thebest number of moving average periods and bestsmoothing constant for exponential smoothing.
