Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places.
4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 5. What is the MSE for the four-period moving average? Round your answer to two decimal places.
Moving Average Forecasting Periods in moving average Next period forecast: Time Period 1234567 8 9 10 11 12 13 3 Demand Forecast Error Error^2 MSE 88 85 80 81 92 83 85 84 87 89 85 97 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A ▼ #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Use the area below to draw a line chart for the three-period moving average.
Periods in moving average Next period forecast: 4 Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 Which moving average is best? Demand Forecast Error MSE 88 85 80 81 92 83 85 84 87 89 85 97 Error^2 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am