Question: Consider the following time series data. Month 1 2 3 4 5 6 7 Value 30 19 26 18 25 29 21 (a) Compute MSE
Consider the following time series data.
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Value | 30 | 19 | 26 | 18 | 25 | 29 | 21 |
(a)
Compute MSE using the most recent value as the forecast for the next period.
MSE =
What is the forecast for month 8?
(b)
Compute MSE using the average of all the data available as the forecast for the next period. (Round your answer to two decimal places.)
MSE =
What is the forecast for month 8?
(c)
Which method appears to provide the better forecast?
The average of all the previous values provides a better forecast, because its forecast for month 8 is larger than the month 8 forecast using the most recent value.The most recent value provides a better forecast, because its MSE is smaller than the MSE using the average of all the previous values. The average of all the previous values provides a better forecast, because its MSE is smaller than the MSE using the most recent value.The most recent value provides a better forecast, because its forecast for month 8 is smaller than the month 8 forecast using the average of all the previous values.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
