Holts Linear in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Holts Linear capabilities.
For further information visit UNISTAT User's Guide section 9.2.2. Holts Linear.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Holt’s Linear
| Level Smoothing Constant | 0.2000 |
|---|---|
| Trend Smoothing Constant | 0.1000 |
| Sum of Squares | 3224162.8564 |
Summary Table
| Row | Cola Sales | Forecast | Lower 95% | Upper 95% | Level | Trend |
|---|---|---|---|---|---|---|
| 1 | 189.0000 | 347.1053 | * | * | 315.4842 | 8.0747 |
| 2 | 229.0000 | 323.5589 | -63.7919 | 710.9098 | 304.6472 | 6.1836 |
| 3 | 249.0000 | 310.8307 | 1.3227 | 620.3387 | 298.4646 | 4.9469 |
| 4 | 289.0000 | 303.4115 | 46.5787 | 560.2443 | 300.5292 | 4.6587 |
| 5 | 260.0000 | 305.1879 | 103.7364 | 506.6394 | 296.1503 | 3.7550 |
| 6 | 431.0000 | 299.9053 | 116.6024 | 483.2082 | 326.1242 | 6.3768 |
| 7 | 660.0000 | 332.5011 | 126.2193 | 538.7829 | 398.0009 | 12.9268 |
| 8 | 777.0000 | 410.9277 | 119.4922 | 702.3632 | 484.1422 | 20.2483 |
| 9 | 915.0000 | 504.3904 | 137.2768 | 871.5041 | 586.5123 | 28.4605 |
| 10 | 613.0000 | 614.9728 | 176.8746 | 1053.0710 | 614.5782 | 28.4210 |
| 11 | 485.0000 | 642.9993 | 248.2275 | 1037.7710 | 611.3994 | 25.2610 |
| 12 | 277.0000 | 636.6604 | 242.5869 | 1030.7339 | 564.7283 | 18.0678 |
| 13 | 244.0000 | 582.7962 | 148.1328 | 1017.4595 | 515.0369 | 11.2919 |
| 14 | 296.0000 | 526.3288 | 61.2522 | 991.4054 | 480.2631 | 6.6853 |
| 15 | 319.0000 | 486.9484 | 14.7847 | 959.1120 | 453.3587 | 3.3263 |
| 16 | 370.0000 | 456.6850 | -11.4321 | 924.8022 | 439.3480 | 1.5926 |
| 17 | 313.0000 | 440.9407 | -11.1925 | 893.0739 | 415.3525 | -0.9662 |
| 18 | 556.0000 | 414.3864 | -29.5889 | 858.3617 | 442.7091 | 1.8661 |
| 19 | 831.0000 | 444.5752 | 5.9903 | 883.1601 | 521.8602 | 9.5946 |
| 20 | 960.0000 | 531.4548 | 66.1258 | 996.7838 | 617.1638 | 18.1655 |
| 21 | 1152.0000 | 635.3293 | 140.7709 | 1129.8877 | 738.6635 | 28.4989 |
| 22 | 759.0000 | 767.1624 | 235.8773 | 1298.4475 | 765.5299 | 28.3357 |
| 23 | 607.0000 | 793.8656 | 285.8208 | 1301.9104 | 756.4925 | 24.5984 |
| 24 | 371.0000 | 781.0908 | 275.2301 | 1286.9516 | 699.0727 | 16.3965 |
| 25 | 298.0000 | 715.4692 | 188.8233 | 1242.1151 | 631.9754 | 8.0472 |
| 26 | 378.0000 | 640.0225 | 93.5312 | 1186.5138 | 587.6180 | 2.8067 |
| 27 | 373.0000 | 590.4247 | 40.2622 | 1140.5873 | 546.9398 | -1.5418 |
| 28 | 443.0000 | 545.3980 | -4.1171 | 1094.9131 | 524.9184 | -3.5897 |
| 29 | 374.0000 | 521.3287 | -17.5205 | 1060.1778 | 491.8629 | -6.5363 |
| 30 | 660.0000 | 485.3266 | -47.3881 | 1018.0413 | 520.2613 | -3.0428 |
| 31 | 1004.0000 | 517.2184 | -12.0038 | 1046.4407 | 614.5747 | 6.6928 |
| 32 | 1153.0000 | 621.2675 | 70.6462 | 1171.8888 | 727.6140 | 17.3274 |
| 33 | 1388.0000 | 744.9415 | 170.8170 | 1319.0659 | 873.5532 | 30.1886 |
| 34 | 904.0000 | 903.7418 | 299.2737 | 1508.2098 | 903.7934 | 30.1938 |
| 35 | 715.0000 | 933.9872 | 347.2790 | 1520.6954 | 890.1897 | 25.8140 |
| 36 | 441.0000 | 916.0038 | 330.7298 | 1501.2777 | 821.0030 | 16.3139 |
| 37 | 837.3170 | 235.9746 | 1438.6593 | |||
| 38 | 853.6309 | 239.7592 | 1467.5026 | |||
| 39 | 869.9449 | 242.5799 | 1497.3098 | |||
| 40 | 886.2588 | 244.4973 | 1528.0203 | |||
| 41 | 902.5728 | 245.5710 | 1559.5745 | |||
| 42 | 918.8867 | 245.8581 | 1591.9153 | |||
| 43 | 935.2006 | 245.4136 | 1624.9877 | |||
| 44 | 951.5146 | 244.2895 | 1658.7397 | |||
| 45 | 967.8285 | 242.5346 | 1693.1225 | |||
| 46 | 984.1425 | 240.1951 | 1728.0899 | |||
| 47 | 1000.4564 | 237.3138 | 1763.5991 | |||
| 48 | 1016.7704 | 233.9305 | 1799.6103 |
