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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|