b)
Time period | Actual Value(A) | Moving avg. Forecast(F) | Forecast error E=|A-F| | Squared Forecast Error |
1 | 19 | |||
2 | 11 | |||
3 | 13 | |||
4 | 10 | 14.33 | 4.33 | 18.78 |
5 | 14 | 11.33 | 2.67 | 7.11 |
6 | 12 | 12.33 | 0.33 | 0.11 |
Total | 7.33 | 26.00 | ||
Average | 2.44 | 8.67 | ||
MAD | MSE | |||
MSE = | 8.67 | |||
forecast for week 7 = | 12.00 |
c)
Time period | Actual Value(A) | Forecast(F) | Forecast error E=A-F | Squared Forecast Error |
1 | 19 | |||
2 | 11 | 19.00 | 8.00 | 64.00 |
3 | 13 | 17.40 | 4.40 | 19.36 |
4 | 10 | 16.52 | 6.52 | 42.51 |
5 | 14 | 15.22 | 1.22 | 1.48 |
6 | 12 | 14.97 | 2.97 | 8.84 |
Average | 4.62 | 27.24 | ||
MAD | MSE | |||
MSE = | 27.24 | |||
forecast for week 7 = | 14.38 |
d)
e)
Time period | Actual Value(A) | Forecast(F) |
1 | 19 | |
2 | 11 | 19.00 |
3 | 13 | 15.80 |
4 | 10 | 14.68 |
5 | 14 | 12.81 |
6 | 12 | 13.28 |
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value...
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...
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 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...
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...
Homework Consider the following time series data. Week Value a. Which of the following is a correct time series plot for this data? 1 18 2 14 3 17 4 12 5 17 6 15 TimeSeries Value 115 Week TimeSeries Value 3 4 5 Week 2 TimeSeries Value 15 3 4 . 5 Week plot #1 What type of pattern exists in the data? Horizontal a Search this course mework Week plot 01 What type of pattern exists in the...
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....
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 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...
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...
Consider the following time series data. Week 1 2 3 4 5 6 Value 16 14 16 11 17 14 Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Week Value Forecast 1 16 2 14 3 16 4 11 5 17 6 14 MSE = Week 7 Forecast= Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you...