Monthly shampoo sales over three years | Single Exponential Smoothing | |||||||
Alpha | 0.416859 | MSE(SES) | 7075.29 | |||||
t | Yt | Ft | Deviation | SquaredDeviation | ||||
1 | 266 | |||||||
2 | 145.9 | 266 | -120.1 | 14424.01 | Note: | |||
3 | 183.1 | 215.9353 | -32.8353 | 1078.15431 | Use Solver to minimize the MSE | |||
4 | 119.3 | 202.2476 | -82.9476 | 6880.303279 | by varying Alpha | |||
5 | 180.3 | 167.6702 | 12.62984 | 159.5128417 | ||||
6 | 168.5 | 172.935 | -4.43502 | 19.66940345 | ||||
7 | 231.8 | 171.0862 | 60.71376 | 3686.160286 | ||||
8 | 224.5 | 196.3953 | 28.10469 | 789.8738321 | ||||
9 | 192.8 | 208.111 | -15.311 | 234.4265514 | ||||
10 | 122.9 | 201.7285 | -78.8285 | 6213.927989 | ||||
11 | 336.5 | 168.8681 | 167.6319 | 28100.44348 | ||||
12 | 185.9 | 238.7469 | -52.8469 | 2792.799907 | ||||
13 | 194.3 | 216.7172 | -22.4172 | 502.5323594 | ||||
14 | 149.5 | 207.3724 | -57.8724 | 3349.216169 | ||||
15 | 210.1 | 183.2478 | 26.85221 | 721.0412217 | ||||
16 | 273.3 | 194.4414 | 78.85863 | 6218.68366 | ||||
17 | 191.4 | 227.3143 | -35.9143 | 1289.835654 | ||||
18 | 287 | 212.3431 | 74.6569 | 5573.652996 | ||||
19 | 226 | 243.4645 | -17.4645 | 305.00818 | ||||
20 | 303.6 | 236.1843 | 67.41574 | 4544.881987 | ||||
21 | 289.9 | 264.2871 | 25.6129 | 656.0204729 | ||||
22 | 421.6 | 274.9641 | 146.6359 | 21502.09764 | ||||
23 | 264.5 | 336.0905 | -71.5905 | 5125.205704 | ||||
24 | 342.3 | 306.2474 | 36.0526 | 1299.790271 | ||||
25 | 339.7 | 321.2762 | 18.42376 | 339.434914 | ||||
26 | 440.4 | 328.9563 | 111.4437 | 12419.68791 | ||||
27 | 315.9 | 375.4126 | -59.5126 | 3541.751017 | ||||
28 | 439.3 | 350.6043 | 88.69574 | 7866.934802 | ||||
29 | 401.3 | 387.5779 | 13.72214 | 188.2972205 | ||||
30 | 437.4 | 393.2981 | 44.10195 | 1944.981767 | ||||
31 | 575.5 | 411.6823 | 163.8177 | 26836.22681 | ||||
32 | 407.6 | 479.9712 | -72.3712 | 5237.586024 | ||||
33 | 682 | 449.8026 | 232.1974 | 53915.62734 | ||||
34 | 475.3 | 546.5961 | -71.2961 | 5083.138458 | ||||
35 | 581.3 | 516.8757 | 64.42429 | 4150.488721 | ||||
36 | 646.9 | 543.7315 | 103.1685 | 10643.73051 |