Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...
icon
Related questions
Question

Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows:
 

    PREDICTED DEMAND
Period Demand F1 F2
1 68 61 60
2 75 67 66
3 70 75 70
4 74 69 67
5 69 74 72
6 72 67 78
7 80 74 78
8 78 76 80
 

b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)

d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)
 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing