Spreadsheet: 103948d1301585949-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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSE
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-08 00:00:00 | 2 | 592641 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s2
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-08 00:00:00 | 3 | 684385 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-08 00:00:00 | 4 | 675478 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conf. | 0.95
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-08 00:00:00 | 5 | 812819 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAPE
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-08 00:00:00 | 6 | 818145
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-08 00:00:00 | 7 | 887599
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-08 00:00:00 | 8 | 795421
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-08 00:00:00 | 9 | 704366
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-08 00:00:00 | 10 | 899786
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-08 00:00:00 | 11 | 937764
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-08 00:00:00 | 12 | 656255
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | 13 | 844402
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-09 00:00:00 | 14 | 827983
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-09 00:00:00 | 15 | 1038269
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-09 00:00:00 | 16 | 1186183
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-09 00:00:00 | 17 | 1262292
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-09 00:00:00 | 18 | 1352374
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-09 00:00:00 | 19 | 1470009
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-09 00:00:00 | 20 | 1581728
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-09 00:00:00 | 21 | 1398300
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-09 00:00:00 | 22 | 1234417
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-09 00:00:00 | 23 | 1150286
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-09 00:00:00 | 24 | 936423
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-10 00:00:00 | 25 | 1067632
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-10 00:00:00 | 26 | 1094369
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-10 00:00:00 | 27 | 1491729
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-10 00:00:00 | 28 | 1674670
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-10 00:00:00 | 29 | 1811798
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-10 00:00:00 | 30 | 2012752
 |  |  |  |  |  |  |  |  |  |  |  | 2011-07-10 00:00:00 | 31 | 2247875
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-10 00:00:00 | 32 | 2182425
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-10 00:00:00 | 33 | 1911073
 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-10 00:00:00 | 34 | 1727106
 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-10 00:00:00 | 35 | 1413768
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-10 00:00:00 | 36 | 1164043
 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 00:00:00 | 37 | 1421069
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 38 | 1508090
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | 39 | 1785794
 |  |  |  |  |  |  |  |  |  |  |  | 2011-04-11 00:00:00 | 40
 |  |  |  |  |  |  |  |  |  |  |  | 2011-05-11 00:00:00 | 41
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00 | 42