Winters Multiplicative Seasonal in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Winters Multiplicative Seasonal capabilities.
For further information visit UNISTAT User's Guide section 9.2.4. Winters Multiplicative Seasonal.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Winters’ Multiplicative Seasonal
| Level Smoothing Constant | 0.2000 |
|---|---|
| Trend Smoothing Constant | 0.1000 |
| Seasonal Smoothing Constant | 0.0500 |
| Seasonal Period | 12 |
| Sum of Squares | 2291.9256 |
Summary Table
| Row | Cola Sales | Forecast | Lower 95% | Upper 95% | Level | Trend | Seasonal |
|---|---|---|---|---|---|---|---|
| 1 | 189.0000 | 193.6418 | * | * | 398.0512 | 9.3812 | 0.4837 |
| 2 | 229.0000 | 238.2254 | 214.7358 | 261.7150 | 404.2767 | 9.0656 | 0.5838 |
| 3 | 249.0000 | 248.9011 | 217.8285 | 279.9736 | 413.3752 | 9.0689 | 0.6022 |
| 4 | 289.0000 | 291.9661 | 271.1169 | 312.8153 | 421.5858 | 8.9831 | 0.6909 |
| 5 | 260.0000 | 252.2613 | 233.9958 | 270.5268 | 433.2106 | 9.2472 | 0.5866 |
| 6 | 431.0000 | 440.9282 | 419.8437 | 462.0127 | 440.4653 | 9.0480 | 0.9956 |
| 7 | 660.0000 | 667.1568 | 645.5183 | 688.7952 | 448.5488 | 8.9515 | 1.4835 |
| 8 | 777.0000 | 774.4063 | 754.1714 | 794.6412 | 457.8068 | 8.9822 | 1.6929 |
| 9 | 915.0000 | 927.4468 | 909.2720 | 945.6216 | 465.5361 | 8.8569 | 1.9858 |
| 10 | 613.0000 | 611.8198 | 593.9592 | 629.6805 | 474.5760 | 8.8752 | 1.2898 |
| 11 | 485.0000 | 487.0187 | 470.7199 | 503.3175 | 483.0504 | 8.8351 | 1.0072 |
| 12 | 277.0000 | 292.4919 | 277.2284 | 307.7553 | 486.6750 | 8.3141 | 0.5934 |
| 13 | 244.0000 | 239.4143 | 220.1039 | 258.7248 | 496.8852 | 8.5037 | 0.4840 |
| 14 | 296.0000 | 295.0392 | 275.4274 | 314.6510 | 505.7181 | 8.5366 | 0.5839 |
| 15 | 319.0000 | 309.6720 | 291.1731 | 328.1710 | 517.3527 | 8.8464 | 0.6029 |
| 16 | 370.0000 | 363.5268 | 343.7310 | 383.3225 | 528.0731 | 9.0338 | 0.6913 |
| 17 | 313.0000 | 315.0635 | 295.0703 | 335.0568 | 536.4034 | 8.9634 | 0.5864 |
| 18 | 556.0000 | 542.9897 | 523.6656 | 562.3139 | 547.9802 | 9.2248 | 0.9966 |
| 19 | 831.0000 | 826.6347 | 806.6055 | 846.6638 | 557.7935 | 9.2836 | 1.4839 |
| 20 | 960.0000 | 960.0143 | 940.6599 | 979.3688 | 567.0755 | 9.2835 | 1.6929 |
| 21 | 1152.0000 | 1144.5310 | 1126.1433 | 1162.9188 | 577.1112 | 9.3587 | 1.9863 |
| 22 | 759.0000 | 756.4226 | 738.4717 | 774.3735 | 586.8695 | 9.3987 | 1.2900 |
| 23 | 607.0000 | 600.5685 | 583.2110 | 617.9260 | 597.5453 | 9.5264 | 1.0076 |
| 24 | 371.0000 | 360.2125 | 342.9294 | 377.4955 | 610.7077 | 9.8900 | 0.5941 |
| 25 | 298.0000 | 300.3973 | 281.9785 | 318.8161 | 619.6072 | 9.7909 | 0.4839 |
| 26 | 378.0000 | 367.4819 | 349.3146 | 385.6493 | 633.0010 | 10.1512 | 0.5845 |
| 27 | 373.0000 | 387.7550 | 368.5888 | 406.9211 | 638.2576 | 9.6617 | 0.6020 |
| 28 | 443.0000 | 447.9353 | 427.2584 | 468.6123 | 646.4916 | 9.5190 | 0.6910 |
| 29 | 374.0000 | 384.7107 | 364.1476 | 405.2738 | 652.3577 | 9.1537 | 0.5858 |
| 30 | 660.0000 | 659.2564 | 637.8594 | 680.6534 | 661.6607 | 9.1686 | 0.9966 |
| 31 | 1004.0000 | 995.4106 | 974.6659 | 1016.1553 | 671.9870 | 9.2844 | 1.4844 |
| 32 | 1153.0000 | 1153.3350 | 1132.8020 | 1173.8680 | 681.2318 | 9.2804 | 1.6929 |
| 33 | 1388.0000 | 1371.5737 | 1351.6672 | 1391.4802 | 692.1662 | 9.4458 | 1.9873 |
| 34 | 904.0000 | 905.0550 | 885.1378 | 924.9722 | 701.4485 | 9.4295 | 1.2899 |
| 35 | 715.0000 | 716.3108 | 696.9205 | 735.7012 | 710.6178 | 9.4035 | 1.0076 |
| 36 | 441.0000 | 427.7410 | 408.8136 | 446.6684 | 724.4850 | 9.8498 | 0.5948 |
| 37 | 355.3376 | 335.4170 | 375.2581 | ||||
| 38 | 434.9961 | 414.6605 | 455.3317 | ||||
| 39 | 453.9084 | 433.1258 | 474.6910 | ||||
| 40 | 527.8738 | 506.6143 | 549.1333 | ||||
| 41 | 453.2404 | 431.4760 | 475.0048 | ||||
| 42 | 780.9480 | 758.6527 | 803.2433 | ||||
| 43 | 1177.7431 | 1154.8927 | 1200.5935 | ||||
| 44 | 1359.8756 | 1336.4475 | 1383.3037 | ||||
| 45 | 1615.9097 | 1591.8831 | 1639.9364 | ||||
| 46 | 1061.5702 | 1036.9256 | 1086.2148 | ||||
| 47 | 839.1367 | 813.8562 | 864.4171 | ||||
| 48 | 501.2273 | 475.2943 | 527.1602 |
