This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 08/29/2011 for the course STATISTICS 361 taught by Professor Gupta during the Spring '11 term at California State University , Monterey Bay.
- Spring '11