Methods Table for Sheet1
Created: 2/15/02 at 11:56:23 AM
Note: dependent variables are not included
Note: variables not forecasted are not included
Series Methods Table Items Table Items Data
Auto sales Holt-Winters' Multiplicative MAD 47.386
Auto sales Holt-Winters' Multiplicative MAPE 3.612
Auto sales Holt-Winters' Multiplicative RMSE 63.8
Auto sales Holt-Winters' Multiplicative Theil's U 0.429
Auto sales Holt-Winters' Multiplicative Durbin-Watson 2.019
Auto sales Holt-Winters' Multiplicative Alpha 0.228
Auto sales Holt-Winters' Multiplicative Beta 0.001
Auto sales Holt-Winters' Multiplicative Gamma 0.001
Auto sales Holt-Winters' Multiplicative Rank 1
Auto sales Seasonal Multiplicative MAD 50.329
Auto sales Seasonal Multiplicative MAPE 3.829
Auto sales Seasonal Multiplicative RMSE 66.237
Auto sales Seasonal Multiplicative Theil's U 0.449
Auto sales Seasonal Multiplicative Durbin-Watson 2.001
Auto sales Seasonal Multiplicative Alpha 0.287
Auto sales Seasonal Multiplicative Gamma 0.001
Auto sales Seasonal Multiplicative Rank 2
Auto sales Holt-Winters' Additive MAD 52.092
Auto sales Holt-Winters' Additive MAPE 4.094
Auto sales Holt-Winters' Additive RMSE 69.381
Auto sales Holt-Winters' Additive Theil's U 0.458
Auto sales Holt-Winters' Additive Durbin-Watson 1.993
Auto sales Holt-Winters' Additive Alpha 0.291
Auto sales Holt-Winters' Additive Beta 0.001
Auto sales Holt-Winters' Additive Gamma 0.001
Auto sales Holt-Winters' Additive Rank 3
Auto sales Seasonal Additive MAD 53.532
Auto sales Seasonal Additive MAPE 4.185
Auto sales Seasonal Additive RMSE 70.657
Auto sales Seasonal Additive Theil's U 0.468
Auto sales Seasonal Additive Durbin-Watson 2.011
Auto sales Seasonal Additive Alpha 0.335
Auto sales Seasonal Additive Gamma 0.001
Auto sales Seasonal Additive Rank 4
Auto sales Double Moving Average MAD 109.39
Auto sales Double Moving Average MAPE 8.184
Auto sales Double Moving Average RMSE 134.14
Auto sales Double Moving Average Theil's U 0.867
Auto sales Double Moving Average Durbin-Watson 1.516
Auto sales Double Moving Average Periods 14
Auto sales Double Moving Average Rank 5
Auto sales Single Exponential Smoothing MAD 109.38
Auto sales Single Exponential Smoothing MAPE 8.427
Auto sales Single Exponential Smoothing RMSE 136.1
Auto sales Single Exponential Smoothing Theil's U 0.943
Auto sales Single Exponential Smoothing Durbin-Watson 2.014
Auto sales Single Exponential Smoothing Alpha 0.609
Auto sales Single Exponential Smoothing Rank 6
Auto sales Single Moving Average MAD 110.76
Auto sales Single Moving Average MAPE 8.311
Auto sales Single Moving Average RMSE 136.62
Auto sales Single Moving Average Theil's U 0.9
Auto sales Single Moving Average Durbin-Watson 1.295
Auto sales Single Moving Average Periods 14
Auto sales Single Moving Average Rank 7
Auto sales Double Exponential Smoothing MAD 111.41
Auto sales Double Exponential Smoothing MAPE 8.679
Auto sales Double Exponential Smoothing RMSE 137.59
Auto sales Double Exponential Smoothing Theil's U 0.942
Auto sales Double Exponential Smoothing Durbin-Watson 2.025
Auto sales Double Exponential Smoothing Alpha 0.627
Auto sales Double Exponential Smoothing Beta 0.014
Auto sales Double Exponential Smoothing Rank 8
Series Auto sales
  Table Items                  
Methods Rank RMSE MAD MAPE Durbin-Watson Theil's U Periods Alpha Beta Gamma
Double Exponential Smoothing 8 137.59 111.41 8.679 2.025 0.942   0.627 0.014  
Double Moving Average 5 134.14 109.39 8.184 1.516 0.867 14  
Holt-Winters' Additive 3 69.381 52.092 4.094 1.993 0.458 0.291 0.001 0.001
Holt-Winters' Multiplicative 1 63.8 47.386 3.612 2.019 0.429 0.228 0.001 0.001
Seasonal Additive 4 70.657 53.532 4.185 2.011 0.468 0.335 0.001
Seasonal Multiplicative 2 66.237 50.329 3.829 2.001 0.449 0.287 0.001
Single Exponential Smoothing 6 136.1 109.38 8.427 2.014 0.943 0.609  
Single Moving Average 7 136.62 110.76 8.311 1.295 0.9 14