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

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 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 0 | 1 | 8 | 1 | 7 | 1 | 2 | 9 | 11 | 27 | 35 | 22 | 23 | 1 | 52 | 34 | 27 | 49 | 36 | 44 | 27 | 52 | 33 | 13 | 25 | 17 | 28 | 14 | 35 | 24 | 15 | 18 | 28 | 36 | 35 | 15 | 23 | 28 | 18 | 7 | 4 | 3 | 1 | 1 |  | 890
 | 2016 | 2 | 0 | 0 | 1 | 2 | 2 | 2 | 10 | 2 | 8 | 14 | 16 | 10 | 19 | 30 | 22 | 12 | 27 | 38 | 12 | 36 | 68 | 76 | 57 | 52 | 55 | 78 | 47 | 63 | 28 | 40 | 39 | 35 | 21 | 25 | 20 | 26 | 34 | 59 | 35 | 16 | 29 | 34 | 25 | 18 | 16 | 14 | 17 | 19 | 30 | 17 | 10 |  | 1349
 | 2017 | 6 | 0 | 1 | 0 | 0 | 7 | 3 | 0 | 11 | 6 | 3 | 4 | 12 | 18 | 29 | 8 | 20 | 16 | 12 | 22 | 27 | 56 | 36 | 44 | 40 | 39 | 33 | 22 | 29 | 57 | 22 | 57 | 33 | 34 | 24 | 30 | 28 | 43 | 48 | 32 | 21 | 22 | 24 | 7 |  |  |  |  |  |  |  |  |  | 986
 | 2018 | 7.165334303240157 | 2.779391095389135 | 3.363461258207698 | 3.391653201948433 | 3.419845145689168 | 7.470747027098125 | 5.214343549755958 | 8.176982279459876 | 7.653994661412906 | 8.902012160982114 | 14.95415336722326 | 12.66016063156011 | 17.61934002880608 | 23.26596004925332 | 37.63460659481464 | 24.24471742444218 | 26.93339737247562 | 44.17397150038517 | 54.03920840584242 | 35.86542681680187 | 55.48313285275341 | 81.23142061003482 | 107.3462036359458 | 88.99857172717068 | 79.00973307332691 | 95.61637714782992 | 98.98166374564101 | 76.61889387417457 | 81.24629394342524 | 94.1793653785725 | 65.75323164668126 | 75.95533521818396 | 65.2429033416613 | 50.84893817004596 | 54.74191104319414 | 45.80048428428765 | 64.10947895665842 | 73.2280180337462 | 89.02688173510819 | 62.42631166871121 | 48.04318047051949 | 64.71273242939752 | 69.61265462147529 | 35.40142578735983 | 46.61210967701551 | 50.33286322965253 | 36.83125426240046 | 27.79259235924476 | 26.79667135411879 | 38.67998156568368 | 21.2250355099335 | 13.04838287913527 |  | 2333.862741107878
 | Total | 13 | 5 | 6 | 6 | 6 | 13 | 9 | 14 | 13 | 15 | 25 | 21 | 29 | 38 | 61 | 39 | 43 | 70 | 85 | 56 | 86 | 125 | 164 | 135 | 119 | 143 | 147 | 113 | 119 | 137 | 95 | 109 | 93 | 72 | 77 | 64 | 89 | 101 | 122 | 85 | 65 | 87 | 93 | 47 | 41 | 44 | 32 | 24 | 23 | 33 | 18 | 11 |  | 3225
 | Weekly Average | 4.333333333333333 | 1.666666666666667 | 2 | 2 | 2 | 4.333333333333333 | 3 | 4.666666666666667 | 4.333333333333333 | 5 | 8.333333333333334 | 7 | 9.666666666666666 | 12.66666666666667 | 20.33333333333333 | 13 | 14.33333333333333 | 23.33333333333333 | 28.33333333333333 | 18.66666666666667 | 28.66666666666667 | 41.66666666666666 | 54.66666666666666 | 45 | 39.66666666666666 | 47.66666666666666 | 49 | 37.66666666666666 | 39.66666666666666 | 45.66666666666666 | 31.66666666666667 | 36.33333333333334 | 31 | 24 | 25.66666666666667 | 21.33333333333333 | 29.66666666666667 | 33.66666666666666 | 40.66666666666666 | 28.33333333333333 | 21.66666666666667 | 29 | 31 | 15.66666666666667 | 20.5 | 22 | 16 | 12 | 11.5 | 16.5 | 9 | 5.5 |  | 1075
 | Seasonal Indices | 0.004031007751937985 | 0.001550387596899225 | 0.00186046511627907 | 0.00186046511627907 | 0.00186046511627907 | 0.004031007751937985 | 0.002790697674418605 | 0.00434108527131783 | 0.004031007751937985 | 0.004651162790697674 | 0.007751937984496125 | 0.006511627906976744 | 0.008992248062015503 | 0.01178294573643411 | 0.01891472868217054 | 0.01209302325581395 | 0.01333333333333333 | 0.02170542635658915 | 0.02635658914728682 | 0.01736434108527132 | 0.02666666666666667 | 0.03875968992248062 | 0.05085271317829457 | 0.04186046511627907 | 0.03689922480620155 | 0.04434108527131782 | 0.04558139534883721 | 0.03503875968992248 | 0.03689922480620155 | 0.04248062015503876 | 0.02945736434108527 | 0.0337984496124031 | 0.02883720930232558 | 0.02232558139534884 | 0.02387596899224806 | 0.01984496124031008 | 0.0275968992248062 | 0.03131782945736434 | 0.03782945736434108 | 0.02635658914728682 | 0.02015503875968992 | 0.02697674418604651 | 0.02883720930232558 | 0.01457364341085271 | 0.01906976744186047 | 0.02046511627906977 | 0.01488372093023256 | 0.01116279069767442 | 0.01069767441860465 | 0.01534883720930233 | 0.008372093023255815 | 0.005116279069767441
 | 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 | 1240.384615384615 | 3225 | 2687.5 | 2687.5 | 2150 | 992.3076923076923 | 1433.333333333333 | 921.4285714285713 | 0 | 215 | 1032 | 153.5714285714286 | 778.448275862069 | 84.86842105263159 | 105.7377049180328 | 744.2307692307693 | 825 | 1243.928571428572 | 1327.941176470588 | 1266.964285714286 | 862.5 | 25.8 | 1022.560975609756 | 812.2222222222223 | 731.7226890756302 | 1105.06993006993 | 789.795918367347 | 1255.752212389381 | 731.7226890756302 | 1224.087591240876 | 1120.263157894737 | 384.6330275229358 | 866.9354838709678 | 761.4583333333334 | 1172.727272727273 | 705.4687500000001 | 1268.258426966292 | 766.3366336633663 | 396.516393442623 | 682.9411764705883 | 1389.230769230769 | 1334.48275862069 | 1213.709677419355 | 1029.255319148936 | 1206.09756097561 | 1368.181818181818 | 1209.375 | 627.0833333333334 | 373.9130434782609 | 195.4545454545454 | 119.4444444444444 | 195.4545454545455
 | 2016 | 496.1538461538461 | 0 | 0 | 537.5 | 1075 | 496.1538461538461 | 716.6666666666666 | 2303.571428571428 | 496.1538461538461 | 1720 | 1806 | 2457.142857142857 | 1112.068965517241 | 1612.5 | 1586.065573770492 | 1819.230769230769 | 899.9999999999999 | 1243.928571428572 | 1441.764705882353 | 691.0714285714284 | 1350 | 1754.4 | 1494.512195121951 | 1361.666666666667 | 1409.243697478992 | 1240.384615384615 | 1711.224489795919 | 1341.371681415929 | 1707.35294117647 | 659.1240875912409 | 1357.894736842105 | 1153.899082568807 | 1213.709677419355 | 940.625 | 1047.077922077922 | 1007.8125 | 942.1348314606741 | 1085.643564356436 | 1559.631147540984 | 1327.941176470588 | 793.8461538461538 | 1075 | 1179.032258064516 | 1715.425531914894 | 943.9024390243902 | 781.8181818181819 | 940.625 | 1522.916666666667 | 1776.086956521739 | 1954.545454545455 | 2030.555555555555 | 1954.545454545455
 | 2017 | 1488.461538461538 | 0 | 537.5 | 0 | 0 | 1736.538461538461 | 1075 | 0 | 2728.846153846154 | 1290 | 386.9999999999999 | 614.2857142857142 | 1334.48275862069 | 1527.631578947369 | 1533.196721311476 | 661.5384615384615 | 1500 | 737.1428571428571 | 455.2941176470588 | 1266.964285714286 | 1012.5 | 1444.8 | 707.9268292682926 | 1051.111111111111 | 1084.033613445378 | 879.5454545454546 | 723.9795918367347 | 627.8761061946904 | 785.9243697478992 | 1341.788321167883 | 746.8421052631579 | 1686.467889908257 | 1144.354838709678 | 1522.916666666667 | 1005.194805194805 | 1511.71875 | 1014.606741573034 | 1373.019801980198 | 1268.852459016394 | 1214.117647058824 | 1041.923076923077 | 815.5172413793103 | 832.258064516129 | 480.3191489361703 | 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) | 1240.384615384615 | 3225 | 2687.5 | 2687.5 | 2150 | 992.3076923076923 | 1433.333333333333 | 921.4285714285713 | 0 | 215 | 1032 | 153.5714285714286 | 778.448275862069 | 84.86842105263159 | 105.7377049180328 | 744.2307692307693 | 825 | 1243.928571428572 | 1327.941176470588 | 1266.964285714286 | 862.5 | 25.8 | 1022.560975609756 | 812.2222222222223 | 731.7226890756302 | 1105.06993006993 | 789.795918367347 | 1255.752212389381 | 731.7226890756302 | 1224.087591240876 | 1120.263157894737 | 384.6330275229358 | 866.9354838709678 | 761.4583333333334 | 1172.727272727273 | 705.4687500000001 | 1268.258426966292 | 766.3366336633663 | 396.516393442623 | 682.9411764705883 | 1389.230769230769 | 1334.48275862069 | 1213.709677419355 | 1029.255319148936 | 1206.09756097561 | 1368.181818181818 | 1209.375 | 627.0833333333334 | 373.9130434782609 | 195.4545454545454 | 119.4444444444444 | 195.4545454545455
 | 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 | 1538553.99408284 | 10400625 | 7222656.25 | 7222656.25 | 4622500 | 984674.5562130177 | 2054444.444444444 | 849030.6122448978 | 0 | 46225 | 1065024 | 23584.18367346938 | 605981.7181926278 | 7202.648891966761 | 11180.46224133298 | 553879.4378698226 | 680625 | 1547358.290816327 | 1763427.76816609 | 1605198.50127551 | 743906.25 | 665.64 | 1045630.948839976 | 659704.9382716051 | 535418.0937080714 | 1221179.550344761 | 623777.592669721 | 1576913.618920824 | 535418.0937080714 | 1498390.43102989 | 1254989.542936288 | 147942.5658614595 | 751577.133194589 | 579818.7934027779 | 1375289.256198347 | 497686.1572265627 | 1608479.437571014 | 587271.8360945005 | 157225.250268745 | 466408.6505190312 | 1929962.130177515 | 1780844.233055886 | 1473091.181061395 | 1059366.511996379 | 1454671.326591315 | 1871921.487603306 | 1462587.890625 | 393233.5069444445 | 139810.9640831758 | 38202.47933884297 | 14266.97530864198 | 38202.47933884298
 | sum x*y | 1240.384615384615 | 6450 | 8062.5 | 10750 | 10750 | 5953.846153846153 | 10033.33333333333 | 7371.428571428571 | 0 | 2150 | 11352 | 1842.857142857143 | 10119.8275862069 | 1188.157894736842 | 1586.065573770492 | 11907.69230769231 | 14025 | 22390.71428571429 | 25230.88235294118 | 25339.28571428571 | 18112.5 | 567.6 | 23518.90243902439 | 19493.33333333334 | 18293.06722689075 | 28731.81818181819 | 21324.48979591837 | 35161.06194690266 | 21219.95798319328 | 36722.62773722628 | 34728.15789473684 | 12308.25688073394 | 28608.87096774194 | 25889.58333333334 | 41045.45454545454 | 25396.875 | 46925.56179775281 | 29120.79207920792 | 15464.1393442623 | 27317.64705882353 | 56958.46153846154 | 56048.27586206896 | 52189.51612903226 | 45287.23404255319 | 54274.39024390244 | 62936.36363636364 | 56840.625 | 30100 | 18321.73913043478 | 9772.727272727272 | 6091.666666666667 | 10163.63636363636
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) | 496.1538461538461 | 0 | 0 | 537.5 | 1075 | 496.1538461538461 | 716.6666666666666 | 2303.571428571428 | 496.1538461538461 | 1720 | 1806 | 2457.142857142857 | 1112.068965517241 | 1612.5 | 1586.065573770492 | 1819.230769230769 | 899.9999999999999 | 1243.928571428572 | 1441.764705882353 | 691.0714285714284 | 1350 | 1754.4 | 1494.512195121951 | 1361.666666666667 | 1409.243697478992 | 1240.384615384615 | 1711.224489795919 | 1341.371681415929 | 1707.35294117647 | 659.1240875912409 | 1357.894736842105 | 1153.899082568807 | 1213.709677419355 | 940.625 | 1047.077922077922 | 1007.8125 | 942.1348314606741 | 1085.643564356436 | 1559.631147540984 | 1327.941176470588 | 793.8461538461538 | 1075 | 1179.032258064516 | 1715.425531914894 | 943.9024390243902 | 781.8181818181819 | 940.625 | 1522.916666666667 | 1776.086956521739 | 1954.545454545455 | 2030.555555555555 | 1954.545454545455
 | 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 | 246168.6390532544 | 0 | 0 | 288906.25 | 1155625 | 246168.6390532544 | 513611.1111111111 | 5306441.326530612 | 246168.6390532544 | 2958400 | 3261635.999999999 | 6037551.020408162 | 1236697.384066588 | 2600156.250000001 | 2515604.00429992 | 3309600.591715977 | 809999.9999999998 | 1547358.290816327 | 2078685.467128028 | 477579.7193877549 | 1822500 | 3077919.36 | 2233566.701368233 | 1854136.111111111 | 1985967.79888426 | 1538553.99408284 | 2928289.254477302 | 1799277.987704597 | 2915054.065743944 | 434444.5628429858 | 1843878.11634349 | 1331483.092753135 | 1473091.181061395 | 884775.390625 | 1096372.174903019 | 1015686.03515625 | 887618.0406514329 | 1178621.948828546 | 2432449.316380005 | 1763427.76816609 | 630191.7159763313 | 1155625 | 1390117.065556712 | 2942684.755545496 | 890951.8143961927 | 611239.6694214877 | 884775.390625 | 2319275.173611111 | 3154484.877126654 | 3820247.933884297 | 4123155.86419753 | 3820247.933884298
 | sum x*y | 26296.15384615384 | 0 | 0 | 30100 | 61275 | 28776.92307692307 | 42283.33333333333 | 138214.2857142857 | 30265.38461538461 | 106640 | 113778 | 157257.1428571428 | 72284.4827586207 | 106425 | 106266.393442623 | 123707.6923076923 | 62099.99999999999 | 87075.00000000001 | 102365.2941176471 | 49757.14285714285 | 98550 | 129825.6 | 112088.4146341463 | 103486.6666666667 | 108511.7647058823 | 96750 | 135186.7346938776 | 107309.7345132743 | 138295.5882352941 | 54048.17518248175 | 112705.2631578947 | 96927.52293577981 | 103165.3225806452 | 80893.75 | 91095.77922077922 | 88687.50000000001 | 83850 | 97707.92079207921 | 141926.4344262295 | 122170.5882352941 | 73827.6923076923 | 101050 | 112008.064516129 | 164680.8510638298 | 91558.53658536584 | 76618.18181818182 | 93121.875 | 152291.6666666667 | 179384.7826086956 | 199363.6363636364 | 209147.2222222222 | 203272.7272727273
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) | 1488.461538461538 | 0 | 537.5 | 0 | 0 | 1736.538461538461 | 1075 | 0 | 2728.846153846154 | 1290 | 386.9999999999999 | 614.2857142857142 | 1334.48275862069 | 1527.631578947369 | 1533.196721311476 | 661.5384615384615 | 1500 | 737.1428571428571 | 455.2941176470588 | 1266.964285714286 | 1012.5 | 1444.8 | 707.9268292682926 | 1051.111111111111 | 1084.033613445378 | 879.5454545454546 | 723.9795918367347 | 627.8761061946904 | 785.9243697478992 | 1341.788321167883 | 746.8421052631579 | 1686.467889908257 | 1144.354838709678 | 1522.916666666667 | 1005.194805194805 | 1511.71875 | 1014.606741573034 | 1373.019801980198 | 1268.852459016394 | 1214.117647058824 | 1041.923076923077 | 815.5172413793103 | 832.258064516129 | 480.3191489361703 | 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 | 2215517.751479289 | 0 | 288906.25 | 0 | 0 | 3015565.828402366 | 1155625 | 0 | 7446601.331360946 | 1664100 | 149768.9999999999 | 377346.9387755101 | 1780844.233055886 | 2333658.24099723 | 2350692.186240259 | 437633.1360946746 | 2250000 | 543379.5918367347 | 207292.7335640138 | 1605198.50127551 | 1025156.25 | 2087447.04 | 501160.3955978584 | 1104834.567901235 | 1175128.875079443 | 773600.2066115703 | 524146.449396085 | 394228.4047302061 | 617677.1149636325 | 1800395.898822527 | 557773.1301939059 | 2844173.943691608 | 1309547.996878252 | 2319275.173611111 | 1010416.596390622 | 2285293.579101563 | 1029426.840045449 | 1885183.376629742 | 1609986.562751949 | 1474081.660899654 | 1085603.698224852 | 665068.3709869203 | 692653.4859521332 | 230706.4848347669 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 156288.4615384615 | 0 | 57512.5 | 0 | 0 | 191019.2307692308 | 119325 | 0 | 308359.6153846154 | 147060 | 44504.99999999999 | 71257.14285714286 | 156134.4827586207 | 180260.5263157895 | 182450.4098360656 | 79384.61538461539 | 181500 | 89931.42857142857 | 56001.17647058824 | 157103.5714285714 | 126562.5 | 182044.8 | 89906.70731707316 | 134542.2222222222 | 139840.3361344538 | 114340.9090909091 | 94841.32653061225 | 82879.64601769912 | 104527.9411764706 | 179799.6350364964 | 100823.6842105263 | 229359.6330275229 | 156776.6129032258 | 210162.5 | 139722.0779220779 | 211640.625 | 143059.5505617977 | 194968.8118811881 | 181445.9016393443 | 174832.9411764706 | 151078.8461538462 | 119065.5172413793 | 122341.935483871 | 71087.2340425532 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 159099.9999999999 |  | 15.15316976064531 | -601.4935656559663
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 222230248.3193137
 | sum x*y | 11994799.59038169
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) | 1777.554086765347 | 1792.707256525992 | 1807.860426286637 | 1823.013596047283 | 1838.166765807928 | 1853.319935568573 | 1868.473105329218 | 1883.626275089864 | 1898.779444850509 | 1913.932614611154 | 1929.0857843718 | 1944.238954132445 | 1959.39212389309 | 1974.545293653736 | 1989.698463414381 | 2004.851633175026 | 2020.004802935672 | 2035.157972696317 | 2050.311142456962 | 2065.464312217608 | 2080.617481978253 | 2095.770651738898 | 2110.923821499543 | 2126.076991260189 | 2141.230161020834 | 2156.383330781479 | 2171.536500542124 | 2186.68967030277 | 2201.842840063415 | 2216.996009824061 | 2232.149179584706 | 2247.302349345351 | 2262.455519105997 | 2277.608688866642 | 2292.761858627287 | 2307.915028387933 | 2323.068198148578 | 2338.221367909223 | 2353.374537669868 | 2368.527707430514 | 2383.680877191159 | 2398.834046951804 | 2413.987216712449 | 2429.140386473095 | 2444.29355623374 | 2459.446725994385 | 2474.599895755031 | 2489.753065515676 | 2504.906235276321 | 2520.059405036967 | 2535.212574797612 | 2550.365744558258
 | Seasonal Indices | 0.004031007751937985 | 0.001550387596899225 | 0.00186046511627907 | 0.00186046511627907 | 0.00186046511627907 | 0.004031007751937985 | 0.002790697674418605 | 0.00434108527131783 | 0.004031007751937985 | 0.004651162790697674 | 0.007751937984496125 | 0.006511627906976744 | 0.008992248062015503 | 0.01178294573643411 | 0.01891472868217054 | 0.01209302325581395 | 0.01333333333333333 | 0.02170542635658915 | 0.02635658914728682 | 0.01736434108527132 | 0.02666666666666667 | 0.03875968992248062 | 0.05085271317829457 | 0.04186046511627907 | 0.03689922480620155 | 0.04434108527131782 | 0.04558139534883721 | 0.03503875968992248 | 0.03689922480620155 | 0.04248062015503876 | 0.02945736434108527 | 0.0337984496124031 | 0.02883720930232558 | 0.02232558139534884 | 0.02387596899224806 | 0.01984496124031008 | 0.0275968992248062 | 0.03131782945736434 | 0.03782945736434108 | 0.02635658914728682 | 0.02015503875968992 | 0.02697674418604651 | 0.02883720930232558 | 0.01457364341085271 | 0.01906976744186047 | 0.02046511627906977 | 0.01488372093023256 | 0.01116279069767442 | 0.01069767441860465 | 0.01534883720930233 | 0.008372093023255815 | 0.005116279069767441
 | Forecast Sales | 7.165334303240157 | 2.779391095389135 | 3.363461258207698 | 3.391653201948433 | 3.419845145689168 | 7.470747027098125 | 5.214343549755958 | 8.176982279459876 | 7.653994661412906 | 8.902012160982114 | 14.95415336722326 | 12.66016063156011 | 17.61934002880608 | 23.26596004925332 | 37.63460659481464 | 24.24471742444218 | 26.93339737247562 | 44.17397150038517 | 54.03920840584242 | 35.86542681680187 | 55.48313285275341 | 81.23142061003482 | 107.3462036359458 | 88.99857172717068 | 79.00973307332691 | 95.61637714782992 | 98.98166374564101 | 76.61889387417457 | 81.24629394342524 | 94.1793653785725 | 65.75323164668126 | 75.95533521818396 | 65.2429033416613 | 50.84893817004596 | 54.74191104319414 | 45.80048428428765 | 64.10947895665842 | 73.2280180337462 | 89.02688173510819 | 62.42631166871121 | 48.04318047051949 | 64.71273242939752 | 69.61265462147529 | 35.40142578735983 | 46.61210967701551 | 50.33286322965253 | 36.83125426240046 | 27.79259235924476 | 26.79667135411879 | 38.67998156568368 | 21.2250355099335 | 13.04838287913527