Results Table for Sheet1 | ||||||
Created: 2/15/02 at 11:56:18 AM | ||||||
Series | Auto sales | |||||
Data | ||||||
Date | Historical Data | Lower: 5% | Fit & Forecast | Upper: 95% | Residuals | |
1/31/91 | 839.80 | 844.02 | -4.22 | |||
2/28/91 | 928.60 | 955.76 | -27.16 | |||
3/31/91 | 1104.10 | 1131.11 | -27.01 | |||
4/30/91 | 1060.90 | 1054.86 | 6.04 | |||
5/31/91 | 1174.30 | 1161.67 | 12.63 | |||
6/30/91 | 1176.30 | 1182.79 | -6.49 | |||
7/31/91 | 1185.90 | 1058.68 | 127.22 | |||
8/31/91 | 1064.00 | 1089.74 | -25.74 | |||
9/30/91 | 1063.20 | 1036.63 | 26.57 | |||
10/31/91 | 1048.50 | 1082.60 | -34.10 | |||
11/30/91 | 932.80 | 960.34 | -27.54 | |||
12/31/91 | 962.40 | 1002.94 | -40.54 | |||
1/31/92 | 868.60 | 872.39 | -3.79 | |||
2/29/92 | 989.40 | 987.91 | 1.49 | |||
3/31/92 | 1129.70 | 1177.03 | -47.33 | |||
4/30/92 | 1146.10 | 1093.48 | 52.62 | |||
5/31/92 | 1170.70 | 1215.65 | -44.95 | |||
6/30/92 | 1297.80 | 1224.12 | 73.68 | |||
7/31/92 | 1158.90 | 1112.04 | 46.86 | |||
8/31/92 | 1066.00 | 1124.61 | -58.61 | |||
9/30/92 | 1096.30 | 1062.75 | 33.55 | |||
10/31/92 | 1133.00 | 1111.22 | 21.78 | |||
11/30/92 | 989.50 | 997.18 | -7.68 | |||
12/31/92 | 1071.70 | 1046.28 | 25.42 | |||
1/31/93 | 916.10 | 923.52 | -7.42 | |||
2/28/93 | 977.20 | 1044.76 | -67.56 | |||
3/31/93 | 1230.40 | 1225.81 | 4.59 | |||
4/30/93 | 1274.90 | 1150.22 | 124.68 | |||
5/31/93 | 1343.30 | 1295.80 | 47.50 | |||
6/30/93 | 1384.30 | 1326.74 | 57.56 | |||
7/31/93 | 1267.60 | 1200.46 | 67.14 | |||
8/31/93 | 1160.00 | 1217.48 | -57.48 | |||
9/30/93 | 1165.80 | 1151.66 | 14.14 | |||
10/31/93 | 1183.40 | 1198.69 | -15.29 | |||
11/30/93 | 1141.90 | 1067.57 | 74.33 | |||
12/31/93 | 1153.90 | 1139.71 | 14.19 | |||
1/31/94 | 1046.40 | 1003.06 | 43.34 | |||
2/28/94 | 1172.60 | 1147.72 | 24.88 | |||
3/31/94 | 1474.10 | 1373.23 | 100.87 | |||
4/30/94 | 1339.60 | 1308.73 | 30.87 | |||
5/31/94 | 1383.50 | 1446.13 | -62.63 | |||
6/30/94 | 1480.90 | 1453.61 | 27.29 | |||
7/31/94 | 1220.40 | 1307.71 | -87.31 | |||
8/31/94 | 1330.40 | 1289.35 | 41.05 | |||
9/30/94 | 1253.00 | 1241.70 | 11.30 | |||
10/31/94 | 1292.80 | 1291.23 | 1.57 | |||
11/30/94 | 1198.90 | 1153.52 | 45.38 | |||
12/31/94 | 1220.20 | 1222.86 | -2.66 | |||
1/31/95 | 1031.50 | 1072.52 | -41.02 | |||
2/28/95 | 1129.70 | 1204.48 | -74.78 | |||
3/31/95 | 1403.40 | 1413.69 | -10.29 | |||
4/30/95 | 1215.90 | 1322.79 | -106.89 | |||
5/31/95 | 1427.50 | 1427.00 | 0.50 | |||
6/30/95 | 1477.20 | 1448.82 | 28.38 | |||
7/31/95 | 1255.30 | 1303.52 | -48.22 | |||
8/31/95 | 1365.30 | 1294.12 | 71.18 | |||
9/30/95 | 1214.40 | 1252.74 | -38.34 | |||
10/31/95 | 1225.90 | 1290.90 | -65.00 | |||
11/30/95 | 1168.90 | 1139.70 | 29.20 | |||
12/31/95 | 1202.60 | 1204.41 | -1.81 | |||
1/31/96 | 1050.60 | 1056.46 | -5.86 | |||
2/29/96 | 1238.00 | 1195.32 | 42.68 | |||
3/31/96 | 1404.30 | 1434.64 | -30.34 | |||
4/30/96 | 1359.30 | 1338.00 | 21.30 | |||
5/31/96 | 1522.90 | 1475.78 | 47.12 | |||
6/30/96 | 1404.30 | 1509.00 | -104.70 | |||
7/31/96 | 1317.20 | 1330.11 | -12.91 | |||
8/31/96 | 1333.50 | 1328.79 | 4.71 | |||
9/30/96 | 1231.40 | 1271.25 | -39.85 | |||
10/31/96 | 1296.60 | 1309.65 | -13.05 | |||
11/30/96 | 1146.20 | 1167.01 | -20.81 | |||
12/31/96 | 1151.80 | 1221.03 | -69.23 | |||
1/31/97 | 1114.70 | 1057.53 | 57.17 | |||
2/28/97 | 1177.30 | 1212.77 | -35.47 | |||
3/31/97 | 1426.00 | 1434.11 | -8.11 | |||
4/30/97 | 1310.30 | 1342.23 | -31.93 | |||
5/31/97 | 1435.80 | 1467.08 | -31.28 | |||
6/30/97 | 1355.00 | 1481.92 | -126.92 | |||
7/31/97 | 1376.60 | 1301.38 | 75.22 | |||
8/31/97 | 1348.10 | 1320.13 | 27.97 | |||
9/30/97 | 1238.50 | 1267.97 | -29.47 | |||
10/31/97 | 1282.00 | 1308.68 | -26.68 | |||
11/30/97 | 1146.20 | 1163.33 | -17.13 | |||
12/31/97 | 1287.80 | 1217.98 | 69.82 | |||
1/31/98 | 1043.90 | 1082.67 | -38.77 | |||
2/28/98 | 1172.80 | 1216.36 | -43.56 | |||
3/31/98 | 1405.00 | 1436.16 | -31.16 | |||
4/30/98 | 1390.80 | 1339.18 | 51.62 | |||
5/31/98 | 1541.70 | 1484.58 | 57.12 | |||
6/30/98 | 1606.40 | 1519.94 | 86.46 | |||
7/31/98 | 1264.70 | 1378.98 | -114.28 | |||
8/31/98 | 1264.90 | 1354.44 | -89.54 | |||
9/30/98 | 1314.10 | 1275.07 | 39.03 | |||
10/31/98 | 1406.20 | 1332.18 | 74.02 | |||
11/30/98 | 1176.00 | 1204.71 | -28.71 | |||
12/31/98 | 1377.20 | 1258.64 | 118.56 | |||
1/31/99 | 1122.30 | 1127.91 | -5.61 | |||
2/28/99 | 1325.70 | 1276.03 | 49.67 | |||
3/31/99 | 1579.60 | 1532.30 | 47.30 | |||
4/30/99 | 1451.50 | 1445.88 | 5.62 | |||
5/31/99 | 1632.70 | 1590.11 | 42.59 | |||
6/30/99 | 1652.00 | 1623.49 | 28.51 | |||
7/31/99 | 1529.10 | 1459.57 | 69.53 | |||
8/31/99 | 1523.80 | 1476.84 | 46.96 | |||
9/30/99 | 1442.50 | 1421.63 | 20.87 | |||
10/31/99 | 1396.70 | 1479.70 | -83.00 | |||
11/30/99 | 1317.20 | 1304.22 | 12.98 | |||
12/31/99 | 1440.50 | 1373.06 | 67.44 | |||
1/31/00 | 1239.10 | 1217.81 | 21.29 | |||
2/29/00 | 1539.20 | 1384.64 | 154.56 | |||
3/31/00 | 1713.20 | 1689.74 | 23.46 | |||
4/30/00 | 1539.10 | 1588.03 | -48.93 | |||
5/31/00 | 1664.80 | 1732.41 | -67.61 | |||
6/30/00 | 1663.00 | 1742.18 | -79.18 | |||
7/31/00 | 1468.70 | 1543.74 | -75.04 | |||
8/31/00 | 1582.30 | 1527.98 | 54.32 | |||
9/30/00 | 1506.30 | 1471.98 | 34.32 | |||
10/31/00 | 1367.80 | 1534.91 | -167.11 | |||
11/30/00 | 1262.30 | 1336.38 | -74.08 | |||
12/31/00 | 1271.10 | 1385.99 | -114.89 | |||
1/31/01 | 1195.80 | 1192.67 | 3.13 | |||
2/28/01 | 1381.30 | 1351.58 | 29.72 | |||
3/31/01 | 1627.90 | 1616.48 | 11.42 | |||
4/30/01 | 1377.20 | 1516.82 | -139.62 | |||
5/31/01 | 1635.10 | 1631.54 | 3.56 | |||
6/30/01 | 1652.20 | 1656.35 | -4.15 | |||
7/31/01 | 1374.70 | 1482.23 | -107.53 | |||
8/31/01 | 1478.30 | 1459.16 | 19.14 | |||
9/30/01 | 1312.60 | 1398.59 | -85.99 | |||
10/31/01 | 1753.10 | 1430.29 | 322.81 | |||
11/30/01 | 1348.00 | 1342.68 | 5.32 | |||
12/31/01 | 1336.10 | 1411.51 | -75.41 | |||
1/31/02 | 1117.20 | 1222.95 | 1328.70 | |||
2/28/02 | 1278.44 | 1385.01 | 1491.57 | |||
3/31/02 | 1540.69 | 1648.08 | 1755.48 | |||
4/30/02 | 1435.56 | 1543.79 | 1652.02 | |||
5/31/02 | 1587.04 | 1696.13 | 1805.21 | |||
6/30/02 | 1610.97 | 1720.92 | 1830.87 | |||
7/31/02 | 1429.86 | 1540.69 | 1651.52 | |||
8/31/02 | 1430.43 | 1542.15 | 1653.88 | |||
9/30/02 | 1360.88 | 1473.51 | 1586.14 | |||
10/31/02 | 1414.92 | 1528.47 | 1642.03 | |||
11/30/02 | 1249.87 | 1364.36 | 1478.85 | |||
12/31/02 | 1317.43 | 1432.88 | 1548.32 |