Question: Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 10 18 14 Develop the three-week moving average
Consider the following time series data.
| Week | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| Value | 19 | 11 | 16 | 10 | 18 | 14 |
Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.)
| Week | Time Series Value | Forecast |
|---|---|---|
| 1 | 19 | |
| 2 | 11 | |
| 3 | 16 | |
| 4 | 10 | |
| 5 | 18 | |
| 6 | 14 |
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(c)Use = 0.2 to compute the exponential smoothing forecasts for the time series.
| Week | Time Series Value | Forecast |
|---|---|---|
| 1 | 19 | |
| 2 | 11 | |
| 3 | 16 | |
| 4 | 10 | |
| 5 | 18 | |
| 6 | 14 |
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(Round your answer to two decimal places.)
(e)Use a smoothing constant of = 0.4 to compute the exponential smoothing forecasts.
| Week | Time Series Value | Forecast |
|---|---|---|
| 1 | 19 | |
| 2 | 11 | |
| 3 | 16 | |
| 4 | 10 | |
| 5 | 18 | |
| 6 | 14 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
