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