This preview shows page 1. Sign up to view the full content.
Unformatted text preview: MSE's of other models. The one with the lowest MSE appears to be the best model for this time series data. 1. In F2 Enter =(B2-D2)^2 2. Drag F2 to F3:F21 3. In F22 Enter =AVERAGE(F2:F21) All periods for which there is both a time series value and a forecast...
View Full Document
- Spring '11