Find the value of alpha,beta,gamma use in the excel. Multiplicative Holt Winter method Growth Seasonal Last Forecast

Find the value of alpha,beta,gamma use in the excel. Multiplicative Holt Winter method

Transcribed Image Text:

Growth Seasonal Last Forecast Time y Level Rate Factor Forecast Error Forecast Error Sq Relative Error Sq -1 321 -3 0.7062 -2 1.1114 1.2937 0 95.2500 2.4706 0.8886 1 72 98.5673 2.5553 0.7086 69.0103 2.9897 8.938380 0.001877 234 2 116 101.7726 2.6203 1.1142 112.3876 3.6124 13.049222 0.001033 3 136 104.5393 2.6349 1.2944 135.0531 0.9469 0.896609 0.000049 96 107.3464 2.6521 0.8892 95.2350 0.7650 0.585222 0.000065 567 5 77 109.731 2.6254 0.7079 77.9479 -0.9479 0.898460 0.000148 123 111.9629 2.5860 1.1127 125.1919 -2.1919 4.804523 0.000307 7 146 114.1975 2.5509 1.2928 148.2750 -2.2750 5.175701 0.000235 8 101 116.1165 2.4877 0.8872 103.8091 -2.8091 7.891303 0.000732 9 81 117.7668 2.4040 0.7059 83.9641 -2.9641 8.785994 0.001246 10 131 119.6835 2.3552 1.1109 133.7108 -2.7108 7.348451 0.000411 11 158 122.0735 2.3587 1.2930 157.7754 0.2246 0.050427 0.000002 12 109 124.1165 2.3271 0.8863 110.4005 -1.4005 1.961537 0.000161 13 87 125.8035 2.2631 0.7045 89.2593 -2.2593 5.104499 0.000641 14 140 127.659 2.2224 1.1094 142.2643 -2.2643 5.126938 0.000253 15 167 129.7369 2.2079 1.2924 167.9337 -0.9337 0.871805 0.000031 16 120 132.6337 2.2768 0.8882 116.9469 3.0531 9.321341 0.000682 17 94 134.6146 2.2472 0.7039 95.0425 -1.0425 1.086786 0.000120 18 147 135.9892 2.1600 1.1066 151.8403 -4.8403 23.428542 0.001016 19 177 137.9102 2.1361 1.2915 178.5443 -1.5443 2.385013 0.000075 21 2222 20 128 140.8602 2.2175 0.8902 124.3854 3.6146 13.065404 0.000844 102 143.4449 2.2542 0.7046 100.7075 1.2925 1.670659 0.000165 162 145.8383 2.2681 1.1070 161.2299 0.7701 0.593029 0.000023 23 191 148.063 2.2638 1.2914 191.2804 -0.2804 0.078606 0.000002 24 134 150.3661 2.2677 0.8903 133.8248 0.1752 0.030685 0.000002 25 106 152.1956 2.2239 0.7038 107.5437 -1.5437 2.383035 0.000206 26 170 154.2487 2.2068 1.1065 170.9450 -0.9450 0.893108 0.000031 27 200 156.1396 2.1752 1.2903 202.0396 -2.0396 4.160077 0.000102 29 30 31 32 22332 28 142 158.5505 2.1988 0.8908 140.9508 1.0492 1.100792 0.000055 115 161.2804 2.2519 177 162.8178 0.7047 113.1314 1.8686 3.491786 0.000273 2.1804 1.1046 180.9529 -3.9529 15.625253 0.000477 218 165.7889 2.2595 1.2928 212.8988 5.1012 26.022027 0.000574 149 167.89 2.2437 0.8905 149.7057 -0.7057 0.498074 0.000022 Growth Seasonal Last Forecast Time y Level Rate Factor Forecast Error Forecast Error Sq Relative Error Sq -1 321 -3 0.7062 -2 1.1114 1.2937 0 95.2500 2.4706 0.8886 1 72 98.5673 2.5553 0.7086 69.0103 2.9897 8.938380 0.001877 234 2 116 101.7726 2.6203 1.1142 112.3876 3.6124 13.049222 0.001033 3 136 104.5393 2.6349 1.2944 135.0531 0.9469 0.896609 0.000049 96 107.3464 2.6521 0.8892 95.2350 0.7650 0.585222 0.000065 567 5 77 109.731 2.6254 0.7079 77.9479 -0.9479 0.898460 0.000148 123 111.9629 2.5860 1.1127 125.1919 -2.1919 4.804523 0.000307 7 146 114.1975 2.5509 1.2928 148.2750 -2.2750 5.175701 0.000235 8 101 116.1165 2.4877 0.8872 103.8091 -2.8091 7.891303 0.000732 9 81 117.7668 2.4040 0.7059 83.9641 -2.9641 8.785994 0.001246 10 131 119.6835 2.3552 1.1109 133.7108 -2.7108 7.348451 0.000411 11 158 122.0735 2.3587 1.2930 157.7754 0.2246 0.050427 0.000002 12 109 124.1165 2.3271 0.8863 110.4005 -1.4005 1.961537 0.000161 13 87 125.8035 2.2631 0.7045 89.2593 -2.2593 5.104499 0.000641 14 140 127.659 2.2224 1.1094 142.2643 -2.2643 5.126938 0.000253 15 167 129.7369 2.2079 1.2924 167.9337 -0.9337 0.871805 0.000031 16 120 132.6337 2.2768 0.8882 116.9469 3.0531 9.321341 0.000682 17 94 134.6146 2.2472 0.7039 95.0425 -1.0425 1.086786 0.000120 18 147 135.9892 2.1600 1.1066 151.8403 -4.8403 23.428542 0.001016 19 177 137.9102 2.1361 1.2915 178.5443 -1.5443 2.385013 0.000075 21 2222 20 128 140.8602 2.2175 0.8902 124.3854 3.6146 13.065404 0.000844 102 143.4449 2.2542 0.7046 100.7075 1.2925 1.670659 0.000165 162 145.8383 2.2681 1.1070 161.2299 0.7701 0.593029 0.000023 23 191 148.063 2.2638 1.2914 191.2804 -0.2804 0.078606 0.000002 24 134 150.3661 2.2677 0.8903 133.8248 0.1752 0.030685 0.000002 25 106 152.1956 2.2239 0.7038 107.5437 -1.5437 2.383035 0.000206 26 170 154.2487 2.2068 1.1065 170.9450 -0.9450 0.893108 0.000031 27 200 156.1396 2.1752 1.2903 202.0396 -2.0396 4.160077 0.000102 29 30 31 32 22332 28 142 158.5505 2.1988 0.8908 140.9508 1.0492 1.100792 0.000055 115 161.2804 2.2519 177 162.8178 0.7047 113.1314 1.8686 3.491786 0.000273 2.1804 1.1046 180.9529 -3.9529 15.625253 0.000477 218 165.7889 2.2595 1.2928 212.8988 5.1012 26.022027 0.000574 149 167.89 2.2437 0.8905 149.7057 -0.7057 0.498074 0.000022