Browns Exponential in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Browns Exponential capabilities.
For further information visit UNISTAT User's Guide section 9.2.1. Browns Exponential.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Brown’s Exponential
| Level Smoothing Constant | 0.2000 |
|---|---|
| Sum of Squares | 3029058.7929 |
Summary Table
| Row | Cola Sales | Forecast | Lower 95% | Upper 95% | Level |
|---|---|---|---|---|---|
| 1 | 189.0000 | 461.2000 | * | * | 406.7600 |
| 2 | 229.0000 | 406.7600 | -260.1178 | 1073.6378 | 371.2080 |
| 3 | 249.0000 | 371.2080 | -179.9829 | 922.3989 | 346.7664 |
| 4 | 289.0000 | 346.7664 | -120.4956 | 814.0284 | 335.2131 |
| 5 | 260.0000 | 335.2131 | -50.6146 | 721.0409 | 320.1705 |
| 6 | 431.0000 | 320.1705 | -25.3455 | 665.6865 | 342.3364 |
| 7 | 660.0000 | 342.3364 | 9.1519 | 675.5209 | 405.8691 |
| 8 | 777.0000 | 405.8691 | 9.1022 | 802.6361 | 480.0953 |
| 9 | 915.0000 | 480.0953 | 19.2674 | 940.9231 | 567.0762 |
| 10 | 613.0000 | 567.0762 | 39.0629 | 1095.0896 | 576.2610 |
| 11 | 485.0000 | 576.2610 | 89.7979 | 1062.7241 | 558.0088 |
| 12 | 277.0000 | 558.0088 | 95.4437 | 1020.5739 | 501.8070 |
| 13 | 244.0000 | 501.8070 | 20.4174 | 983.1966 | 450.2456 |
| 14 | 296.0000 | 450.2456 | -42.6998 | 943.1911 | 419.3965 |
| 15 | 319.0000 | 419.3965 | -65.3311 | 904.1241 | 399.3172 |
| 16 | 370.0000 | 399.3172 | -69.4930 | 868.1274 | 393.4538 |
| 17 | 313.0000 | 393.4538 | -50.5449 | 837.4524 | 377.3630 |
| 18 | 556.0000 | 377.3630 | -52.1127 | 806.8387 | 413.0904 |
| 19 | 831.0000 | 413.0904 | -16.8396 | 843.0204 | 496.6723 |
| 20 | 960.0000 | 496.6723 | 35.4829 | 957.8618 | 589.3379 |
| 21 | 1152.0000 | 589.3379 | 94.4513 | 1084.2244 | 701.8703 |
| 22 | 759.0000 | 701.8703 | 164.9070 | 1238.8335 | 713.2962 |
| 23 | 607.0000 | 713.2962 | 194.3783 | 1232.2141 | 692.0370 |
| 24 | 371.0000 | 692.0370 | 184.3581 | 1199.7159 | 627.8296 |
| 25 | 298.0000 | 627.8296 | 108.5321 | 1147.1271 | 561.8637 |
| 26 | 378.0000 | 561.8637 | 31.0153 | 1092.7120 | 525.0909 |
| 27 | 373.0000 | 525.0909 | -2.6655 | 1052.8473 | 494.6727 |
| 28 | 443.0000 | 494.6727 | -27.3377 | 1016.6832 | 484.3382 |
| 29 | 374.0000 | 484.3382 | -23.5503 | 992.2267 | 462.2706 |
| 30 | 660.0000 | 462.2706 | -37.4261 | 961.9672 | 501.8164 |
| 31 | 1004.0000 | 501.8164 | 2.6288 | 1001.0041 | 602.2532 |
| 32 | 1153.0000 | 602.2532 | 79.4803 | 1125.0260 | 712.4025 |
| 33 | 1388.0000 | 712.4025 | 163.8006 | 1261.0045 | 847.5220 |
| 34 | 904.0000 | 847.5220 | 265.3873 | 1429.6567 | 858.8176 |
| 35 | 715.0000 | 858.8176 | 289.7348 | 1427.9004 | 830.0541 |
| 36 | 441.0000 | 830.0541 | 267.1638 | 1392.9444 | 752.2433 |
| 37 | 752.2433 | 178.5120 | 1325.9746 | ||
| 38 | 752.2433 | 166.5580 | 1337.9286 | ||
| 39 | 752.2433 | 153.6842 | 1350.8023 | ||
| 40 | 752.2433 | 139.9488 | 1364.5378 | ||
| 41 | 752.2433 | 125.4082 | 1379.0783 | ||
| 42 | 752.2433 | 110.1173 | 1394.3692 | ||
| 43 | 752.2433 | 94.1284 | 1410.3582 | ||
| 44 | 752.2433 | 77.4909 | 1426.9956 | ||
| 45 | 752.2433 | 60.2518 | 1444.2348 | ||
| 46 | 752.2433 | 42.4548 | 1462.0317 | ||
| 47 | 752.2433 | 24.1409 | 1480.3456 | ||
| 48 | 752.2433 | 5.3481 | 1499.1385 |
