Spreadsheet: 103938d1301581913-minimize-sse-sum-of-squared-errors-w-o-solver-tool-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Monthly | t | Visits | Smoothed Est. for Level | Forecast Made Last Period | Forecast Error | Forecast LCI | Forecast UCI | Point Forecasts |  |  |  |  |  |  |  |  | n
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alpha | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-08 00:00:00 | 1 | 421334 | 644750 |  |  |  |  |  |  |  |  |  |  |  |  |  | SSE
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-08 00:00:00 | 2 | 592641 | 629117 |  |  |  |  |  |  |  |  |  |  |  |  |  | s2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-08 00:00:00 | 3 | 684385 | 645698 |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-08 00:00:00 | 4 | 675478 | 654632 |  |  |  |  |  |  |  |  |  |  |  |  |  | Conf. | 0.95
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-08 00:00:00 | 5 | 812819 | 702088 |  |  |  |  |  |  |  |  |  |  |  |  |  | MAPE
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-08 00:00:00 | 6 | 818145 | 736905
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-08 00:00:00 | 7 | 887599 | 782113
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-08 00:00:00 | 8 | 795421 | 786106
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-08 00:00:00 | 9 | 704366 | 761584
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-08 00:00:00 | 10 | 899786 | 803044
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-08 00:00:00 | 11 | 937764 | 843460
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-08 00:00:00 | 12 | 656255 | 787299
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | 13 | 844402 | 804430
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-09 00:00:00 | 14 | 827983 | 811496
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-09 00:00:00 | 15 | 1038269 | 879528
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-09 00:00:00 | 16 | 1186183 | 971524
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-09 00:00:00 | 17 | 1262292 | 1058755
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-09 00:00:00 | 18 | 1352374 | 1146840
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-09 00:00:00 | 19 | 1470009 | 1243791
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-09 00:00:00 | 20 | 1581728 | 1345172
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-09 00:00:00 | 21 | 1398300 | 1361110
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-09 00:00:00 | 22 | 1234417 | 1323102
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-09 00:00:00 | 23 | 1150286 | 1271257
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-09 00:00:00 | 24 | 936423 | 1170807
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-10 00:00:00 | 25 | 1067632 | 1139855
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-10 00:00:00 | 26 | 1094369 | 1126209
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-10 00:00:00 | 27 | 1491729 | 1235865
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-10 00:00:00 | 28 | 1674670 | 1367506
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-10 00:00:00 | 29 | 1811798 | 1500794
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-10 00:00:00 | 30 | 2012752 | 1654381
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-10 00:00:00 | 31 | 2247875 | 1832429
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-10 00:00:00 | 32 | 2182425 | 1937428
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-10 00:00:00 | 33 | 1911073 | 1929522
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-10 00:00:00 | 34 | 1727106 | 1868797
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-10 00:00:00 | 35 | 1413768 | 1732288
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-10 00:00:00 | 36 | 1164043 | 1561815
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 00:00:00 | 37 | 1421069 | 1519591
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 38 | 1508090 | 1516141
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | 39 | 1785794 | 1597037
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-11 00:00:00 | 40
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-11 00:00:00 | 41
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00 | 42