Mean Square Error Performance Measure

Mean Square Error Performance Measure - MSE's of other...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Mean Square Error Performance Measure for Comparing the Performance of Time Series Models Situation: Forecasted values have been determined for all possible time periods in which there is a time series value Required: Determine the mean square error performance measure (MSE) for this model. The MSE will be used to compare against
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online