Spreadsheet: 539677d1506331666-forecasting-seasonal-forecast-test-25092017
Sheet: STOEL

Sales | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 |  | Total
 | 2015 | 171.25 | 171.25 | 171.25 | 171.25 | 121 | 121 | 121 | 121 | 165 | 256 | 319 | 208 | 412 | 187 | 312 | 462 | 542 | 684 | 1633 | 1825 | 1212 | 1065 | 2279 | 1588 | 1468 | 1619 | 1432 | 1539 | 979 | 1635 | 1064 | 1014 | 1201 | 936 | 1395 | 1189 | 1628 | 1339 | 1216 | 1068 | 1074 | 1172 | 953 | 719 | 667 | 792 | 564 | 525 | 494 | 245 | 225 | 171 |  | 41472
 | 2016 | 213 | 137 | 117 | 124 | 126 | 129 | 152 | 544 | 278 | 373 | 554 | 555 | 428 | 532 | 521 | 942 | 630 | 754 | 1255 | 630 | 990 | 2422 | 1845 | 1746 | 1605 | 1489 | 2742 | 1508 | 2416 | 1465 | 1297 | 1308 | 1171 | 1013 | 1082 | 1569 | 1694 | 1556 | 2049 | 1577 | 1240 | 1160 | 1135 | 979 | 870 | 877 | 725 | 821 | 736 | 926 | 628 | 386 |  | 50479
 | 2017 | 162 | 111 | 38 | 123 | 73 | 96 | 115 | 52 | 339 | 270 | 325 | 411 | 647 | 458 | 545 | 525 | 634 | 709 | 954 | 1177 | 1819 | 2508 | 1994 | 2326 | 2539 | 1672 | 1434 | 1257 | 1421 | 2268 | 1728 | 2462 | 1282 | 1248 | 1226 | 1857 | 1761 | 2031 | 1770 | 1567 | 1093 | 1142 | 1071 | 179 |  |  |  |  |  |  |  |  |  | 47419
 | 2018 | 303.0523900838241 | 234.5518886782144 | 184.0457252274226 | 237.8979860869649 | 183.5080551780569 | 200.0335316989024 | 226.1266004328726 | 421.2155875146589 | 463.0521980890684 | 536.5297472387995 | 720.5684934412676 | 711.6143790392056 | 908.280490898673 | 724.4234569824165 | 854.5693087911955 | 1205.279352609921 | 1136.858465600409 | 1361.53864171965 | 2454.375568001636 | 2337.179300866293 | 2606.273176404154 | 3913.741914405278 | 4022.605004420386 | 3747.894605807394 | 3742.312331278816 | 3209.817972017395 | 3792.011596805936 | 2930.369276101226 | 3301.44891943909 | 3704.91696795213 | 2841.260648954811 | 3346.520751375454 | 2573.11936030671 | 2266.229936016548 | 2642.202829222039 | 3314.489569797896 | 3674.338952848915 | 3583.847758913922 | 3686.657325552322 | 3103.717268440608 | 2526.439955202736 | 2592.343229583619 | 2372.035325826419 | 1418.168538741953 | 1752.686184961413 | 1914.898303341907 | 1487.939232015186 | 1563.162943343608 | 1437.061724609006 | 1376.330457165499 | 1008.544235889563 | 662.4696292820847 |  | 101520.5570942035
 | Total | 546.25 | 419.25 | 326.25 | 418.25 | 320 | 346 | 388 | 717 | 782 | 899 | 1198 | 1174 | 1487 | 1177 | 1378 | 1929 | 1806 | 2147 | 3842 | 3632 | 4021 | 5995 | 6118 | 5660 | 5612 | 4780 | 5608 | 4304 | 4816 | 5368 | 4089 | 4784 | 3654 | 3197 | 3703 | 4615 | 5083 | 4926 | 5035 | 4212 | 3407 | 3474 | 3159 | 1877 | 1537 | 1669 | 1289 | 1346 | 1230 | 1171 | 853 | 557 |  | 139370
 | Weekly Average | 182.0833333333333 | 139.75 | 108.75 | 139.4166666666667 | 106.6666666666667 | 115.3333333333333 | 129.3333333333333 | 239 | 260.6666666666667 | 299.6666666666667 | 399.3333333333333 | 391.3333333333333 | 495.6666666666667 | 392.3333333333333 | 459.3333333333333 | 643 | 602 | 715.6666666666666 | 1280.666666666667 | 1210.666666666667 | 1340.333333333333 | 1998.333333333333 | 2039.333333333333 | 1886.666666666667 | 1870.666666666667 | 1593.333333333333 | 1869.333333333333 | 1434.666666666667 | 1605.333333333333 | 1789.333333333333 | 1363 | 1594.666666666667 | 1218 | 1065.666666666667 | 1234.333333333333 | 1538.333333333333 | 1694.333333333333 | 1642 | 1678.333333333333 | 1404 | 1135.666666666667 | 1158 | 1053 | 625.6666666666666 | 768.5 | 834.5 | 644.5 | 673 | 615 | 585.5 | 426.5 | 278.5 |  | 46456.66666666666
 | Seasonal Indices | 0.003919423118318146 | 0.003008179665638229 | 0.002340891153045849 | 0.003001004520341537 | 0.002296046494941523 | 0.002482600272655521 | 0.002783956375116596 | 0.005144579177728349 | 0.005610963622013346 | 0.00645045562172634 | 0.008595824065437326 | 0.00842362057831671 | 0.01066944105618139 | 0.008445146014206787 | 0.009887350218841932 | 0.01384085527731937 | 0.01295831240582622 | 0.01540503695199828 | 0.02756690822989166 | 0.02606012771758628 | 0.02885125923799957 | 0.04301499605367009 | 0.04389753892516324 | 0.04061132237927818 | 0.04026691540503696 | 0.03429719451818899 | 0.04023821482385018 | 0.03088182535696348 | 0.03455549974886991 | 0.03851617995264404 | 0.02933916911817465 | 0.03432589509937577 | 0.02621798091411351 | 0.02293893951352515 | 0.02656956303365143 | 0.03311329554423477 | 0.03647126354308675 | 0.03534476573150606 | 0.03612685656884552 | 0.03022171198966779 | 0.02444572002583053 | 0.02492645476070891 | 0.02266628399225084 | 0.01346774772189137 | 0.016542297481524 | 0.01796297625026907 | 0.01387314343115448 | 0.01448661835402167 | 0.01323814307239722 | 0.01260314271363995 | 0.009180598407117744 | 0.005994833895386382
 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 2015 | 43692.65446224256 | 56928.11568276685 | 73155.90038314176 | 57064.22594142259 | 52699.28125 | 48739.21965317919 | 43463.32474226804 | 23519.90237099024 | 29406.71355498721 | 39687.11902113459 | 37111.04340567612 | 24692.47018739353 | 38614.95628782784 | 22142.89719626168 | 31555.4716981132 | 33379.4401244168 | 41826.43410852713 | 44401.06194690266 | 59237.69130661113 | 70030.35517621145 | 42008.56503357374 | 24758.80733944954 | 51916.35011441647 | 39102.39575971731 | 36456.72843905915 | 47205.02719665271 | 35588.05991440799 | 49835.13708178439 | 28331.23546511628 | 42449.69262295082 | 36265.51235020787 | 29540.3804347826 | 45808.25670498084 | 40803.97873005943 | 52503.68620037808 | 35907.02708559047 | 44637.88313987802 | 37883.96873731222 | 33659.16981132075 | 35338.8319088319 | 43934.07103023187 | 47018.31894070236 | 42044.8274770497 | 53386.80340969632 | 40320.88050314465 | 44090.68903535051 | 40654.08844065167 | 36240.34175334324 | 37316.41192411924 | 19439.59578707657 | 24508.20633059789 | 28524.56014362657
 | 2016 | 54344.73226544623 | 45542.49254621348 | 49980.96551724138 | 41319.49790794979 | 54876.9375 | 51961.64739884393 | 54598.55670103092 | 105742.3709902371 | 49545.8567774936 | 57825.37263626251 | 64449.89983305509 | 65886.15843270869 | 40114.56624075319 | 62994.76635514019 | 52693.59216255442 | 68059.37791601865 | 48617.44186046511 | 48945.03027480205 | 45525.59864653825 | 24174.86233480176 | 34313.92688385973 | 56305.94495412843 | 42029.69107551487 | 42992.93639575972 | 39859.0253029223 | 43414.62970711297 | 68144.17617689015 | 48831.31040892193 | 69916.51162790698 | 38035.96311475409 | 44207.11420885302 | 38105.34280936454 | 44664.00383141762 | 44160.71629652799 | 40723.28922495274 | 47382.78006500542 | 46447.52705095417 | 44023.49167681689 | 56716.80834160874 | 52181.02801519468 | 50724.62577047255 | 46536.90270581462 | 50074.37480215258 | 72692.1843367075 | 52592.45283018867 | 48822.64429798282 | 52259.24489268167 | 56672.99157999009 | 55596.92140921408 | 73473.73754625676 | 68405.12700273545 | 64388.77318970676
 | 2017 | 41332.61327231121 | 36899.39177101968 | 16233.13409961686 | 40986.27615062761 | 31793.78125 | 38669.13294797688 | 41308.11855670103 | 10107.72663877266 | 60417.42966751917 | 41857.50834260289 | 37809.05676126878 | 48791.37137989779 | 60640.47747141896 | 54232.33644859813 | 55120.93613933236 | 37931.18195956454 | 48926.12403100775 | 46023.9077782953 | 34606.7100468506 | 45164.78248898678 | 63047.50808256653 | 58305.24770642201 | 45423.95881006865 | 57274.66784452296 | 63054.24625801852 | 48750.3430962343 | 35637.76390870185 | 40703.55250929367 | 41122.25290697675 | 58884.34426229508 | 58897.3734409391 | 71724.27675585283 | 48897.73946360153 | 54405.30497341257 | 46143.02457466919 | 56080.19284940412 | 48284.58980916782 | 57462.53958587089 | 48994.02184707051 | 51850.1400759734 | 44711.30319929557 | 45814.77835348302 | 47250.79772079772 | 13291.01225359616 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2015 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Sales (Y) | 43692.65446224256 | 56928.11568276685 | 73155.90038314176 | 57064.22594142259 | 52699.28125 | 48739.21965317919 | 43463.32474226804 | 23519.90237099024 | 29406.71355498721 | 39687.11902113459 | 37111.04340567612 | 24692.47018739353 | 38614.95628782784 | 22142.89719626168 | 31555.4716981132 | 33379.4401244168 | 41826.43410852713 | 44401.06194690266 | 59237.69130661113 | 70030.35517621145 | 42008.56503357374 | 24758.80733944954 | 51916.35011441647 | 39102.39575971731 | 36456.72843905915 | 47205.02719665271 | 35588.05991440799 | 49835.13708178439 | 28331.23546511628 | 42449.69262295082 | 36265.51235020787 | 29540.3804347826 | 45808.25670498084 | 40803.97873005943 | 52503.68620037808 | 35907.02708559047 | 44637.88313987802 | 37883.96873731222 | 33659.16981132075 | 35338.8319088319 | 43934.07103023187 | 47018.31894070236 | 42044.8274770497 | 53386.80340969632 | 40320.88050314465 | 44090.68903535051 | 40654.08844065167 | 36240.34175334324 | 37316.41192411924 | 19439.59578707657 | 24508.20633059789 | 28524.56014362657
 | sum x^2 | 1 | 4 | 9 | 16 | 25 | 36 | 49 | 64 | 81 | 100 | 121 | 144 | 169 | 196 | 225 | 256 | 289 | 324 | 361 | 400 | 441 | 484 | 529 | 576 | 625 | 676 | 729 | 784 | 841 | 900 | 961 | 1024 | 1089 | 1156 | 1225 | 1296 | 1369 | 1444 | 1521 | 1600 | 1681 | 1764 | 1849 | 1936 | 2025 | 2116 | 2209 | 2304 | 2401 | 2500 | 2601 | 2704
 | sum y^2 | 1909048053.956925 | 3240810355.190485 | 5351785760.868161 | 3256325882.293727 | 2777214244.266602 | 2375511532.400849 | 1889060597.651849 | 553185807.5409122 | 864754802.1050686 | 1575067416.197703 | 1377229542.657977 | 609718083.9553183 | 1491114849.110855 | 490307896.2442135 | 995747794.0904235 | 1114187023.019526 | 1749450590.234962 | 1971454302.012687 | 3509104071.337352 | 4904250646.106326 | 1764719536.179994 | 612998540.8719804 | 2695307409.202671 | 1528997354.149559 | 1329093048.479304 | 2228314592.636723 | 1266510008.471493 | 2483540887.960241 | 802658902.9798625 | 1801976403.783005 | 1315187386.02308 | 872634076.231687 | 2098396382.349422 | 1664964680.203142 | 2756637064.627771 | 1289314594.125327 | 1992540611.209407 | 1435195087.28965 | 1132939712.387326 | 1248833040.680676 | 1930202597.289459 | 2210722316.00961 | 1767767517.574873 | 2850150778.305563 | 1625773404.548871 | 1943988859.611978 | 1652754906.940328 | 1313362370.399113 | 1392514598.890548 | 377897884.3649251 | 600652177.5431585 | 813650531.3873693
 | sum x*y | 43692.65446224256 | 113856.2313655337 | 219467.7011494253 | 228256.9037656904 | 263496.40625 | 292435.3179190751 | 304243.2731958763 | 188159.2189679219 | 264660.4219948849 | 396871.1902113459 | 408221.4774624374 | 296309.6422487224 | 501994.4317417619 | 310000.5607476635 | 473332.0754716981 | 534071.0419906687 | 711049.3798449612 | 799219.1150442478 | 1125516.134825611 | 1400607.103524229 | 882179.8657050484 | 544693.7614678899 | 1194076.052631579 | 938457.4982332155 | 911418.2109764788 | 1227330.707112971 | 960877.6176890157 | 1395383.838289963 | 821605.828488372 | 1273490.778688525 | 1124230.882856444 | 945292.1739130433 | 1511672.471264368 | 1387335.276822021 | 1837629.017013233 | 1292652.975081257 | 1651601.676175487 | 1439590.812017864 | 1312707.622641509 | 1413553.276353276 | 1801296.912239507 | 1974769.395509499 | 1807927.581513137 | 2349019.350026638 | 1814439.622641509 | 2028171.695626123 | 1910742.156710628 | 1739536.404160475 | 1828504.184281843 | 971979.7893538285 | 1249918.522860493 | 1483277.127468582
2016 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104
 | Sales (Y) | 54344.73226544623 | 45542.49254621348 | 49980.96551724138 | 41319.49790794979 | 54876.9375 | 51961.64739884393 | 54598.55670103092 | 105742.3709902371 | 49545.8567774936 | 57825.37263626251 | 64449.89983305509 | 65886.15843270869 | 40114.56624075319 | 62994.76635514019 | 52693.59216255442 | 68059.37791601865 | 48617.44186046511 | 48945.03027480205 | 45525.59864653825 | 24174.86233480176 | 34313.92688385973 | 56305.94495412843 | 42029.69107551487 | 42992.93639575972 | 39859.0253029223 | 43414.62970711297 | 68144.17617689015 | 48831.31040892193 | 69916.51162790698 | 38035.96311475409 | 44207.11420885302 | 38105.34280936454 | 44664.00383141762 | 44160.71629652799 | 40723.28922495274 | 47382.78006500542 | 46447.52705095417 | 44023.49167681689 | 56716.80834160874 | 52181.02801519468 | 50724.62577047255 | 46536.90270581462 | 50074.37480215258 | 72692.1843367075 | 52592.45283018867 | 48822.64429798282 | 52259.24489268167 | 56672.99157999009 | 55596.92140921408 | 73473.73754625676 | 68405.12700273545 | 64388.77318970676
 | sum x^2 | 2809 | 2916 | 3025 | 3136 | 3249 | 3364 | 3481 | 3600 | 3721 | 3844 | 3969 | 4096 | 4225 | 4356 | 4489 | 4624 | 4761 | 4900 | 5041 | 5184 | 5329 | 5476 | 5625 | 5776 | 5929 | 6084 | 6241 | 6400 | 6561 | 6724 | 6889 | 7056 | 7225 | 7396 | 7569 | 7744 | 7921 | 8100 | 8281 | 8464 | 8649 | 8836 | 9025 | 9216 | 9409 | 9604 | 9801 | 10000 | 10201 | 10404 | 10609 | 10816
 | sum y^2 | 2953349925.003032 | 2074118627.32191 | 2498096914.035672 | 1707300907.365067 | 3011478269.378906 | 2700012800.401784 | 2981002393.835689 | 11181449022.63693 | 2454791923.815909 | 3343773720.522617 | 4153789588.490834 | 4340985873.01999 | 1609178424.683775 | 3968340588.138702 | 2776614654.993617 | 4632078922.315448 | 2363655653.055705 | 2395615988.601289 | 2072580132.125685 | 584423968.9066167 | 1177445578.190872 | 3170359437.177341 | 1766494931.903214 | 1848392579.929841 | 1588741898.099 | 1884830072.605736 | 4643628746.827043 | 2384496876.252487 | 4888318598.215252 | 1446734490.066934 | 1954268946.674574 | 1452017150.61919 | 1994873238.252888 | 1950168863.822433 | 1658386285.299152 | 2245127846.688675 | 2157372769.149119 | 1938067819.418766 | 3216796348.458779 | 2722859684.722532 | 2572987659.554488 | 2165683313.450456 | 2507443011.826454 | 5284153663.641864 | 2765966094.695621 | 2383650596.247355 | 2731028676.753275 | 3211827974.625628 | 3091017670.182327 | 5398390109.01622 | 4679261400.260366 | 4145914112.8755
 | sum x*y | 2880270.81006865 | 2459294.597495528 | 2748953.103448276 | 2313891.882845188 | 3127985.4375 | 3013775.549132948 | 3221314.845360824 | 6344542.259414226 | 3022297.26342711 | 3585173.103448275 | 4060343.689482471 | 4216714.139693356 | 2607446.805648957 | 4157654.579439252 | 3530470.674891146 | 4628037.698289269 | 3354603.488372093 | 3426152.119236143 | 3232317.503904216 | 1740590.088105727 | 2504916.66252176 | 4166639.926605504 | 3152226.830663615 | 3267463.166077739 | 3069144.948325017 | 3386341.117154812 | 5383389.917974322 | 3906504.832713754 | 5663237.441860465 | 3118948.975409836 | 3669190.479334801 | 3200848.795986622 | 3796440.325670497 | 3797821.601501408 | 3542926.162570889 | 4169684.645720477 | 4133829.907534921 | 3962114.25091352 | 5161229.559086395 | 4800654.577397911 | 4717390.196653947 | 4374468.854346574 | 4757065.606204496 | 6978449.69632392 | 5101467.924528302 | 4784619.141202317 | 5173665.244375485 | 5667299.157999009 | 5615289.062330622 | 7494321.22971819 | 7045728.081281751 | 6696432.411729502
2017 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156
 | Sales (Y) | 41332.61327231121 | 36899.39177101968 | 16233.13409961686 | 40986.27615062761 | 31793.78125 | 38669.13294797688 | 41308.11855670103 | 10107.72663877266 | 60417.42966751917 | 41857.50834260289 | 37809.05676126878 | 48791.37137989779 | 60640.47747141896 | 54232.33644859813 | 55120.93613933236 | 37931.18195956454 | 48926.12403100775 | 46023.9077782953 | 34606.7100468506 | 45164.78248898678 | 63047.50808256653 | 58305.24770642201 | 45423.95881006865 | 57274.66784452296 | 63054.24625801852 | 48750.3430962343 | 35637.76390870185 | 40703.55250929367 | 41122.25290697675 | 58884.34426229508 | 58897.3734409391 | 71724.27675585283 | 48897.73946360153 | 54405.30497341257 | 46143.02457466919 | 56080.19284940412 | 48284.58980916782 | 57462.53958587089 | 48994.02184707051 | 51850.1400759734 | 44711.30319929557 | 45814.77835348302 | 47250.79772079772 | 13291.01225359616 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x^2 | 11025 | 11236 | 11449 | 11664 | 11881 | 12100 | 12321 | 12544 | 12769 | 12996 | 13225 | 13456 | 13689 | 13924 | 14161 | 14400 | 14641 | 14884 | 15129 | 15376 | 15625 | 15876 | 16129 | 16384 | 16641 | 16900 | 17161 | 17424 | 17689 | 17956 | 18225 | 18496 | 18769 | 19044 | 19321 | 19600 | 19881 | 20164 | 20449 | 20736 | 21025 | 21316 | 21609 | 21904 | 22201 | 22500 | 22801 | 23104 | 23409 | 23716 | 24025 | 24336
 | sum y^2 | 1708384919.918437 | 1361565113.071195 | 263514642.6961436 | 1679874832.695506 | 1010844526.172852 | 1495301842.948311 | 1706360658.694468 | 102166137.8041545 | 3650265807.629626 | 1752051004.65107 | 1429524773.176845 | 2380597921.131109 | 3677267507.96167 | 2941146316.673945 | 3038317600.876357 | 1438774564.849595 | 2393765612.697554 | 2118200087.18503 | 1197624380.26679 | 2039857577.277487 | 3974988275.421292 | 3399501910.10723 | 2063336033.978813 | 3280387576.700433 | 3975837971.166843 | 2376595952.00056 | 1270050216.412372 | 1656779186.876827 | 1691039684.145358 | 3467365999.200483 | 3468900598.241439 | 5144371876.15017 | 2390988924.650255 | 2959937209.25003 | 2129178716.898525 | 3144988030.026357 | 2331401613.039593 | 3301943455.657779 | 2400414176.751222 | 2688437025.898063 | 1999100633.779338 | 2098993915.578776 | 2232637885.251743 | 176651006.7252434 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 4339924.393592677 | 3911335.527728086 | 1736945.348659004 | 4426517.824267782 | 3465522.15625 | 4253604.624277457 | 4585201.159793814 | 1132065.383542538 | 6827169.552429667 | 4771755.951056729 | 4348041.527545909 | 5659799.080068144 | 7094935.864156018 | 6399415.70093458 | 6559391.400580551 | 4551741.835147745 | 5920061.007751938 | 5614916.748952026 | 4256625.335762624 | 5600433.02863436 | 7880938.510320816 | 7346461.211009174 | 5768842.768878718 | 7331157.484098939 | 8133997.76728439 | 6337544.60251046 | 4668547.072039943 | 5372868.931226765 | 5469259.636627908 | 7890502.13114754 | 7951145.414526779 | 9754501.638795985 | 6698990.30651341 | 7507932.086330934 | 6413880.415879017 | 7851226.998916577 | 6808127.163092663 | 8159680.621193666 | 7006145.124131083 | 7466420.17094017 | 6483138.963897857 | 6688957.63960852 | 6945867.264957265 | 1967069.813532232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 6875586.666666666 |  | 650.7076694631671 | -24840.44212680179
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 344644104960.3895
 | sum x*y | 527191010.9275124
2018 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208
 | Sales (Y) | 77320.66197891545 | 77971.36964837862 | 78622.07731784179 | 79272.78498730494 | 79923.49265676811 | 80574.20032623128 | 81224.90799569445 | 81875.61566515762 | 82526.32333462079 | 83177.03100408395 | 83827.73867354712 | 84478.44634301029 | 85129.15401247346 | 85779.86168193661 | 86430.56935139978 | 87081.27702086295 | 87731.98469032612 | 88382.69235978929 | 89033.40002925246 | 89684.10769871563 | 90334.8153681788 | 90985.52303764196 | 91636.23070710512 | 92286.93837656829 | 92937.64604603146 | 93588.35371549462 | 94239.0613849578 | 94889.76905442096 | 95540.47672388413 | 96191.1843933473 | 96841.89206281047 | 97492.59973227362 | 98143.30740173679 | 98794.01507119996 | 99444.72274066313 | 100095.4304101263 | 100746.1380795895 | 101396.8457490526 | 102047.5534185158 | 102698.261087979 | 103348.9687574421 | 103999.6764269053 | 104650.3840963685 | 105301.0917658316 | 105951.7994352948 | 106602.507104758 | 107253.2147742211 | 107903.9224436843 | 108554.6301131475 | 109205.3377826106 | 109856.0454520738 | 110506.753121537
 | Seasonal Indices | 0.003919423118318146 | 0.003008179665638229 | 0.002340891153045849 | 0.003001004520341537 | 0.002296046494941523 | 0.002482600272655521 | 0.002783956375116596 | 0.005144579177728349 | 0.005610963622013346 | 0.00645045562172634 | 0.008595824065437326 | 0.00842362057831671 | 0.01066944105618139 | 0.008445146014206787 | 0.009887350218841932 | 0.01384085527731937 | 0.01295831240582622 | 0.01540503695199828 | 0.02756690822989166 | 0.02606012771758628 | 0.02885125923799957 | 0.04301499605367009 | 0.04389753892516324 | 0.04061132237927818 | 0.04026691540503696 | 0.03429719451818899 | 0.04023821482385018 | 0.03088182535696348 | 0.03455549974886991 | 0.03851617995264404 | 0.02933916911817465 | 0.03432589509937577 | 0.02621798091411351 | 0.02293893951352515 | 0.02656956303365143 | 0.03311329554423477 | 0.03647126354308675 | 0.03534476573150606 | 0.03612685656884552 | 0.03022171198966779 | 0.02444572002583053 | 0.02492645476070891 | 0.02266628399225084 | 0.01346774772189137 | 0.016542297481524 | 0.01796297625026907 | 0.01387314343115448 | 0.01448661835402167 | 0.01323814307239722 | 0.01260314271363995 | 0.009180598407117744 | 0.005994833895386382
 | Forecast Sales | 303.0523900838241 | 234.5518886782144 | 184.0457252274226 | 237.8979860869649 | 183.5080551780569 | 200.0335316989024 | 226.1266004328726 | 421.2155875146589 | 463.0521980890684 | 536.5297472387995 | 720.5684934412676 | 711.6143790392056 | 908.280490898673 | 724.4234569824165 | 854.5693087911955 | 1205.279352609921 | 1136.858465600409 | 1361.53864171965 | 2454.375568001636 | 2337.179300866293 | 2606.273176404154 | 3913.741914405278 | 4022.605004420386 | 3747.894605807394 | 3742.312331278816 | 3209.817972017395 | 3792.011596805936 | 2930.369276101226 | 3301.44891943909 | 3704.91696795213 | 2841.260648954811 | 3346.520751375454 | 2573.11936030671 | 2266.229936016548 | 2642.202829222039 | 3314.489569797896 | 3674.338952848915 | 3583.847758913922 | 3686.657325552322 | 3103.717268440608 | 2526.439955202736 | 2592.343229583619 | 2372.035325826419 | 1418.168538741953 | 1752.686184961413 | 1914.898303341907 | 1487.939232015186 | 1563.162943343608 | 1437.061724609006 | 1376.330457165499 | 1008.544235889563 | 662.4696292820847