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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!