Question: 4-Week 5-Week Moving Average Moving Average Week Sales 1 17 2 21 3 19 4 24 5 19 6 15 7 22 8 19 9

4-Week 5-Week Moving Average Moving Average Week Sales 1 17 2 21 3 19 4 24 5 19 6 15 7 22 8 19 9 22 > 10 20 11 15 12 23 b. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = c. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that MSE for the three-week moving average is 14.03
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
