{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MAD Performance Measure - MAD's of other models The one...

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

View Full Document Right Arrow Icon
Mean Absolute Deviation 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 absolute deviation performance measure (MAD) for this model. The MAD 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: MAD's of other models. The one with the lowest MAD appears to be the best model for this time series data. 1. In F5 Enter =ABS(B5-D5) 2. Drag F5 to F6:F21 3. In F22 Enter =AVERAGE(F5:F21) All periods for which there is both a time series value and a forecast...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online