I need help with parts a, b, c, d,and e. Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A. Choose the correct time series plot. What type of pattern exists in the data? Horizontal or trend B. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE ??? Forecast for week 7 ??? C. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE ??? Forecast for week 7 ??? D. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Three-week moving average OR exponantial smoothing? E. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2. options for E: 1- Any alpha greater than 0.2 but less than 0.37 provides better result. 2- Any alpha less than 0.2 provides better result 3- Any alpha greater than 0.37 provides better result 4- Any alpha less than 0.2 or greater than 0.37 provides better result
I need help with parts a, b, c, d,and e.
Consider the following time series data.
Week 1 2 3 4 5 6
Value 18 13 16 11 17 14
A. Choose the correct time series plot.
What type of pattern exists in the data? Horizontal or trend
B. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places.
MSE ???
Forecast for week 7 ???
C. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Do not round intermediate calculations. If required, round your answers to two decimal places.
MSE ???
Forecast for week 7 ???
D. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Three-week moving average OR exponantial smoothing?
E. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
options for E: 1- Any alpha greater than 0.2 but less than 0.37 provides better result. 2- Any alpha less than 0.2 provides better result 3- Any alpha greater than 0.37 provides better result 4- Any alpha less than 0.2 or greater than 0.37 provides better result
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
