Question

4. Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 1. Compute MSE using the most recent value as the forecast for the next period. What is the forecast for Month 8? 2. Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for Month 8? 3. Which method appears to provide the better forecast?

Answer 1

A. MSE = 60.50. Forecast for month 8 is 15

B. MSE = 36.12. Forecast for month 8 is 18

C. The method i part b appears to provide the better forecast.

Explanation:

See pictures for solution