© 2000 John Petroff 

 

2)- Decomposition

A traditional decomposition procedure breaks down a data series into seasonal (St), trend (Tt) and cyclical (Ct) patterns, just as above. But. the traditional approach to times-series analysis is simpler than the Box-Jenkins approach, and it achieves similar results at a considerable saving of time. The traditional decomposition simplicity is sufficient for most business data because it allows several assumptions that immediately save steps and investigation. For instance, monthly data is used and seasonality is automatically assumed to be over 12 months. However, Box-Jenkins approach is more universal and is appropriate for any time-series.

The following description of classical decomposition is essentially based on Gross and Peterson. A decomposition can be additive (i.e. St + Tt + Ct ) or multiplicative (StxTtxCt). The multiplicative decomposition is more common. Seasonal indices are calculated by
- taking twelve month moving totals
- adding two consecutive twelve moving totals
- divide the sum of two consecutive twelve months moving totals by 24 to obtain a centered monthly average
- divide each actual observation by the corresponding centered moving average for that month to obtain seasonal unadjusted monthly indices
- obtain averages of unadjusted monthly indices for each of the twelve months
- sum the index averages and if not equal to 12 divide sum of the monthly index averages to obtain an adjustment coefficient
- multiply each unadjusted monthly index by the adjustment coefficient to obtain final indices for the twelve months.
One may wonder why the second step of the procedure is to add two consecutive twelve months totals rather than simply taking a twenty four month total. The reason is that a twenty four months total would not be centered: there would be twelve months before and eleven months after.

 Table T-5.30 below illustrates the classical decomposition method. Note that the adjusted seasonal indexes are shown in the months of January through December 1996. As required above, these adjusted seasonal indexes are obtained by multiplying the average monthly ratio of each month by total of monthly ratios12.016 and dividing by 12. The total of monthly ratios T=12.016 is placed in row for the month of January. Note also that the table contains averages of each column, which are used for control purposes. For instance, observe that the average of monthly actual sales is identical to the monthly seasonally adjusted sales, as it should be, naturally.

This table is developed with a standard spreadsheet. The entries into a portion of the cells appears in Appendix 5B.

Table T-5.30

Seasonal Adjustment of Sales January 1995 to December 1999

Year

Month

Actual sales

12 months total

2 times12 months

Centered 12 months

Monthly ratios

Average monthly ratios

Adjusted seasonal indexes

Seasonal indexes

Adjusted sales
    Ave. 1144 13567 26815 1117.31 1.0013 1.0013 1 1 1144
1995

Janauary

820 . .     T=12.016   0.8928 918
.

February

775 . .         0.7370 1052
.

March

805 . .         0.8031 1002
.

April

890 . .         0.8882 1002
.

May

980 . .         0.9787 1001
.

June

1150 12190 .         1.1324 1016
.

July

1270 12210 24400 1017 1.2488     1.2290 1033
 

August

1250 12195 24405 1017 1.2291     1.2093 1034
 

September

1210 12180 24375 1016 1.1909     1.1858 1020
 

October

950 12170 24350 1015 0.936     0.9051 1050
  November 970 12150 24320 1013 0.9576     0.9365 1036
 

December

1120 12170 24320 1013 1.1056     1.1021 1016
1996

Janaury

840 12190 24360 1015 0.8276 0.8940 0.8928 0.8928 941
 

February

760 12240 24430 1018 0.7466 0.7380 0.7370 0.7370 1031
 

March

790 12290 24530 1022 0.773 0.8042 0.8031 0.8031 984
 

April

880 12310 24600 1025 0.8585 0.8894 0.8882 0.8882 991
 

May

960 12360 24670 1028 0.9339 0.9800 0.9787 0.9787 981
 

June

1170 12450 24810 1034 1.1315 1.1339 1.1324 1.1324 1033
 

July

1290 12660 25110 1046 1.2333 1.2306 1.2290 1.2290 1050
 

August

1300 12820 25480 1062 1.2241 1.2109 1.2093 1.2093 1075
 

September

1260 12880 25700 1071 1.1765 1.1874 1.1858 1.1858 1063
 

October

970 12970 25850 1077 0.9006 0.9063 0.9051 0.9051 1072
  November 1020 13030 26000 1083 0.9418 0.9378 0.9365 0.9365 1089
 

December

1210 13110 26140 1089 1.1111 1.1036 1.1021 1.1021 1098
1997

January

1050 13200 26310 1096 0.958     0.8928 1176
 

February

920 13280 26480 1103 0.8341     0.7370 1248
 

March

850 13370 26650 1110 0.7658     0.8031 1058
 

April

970 13460 26830 1118 0.8676     0.8882 1092
 

May

1020 13490 26950 1123 0.9083     0.9787 1042
 

June

1250 13590 27080 1128 1.1082     1.1324 1104
 

July

1380 13620 27210 1134 1.2169     1.2290 1123
 

August

1380 13400 27020 1126 1.2256     1.2093 1141
  September 1350 13540 26940 1123 1.2021     1.1858 1138
 

October

1060 13660 27200 1133 0.9356     0.9051 1171
  November 1050 13900 27560 1148 0.9146     0.9365 1121
 

December

1310 14020 27920 1163 1.1264     1.1021 1189
1998

January

1080 14080 28100 1171 0.9223 . . 0.8928 1210
 

February

700 14080 28160 1173 0.5968     0.7370 950
 

March

990 14140 28220 1176 0.8418     0.8031 1233
 

April

1090 14100 28240 1177 0.9261     0.8882 1227
 

May

1260 14170 28270 1178 1.0696     0.9787 1287
 

June

1370 14140 28310 1180 1.161     1.1324 1210
 

July

1440 14100 28240 1177 1.2234     1.2290 1172
 

August

1380 14330 28430 1185 1.1646     1.2093 1141
 

September

1410 14350 28680 1195 1.1799     1.1858 1189
 

October

1020 14360 28710 1196 0.8528     0.9051 1127
 

November

1120 14330 28690 1195 0.9372     0.9365 1196
 

December

1280 14350 28680 1195 1.0711     1.1021 1165
1999

January

1040 14390 28740 1198 0.8681     0.8928 1161
 

February

930 14440 28830 1201 0.7744     0.7370 1262
 

March

1010 14550 28990 1208 0.8361     0.8031 1258
 

April

1100 14610 29160 1215 0.9053     0.8882 1238
 

May

1230 14680 29290 1220 1.0082     0.9787 1257
 

June

1390 14710 29390 1225 1.1347     1.1324 1227
 

July

1480             1.2290 1204
 

August

1430             1.2093 1183
 

September

1520             1.1858 1282
 

October

1080             0.9051 1193
 

November

1190             0.9365 1271
 

December

1310             1.1021 1189

 

Graph G-5.3 shows the unadjusted and seasonally adjusted data from Table T-5.30.

Graph G-5.3

 

 

 Previous: Box-Jenkins

Last modified: Jun/01/01
 Next: Decomposition (continued)