Winters Additive Seasonal in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Winters Additive Seasonal capabilities.
For further information visit UNISTAT User's Guide section 9.2.3. Winters Additive Seasonal.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Winters’ Additive Seasonal
| Level Smoothing Constant | 0.2000 |
|---|---|
| Trend Smoothing Constant | 0.1000 |
| Seasonal Smoothing Constant | 0.0500 |
| Seasonal Period | 12 |
| Sum of Squares | 92856.6862 |
Summary Table
| Row | Cola Sales | Forecast | Lower 95% | Upper 95% | Level | Trend | Seasonal |
|---|---|---|---|---|---|---|---|
| 1 | 189.0000 | 132.8698 | * | * | 411.1948 | 10.6955 | -264.8537 |
| 2 | 229.0000 | 202.5518 | 65.0353 | 340.0683 | 427.1800 | 11.2245 | -218.2806 |
| 3 | 249.0000 | 222.1597 | 121.0029 | 323.3164 | 443.7725 | 11.7613 | -215.1712 |
| 4 | 289.0000 | 283.3828 | 194.0257 | 372.7398 | 456.6573 | 11.8736 | -171.9264 |
| 5 | 260.0000 | 235.1403 | 164.6820 | 305.5985 | 473.5028 | 12.3708 | -232.3962 |
| 6 | 431.0000 | 476.2435 | 407.6958 | 544.7911 | 476.8250 | 11.4660 | -11.4399 |
| 7 | 660.0000 | 751.7545 | 676.1573 | 827.3516 | 469.9400 | 9.6309 | 259.7934 |
| 8 | 777.0000 | 865.1282 | 768.2172 | 962.0392 | 461.9453 | 7.8683 | 382.0322 |
| 9 | 915.0000 | 1034.1313 | 922.3454 | 1145.9172 | 445.9873 | 5.4857 | 559.5525 |
| 10 | 613.0000 | 613.2178 | 481.4229 | 745.0126 | 451.4294 | 5.4813 | 161.7361 |
| 11 | 485.0000 | 452.7493 | 334.0806 | 571.4180 | 463.3609 | 6.1263 | -2.8714 |
| 12 | 277.0000 | 216.4195 | 101.3559 | 331.4832 | 481.6033 | 7.3379 | -250.6445 |
| 13 | 244.0000 | 224.0875 | 106.2443 | 341.9308 | 492.9238 | 7.7362 | -264.0573 |
| 14 | 296.0000 | 282.3794 | 169.8483 | 394.9104 | 503.3841 | 8.0086 | -217.7358 |
| 15 | 319.0000 | 296.2215 | 189.3448 | 403.0983 | 515.9484 | 8.4642 | -214.2600 |
| 16 | 370.0000 | 352.4862 | 249.0142 | 455.9583 | 527.9153 | 8.8145 | -171.2258 |
| 17 | 313.0000 | 304.3336 | 204.6468 | 404.0203 | 538.4631 | 8.9878 | -232.0496 |
| 18 | 556.0000 | 536.0109 | 440.9391 | 631.0827 | 551.4487 | 9.3876 | -10.6404 |
| 19 | 831.0000 | 820.6296 | 728.1189 | 913.1403 | 562.9103 | 9.5950 | 260.2082 |
| 20 | 960.0000 | 954.5375 | 865.5585 | 1043.5164 | 573.5978 | 9.7042 | 382.2507 |
| 21 | 1152.0000 | 1142.8545 | 1057.6554 | 1228.0536 | 585.1311 | 9.8871 | 559.9183 |
| 22 | 759.0000 | 756.7544 | 674.5454 | 838.9633 | 595.4674 | 9.9320 | 161.8259 |
| 23 | 607.0000 | 602.5280 | 523.8057 | 681.2503 | 606.2938 | 10.0215 | -2.6926 |
| 24 | 371.0000 | 365.6708 | 289.8949 | 441.4468 | 617.3812 | 10.1281 | -250.4313 |
| 25 | 298.0000 | 363.4520 | 290.2894 | 436.6146 | 614.4188 | 8.8190 | -266.6753 |
| 26 | 378.0000 | 405.5021 | 328.8518 | 482.1524 | 617.7375 | 8.2690 | -218.8359 |
| 27 | 373.0000 | 411.7464 | 335.4527 | 488.0401 | 618.2572 | 7.4941 | -215.8099 |
| 28 | 443.0000 | 454.5254 | 377.5416 | 531.5092 | 623.4461 | 7.2636 | -171.6868 |
| 29 | 374.0000 | 398.6601 | 323.4173 | 473.9030 | 625.7777 | 6.7704 | -233.0360 |
| 30 | 660.0000 | 621.9076 | 547.1760 | 696.6392 | 640.1665 | 7.5322 | -9.1167 |
| 31 | 1004.0000 | 907.9069 | 832.5555 | 983.2582 | 666.9173 | 9.4541 | 264.0519 |
| 32 | 1153.0000 | 1058.6220 | 978.1071 | 1139.1370 | 695.2470 | 11.3416 | 386.0258 |
| 33 | 1388.0000 | 1266.5069 | 1181.2823 | 1351.7314 | 730.8872 | 13.7715 | 564.7780 |
| 34 | 904.0000 | 906.4846 | 814.8228 | 998.1464 | 744.1618 | 13.7218 | 161.7265 |
| 35 | 715.0000 | 755.1910 | 666.0461 | 844.3359 | 749.8454 | 12.9180 | -4.3002 |
| 36 | 441.0000 | 512.3320 | 422.9208 | 601.7432 | 748.4969 | 11.4913 | -253.2846 |
| 37 | 493.3129 | 401.5309 | 585.0949 | ||||
| 38 | 552.6437 | 458.9494 | 646.3381 | ||||
| 39 | 567.1610 | 471.4072 | 662.9148 | ||||
| 40 | 622.7754 | 524.8243 | 720.7266 | ||||
| 41 | 572.9176 | 472.6404 | 673.1948 | ||||
| 42 | 808.3282 | 705.6048 | 911.0516 | ||||
| 43 | 1092.9881 | 987.7069 | 1198.2693 | ||||
| 44 | 1226.4534 | 1118.5106 | 1334.3961 | ||||
| 45 | 1416.6969 | 1305.9963 | 1527.3975 | ||||
| 46 | 1025.1368 | 911.5891 | 1138.6844 | ||||
| 47 | 870.6014 | 754.1240 | 987.0787 | ||||
| 48 | 633.1083 | 513.6246 | 752.5920 |
