b)
Time period | Actual Value(A) | Moving avg. Forecast(F) | Forecast error E=|A-F| | Squared Forecast Error | MAPE |
1 | 18 | ||||
2 | 14 | ||||
3 | 17 | ||||
4 | 12 | 16.33 | 4.33 | 18.78 | 0.3611 |
5 | 17 | 14.33 | 2.67 | 7.11 | 0.1569 |
6 | 15 | 15.33 | 0.33 | 0.11 | 0.0222 |
Total | 7.33 | 26.00 | 0.1791 | ||
Average | 2.44 | 8.67 | 8.95% | ||
MAD | MSE | MAPE | |||
MSE = | 8.67 | ||||
forecast for week 7 = | 14.67 |
c)
α= | 0.2 | |||
Time period | Actual Value(A) | Forecast(F) | Forecast error E=A-F | Squared Forecast Error |
1 | 18 | |||
2 | 14 | 18.00 | 4.00 | 16.00 |
3 | 17 | 17.20 | 0.20 | 0.04 |
4 | 12 | 17.16 | 5.16 | 26.63 |
5 | 17 | 16.13 | 0.87 | 0.76 |
6 | 15 | 16.30 | 1.30 | 1.70 |
Total | 11.53 | 45.12 | ||
Average | 2.31 | 9.02 | ||
MAD | MSE | |||
MSE = | 9.02 | |||
forecast for week 7 = | 16.04 |
d)
The three-month moving average provides a better forecast since it has a smaller MSE |
e)
MSE =8.65
f)
provides a better.........
Homework Consider the following time series data. Week Value a. Which of the following is a...
Consider the following time series data Week 1 2 3 4 5 6 Value 19 14 16 12 18 15 a. Which of the following is a correct time series plot for this data? 1 Time eries Value 15 10 Week 2 TimeSeries Value 15 10 5 Week 4 3 TimeSeries Value 15 10 -5 Week 4 5 Select your answer What type of pattern exists in the data? What type of pattern exists in the data? Horizontal b. Develop...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Which of the following is a correct time series plot for this data? - Select your answer -plot #1plot #2plot #3Item 1 What type of pattern exists in the data? - Select your answer -VerticalHorizontalScatterItem 2 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week (to 2 decimals if necessary)....
Consider the following time series dataa. Which of the following is a correct time series plot for this data?b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary) c. Use α = .2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 ( 2 decimals). d. Compare the three-week moving average approach with the exponential smoothing approach using α-.2,...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...
Please help :) a. Which of the following is a correct time series plot for this data? b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). c. Use α-.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for month 8 (to 2 decimals). Enter negative values as negative number. d. Compare the three-month moving average approach with the exponential smoothing approach using...
omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as...
Consider the following time series data. Week 1 2 3 4 5 6 Value 17 13 15 11 15 13 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Horizontal PatternTrend PatternItem 2 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 17 14 Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time Series Value Forecast 1 19 2 14 3 17 4 12 5 17 6 14 MSE: The forecast for week 7: Use = 0.2 to compute the exponential smoothing values for the time series....