Stat week 3
sbatniji
weightedmovingaverage.pdf
Weighted Moving Average
The table below shows the number of DVD players that Electronic Depot has sold during the last 12 weeks. Forecast the demand for week 13 using a three-period moving average. What is the MSE for this method?
Week # Demand for DVD Players 1 17 2 22 3 25 4 16 5 28 6 23 7 19 8 20 9 17
10 25 11 33 12 32
If Electronic Depot decided to forecast using a three-period weighted moving average, what would the optimal weights be that would minimize MSE? What would be the Week 13 forecast for DVD players? Is this an improvement over the moving average from the previous problem?
