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
- Spring '11
- Mean, Absolute deviation, absolute deviation performance