Question: Compute exponential smoothing forecasts with smoothing constant a=.7. Use Presidential 2020 Election Data and Homework data and templates.xlsx What is the forecast for Last Price

Compute exponential smoothing forecasts with smoothing constant a=.7. Use Presidential 2020 Election Data and Homework data and templates.xlsx
What is the forecast for Last Price on October 24?
What is MAE?
What is MSE?
What is MAPE?

Compute exponential smoothing forecasts with

ooo ! 1 Date Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths 2 2/17/20 18.43492 22.7564 26.48684 3 2/18/20 18.43492 22.2899 27.53751 4 2/19/20 18.43492 22.2899 27.53751 5 2/20/20 18.43492 22.2899 27.53751 6 2/21/20 18.43492 22.2899 27.53751 7 2/22/20 18.43492 22.2899 27.53751 8 2/23/20 18.43492 22.2899 27.53751 9 2/24/20 18.43492 22.2899 27.53751 10 2/25/20 17.55785 22.2899 28.33005 11 2/26/20 17.55785 25.62871 28.85493 12 2/27/20 17.55785 25.62871 28.85493 13 2/28/20 17.90033 25.62871 38.02801 14 2/29/20 17.90033 25.62871 38.02801 15 3/1/20 17.90033 28.73197 39.05365 16 3/2/20 17.90033 28.73197 39.05365 17 3/3/20 19.82386 32.43756 42.81175 18 3/4/20 19.82386 32.43756 42.81175 11 19 3/5/20 19.82386 33.17934 43.73902 12 20 3/6/20 19.82386 33.17934 43.73902 15 21 3/7/20 19.82386 33.17934 45.39878 19 22 3/8/20 20.62768 33.83747 47.1093 22 23 3/9/20 22.4908 33.85994 47.45365 26 24 3/10/20 22.10178 34.21951 47.46267 30 25 3/11/20 22.4244 34.21951 49.0095 38 26 3/12/20 22.32016 34.21951 48.739 41 27 3/13/20 22.14673 34.09245 49.09423 48 28 3/14/20 22.14673 34.88319 49.09134 58 29 3/15/20 23.27218 37.13918 48.80058 73 30 3/16/20 23.74623 42.46375 49.0646 95 31 3/17/20 23.46276 44.04733 48.95124 121 32 3/18/20 23.46276 45.38528 48.58893 33 3/19/20 24.29691 45.38528 46.88491 240 34 3/20/20 24.29691 47.62551 46.76443 311 35 3/21/20 24.29691 47.62551 46.76443 377 36 3/22/20 27.28671 52.73412 46.16106 513 37 3/23/20 27.9404 52.73412 46.01105 694 38 3/24/20 29.26733 54.05219 46.332 963 39 3/25/20 30.44253 54.05219 46.1678 1270 40 3/26/20 30.51298 55.76489 46.58516 1630 41 3/27/20 30.5966 55.76489 46.63401 2132 42 3/28/20 30.97512 55.76489 46.88109 2782 W 8GNEULO Dow Ind. Ave. (Daily Inde: "Y"lowa (Lastprice Republican 29398 0.415 29232.19 0.430 29348.03 0.425 29219.98 0.428 28992.41 0.450 28992.41 0.425 28992.41 0.490 27960.8 0.486 27081.36 0.438 26957.59 0.495 25766.64 0.480 25409.36 0.467 25409.36 0.445 25409.36 0.450 26703.32 0.452 25917.41 0.439 27090.86 0.429 26121.28 0.385 25864.78 0.420 25864.78 0.420 25864.78 0.410 23851.02 0.385 25018.16 0.353 23553.22 0.400 21200.62 0.405 23185.62 0.414 23185.62 0.379 23185.62 0.379 20188.52 0.393 21237.38 0.393 19898.92 0.375 20087.19 0.376 19173.98 0.392 19173.98 0.353 19173.98 0.353 18591.93 0.360 20704.91 0.365 21200.55 0.320 22552.17 0.340 21636.78 0.340 21636.78 0.340 171 43 44 45 46 47 48 49 50 51 52 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 3/29/20 3/30/20 3/31/20 4/1/20 4/2/20 4/3/20 4/4/20 4/5/20 4/6/20 4/7/20 4/8/20 4/9/20 4/10/20 4/11/20 4/12/20 4/13/20 4/14/20 4/15/20 4/16/20 4/17/20 4/18/20 4/19/20 4/20/20 4/21/20 4/22/20 4/23/20 4/24/20 4/25/20 4/26/20 4/27/20 4/28/20 4/29/20 4/30/20 5/1/20 5/2/20 5/3/20 5/4/20 5/5/20 5/6/20 5/7/20 5/8/20 5/9/20 5/10/20 32.5274 31.48081 31.53831 31.81763 31.81763 32.9665 32.982783 32.982783 32.982783 33.412965 36.96633 37.500457 37.999492 38.012555 37.150252 38.79787 38.344719 36.811698 33.736069 33.741089 33.706203 33.833518 34.073216 31.901182 32.202039 32.345584 32.596807 32.60568 32.60568 32.335759 30.781942 30.81259 31.081605 31.189971 31.279785 31.373302 31.375595 30.160456 30.660573 31.006627 31.995114 32.005781 32.816567 63.37077 55.14687 55.14687 54.5601 54.5601 54.462539 54.400371 54.400371 55.311979 54.897678 56.539081 57.075326 57.06725 56.843724 56.843724 57.154326 57.159566 56.992024 56.978714 56.952778 57.043192 57.043192 57.850277 56.888707 55.376078 55.19769 55.093169 54.695862 54.695862 55.613904 56.797742 56.954562 57.129176 57.021726 56.966255 56.966255 56.966255 56.459974 55.146994 55.209089 55.149742 55.067558 55.067558 47.35137 47.16372 47.0874 47.25014 47.25014 47.330635 47.336715 47.336715 46.728485 46.35629 47.833119 47.947816 48.129085 48.133345 48.133345 48.422567 48.557815 48.662873 48.857986 48.990832 48.825956 49.082732 49.114244 49.610024 50.131403 50.384815 50.126516 50.118182 50.066345 50.18898 50.773073 51.23337 49.838213 49.970502 49.963317 50.083323 50.108971 50.870262 50.894868 51.08373 51.162726 51.139951 51.139951 3284 4107 5207 6466 7676 8962 10539 11966 13491 15762 17973 20122 22404 24474 26234 27981 30612 33304 35557 38155 40079 41678 43663 46405 48823 51234 53228 55342 56517 57928 60467 62923 65201 67162 68891 70067 71409 73819 76399 78575 80302 81759 82986 22327.48 22327.48 21917.16 20943.51 21413.44 21052.53 21052.53 21052.53 22679.99 22653.86 23433.57 23719.37 23719.37 23719.37 23719.37 23390.77 23949.76 23504.35 23537.68 24242.49 24242.49 24242.49 23650.44 23018.88 23475.82 23515.26 23775.27 23775.27 23775.27 24133.78 24101.55 24633.86 24345.72 23723.69 23723.69 23723.69 23749.76 23883.09 23664.64 23875.89 24331.32 24331.32 24331.32 0.340 0.387 0.380 0.380 0.388 0.388 0.382 0.382 0.382 0.382 0.377 0.370 0.370 0.365 0.365 0.365 0.370 0.370 0.379 0.379 0.379 0.374 0.374 0.374 0.374 0.352 0.352 0.352 0.360 0.360 0.360 0.363 0.360 0.360 0.361 0.362 0.361 0.360 0.363 0.363 0.365 0.367 0.368 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 5/11/20 5/12/20 5/13/20 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/20 5/26/20 5/27/20 5/28/20 5/29/20 5/30/20 5/31/20 6/1/20 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 6/10/20 6/11/20 6/12/20 6/13/20 6/14/20 6/15/20 6/16/20 6/17/20 6/18/20 6/19/20 6/20/20 6/21/20 6/22/20 32.834497 32.708295 31.479767 31.731098 31.838945 31.921953 31.921953 30.653207 30.753734 33.110292 32.975016 33.09324 33.09324 33.09324 33.000465 32.902524 32.632395 32.532283 32.583202 32.583202 32.583202 32.12542 32.082644 31.582982 30.406441 30.406441 29.767526 29.767526 29.64931 29.027798 28.619629 28.574057 28.047086 28.501634 28.501634 28.450584 28.352136 28.089974 28.432202 28.517001 28.517001 28.517001 28.264291 55.067558 55.903754 55.64439 55.577297 55.573327 55.605722 55.605722 55.605722 58.12627 56.731735 56.731735 56.731735 56.731735 56.731735 56.731735 56.759255 56.568104 56.568104 56.568104 56.568104 56.568104 57.1027 55.833262 53.679146 53.679146 53.679146 53.679146 53.679146 53.280986 51.735238 51.735238 50.803102 50.803102 50.803102 50.803102 51.02643 51.200113 51.200113 51.200113 51.142559 51.142559 51.142559 51.142559 51.176962 52.14613 52.285751 52.460737 52.462197 52.476902 52.476902 52.405606 52.730664 52.89972 53.465635 53.658117 53.658117 53.658117 53.658117 53.781843 53.576387 53.60148 53.540151 53.540151 53.441998 53.477337 53.436884 53.36457 53.238346 53.323802 53.42655 53.42655 53.651902 53.647416 54.121064 54.187301 54.090098 54.090098 54.090098 54.119042 54.14946 54.229197 54.675136 54.734831 54.776417 54.776417 55.153723 84067 85981 87845 89645 91289 92535 93424 94446 96021 97460 98902 100222 101269 101898 102543 103313 104873 106103 107332 108362 109019 109717 110861 111969 113021 114006 114736 115127 115704 116807 117806 118719 119519 120238 120578 120997 121853 122675 123435 124167 124756 125031 125396 24221.99 23764.78 23247.97 23625.34 23685.42 23685.42 23685.42 24597.37 24206.86 24575.9 24474.12 24465.16 24465.16 24465.16 24465.16 24995.11 25548.27 25400.64 25383.11 25383.11 25383.11 25475.02 25742.65 26269.89 26281.82 27110.98 27110.98 27110.98 27572.44 27272.3 26989.99 25128.17 25605.54 25605.54 25605.54 25763.16 26289.98 26119.61 26080.1 25871.46 25871.46 25871.46 26024.96 0.368 0.367 0.367 0.350 0.350 0.350 0.350 0.350 0.359 0.359 0.359 0.360 0.359 0.359 0.358 0.358 0.370 0.370 0.370 0.370 0.370 0.370 0.330 0.330 0.330 0.330 0.330 0.330 0.330 0.344 0.291 0.320 0.320 0.320 0.320 0.291 0.291 0.253 0.313 0.260 0.250 0.309 0.250 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 157 158 159 160 161 6/23/20 6/24/20 6/25/20 6/26/20 6/27/20 6/28/20 6/29/20 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 77/20 7/8/20 7/9/20 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/20 7/17/20 7/18/20 7/19/20 7/20/20 7/21/20 7/22/20 7/23/20 7/24/20 7/25/20 7/26/20 7/27/20 7/28/20 7/29/20 7/30/20 7/31/20 8/1/20 8/2/20 8/3/20 8/4/20 8/5/20 28.114699 27.893275 27.925207 28.189215 28.957378 28.957378 28.769671 29.111353 30.795733 30.795733 30.795733 30.795733 30.795733 30.795733 31.064142 30.777769 30.777769 31.128285 31.128285 31.128285 31.631132 31.591565 33.916076 34.565088 35.639723 35.639723 35.639723 36.09616 35.935889 35.968375 37.389104 36.886125 37.117728 37.117728 37.117728 37.016225 35.864029 35.864029 35.729273 35.729273 35.729273 35.729273 36.019952 35.513543 51.262542 51.262542 51.010911 51.010911 51.010911 51.010911 51.010911 53.550118 53.548657 53.548657 53.548657 53.548657 55.418561 55.418561 55.379466 55.379466 55.379466 55.379466 55.379466 55.379466 55.379466 54.499124 54.499124 54.333817 54.333817 54.333817 54.333817 54.333817 54.83324 54.813215 55.690561 56.009345 56.009345 56.009345 56.20501 57.196281 56.898031 56.326407 56.326407 56.326407 56.326407 56.326407 57.843765 57.432268 55.180261 55.496648 55.496648 55.568218 55.761541 55.761541 55.868535 55.84097 56.287416 56.287416 56.287416 56.287416 56.300803 56.300803 56.281607 56.348829 56.348829 56.665657 56.665657 56.665657 56.659761 56.736723 57.662153 57.662153 58.060327 57.889945 57.889945 57.908081 57.859741 57.825748 58.393985 58.568647 58.624948 58.624948 59.068049 59.05935 58.801434 58.287501 58.289169 58.289169 58.25698 58.25698 58.069832 57.82709 126273 127099 127755 128418 128939 129232 129589 130320 131002 131681 132314 132588 132858 133249 134251 135163 136142 137003 137753 138145 138620 139579 140601 141582 142552 143380 143806 144343 145534 146768 147962 149128 150055 150519 151116 152449 153914 155765 157215 158252 158678 159283 160697 162034 26156.1 25445.94 25745.6 25015.55 25015.55 25015.55 25595.8 25812.88 25734.97 25827.36 25827.36 25827.36 25827.36 26287.03 25890.18 26067.28 25706.09 26075.3 26075.3 26075.3 26085.8 26642.59 26870.1 26734.71 26671.95 26671.95 26671.95 26680.87 26840.4 27005.84 26652.33 26469.89 26469.89 26469.89 26584.77 26379.28 26539.57 26313.65 26428.32 26428.32 26428.32 26664.4 26828.47 27201.52 0.264 0.260 0.260 0.261 0.261 0.261 0.250 0.250 0.225 0.249 0.225 0.225 0.225 0.260 0.260 0.260 0.260 0.220 0.220 0.245 0.220 0.200 0.291 0.300 0.294 0.240 0.245 0.234 0.234 0.234 0.255 0.255 0.255 0.216 0.216 0.205 0.230 0.235 0.235 0.215 0.290 0.255 0.245 0.245 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 209 210 211 212 213 214 215 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 8/18/20 8/19/20 8/20/20 8/21/20 8/22/20 8/23/20 8/24/20 8/25/20 8/26/20 8/27/20 8/28/20 8/29/20 8/30/20 8/31/20 9/1/20 9/2/20 9/3/20 9/4/20 9/5/20 9/6/20 9/7/20 9/8/20 9/9/20 9/10/20 9/11/20 9/12/20 9/13/20 9/14/20 9/15/20 9/16/20 9/17/20 35.635448 35.635448 35.635448 35.635448 35.635448 35.635448 35.455648 35.597263 35.469771 35.469771 35.469771 34.677532 34.677532 34.235002 34.235002 34.544605 34.633147 34.633147 34.685538 34.685538 34.052401 34.052401 34.052401 34.052401 34.052401 34.289486 34.085894 33.91514 33.77779 33.60439 33.754825 33.754825 33.754825 33.628739 35.139651 33.509382 33.509382 32.829021 32.829021 32.809123 32.809123 32.446882 32.537436 56.458081 56.458081 56.458081 56.458081 56.458081 56.973458 56.973458 56.973458 56.973458 56.973458 56.973458 57.24885 56.552666 56.552666 56.553667 56.553667 56.553667 56.553667 56.038485 55.490277 55.523735 55.523735 55.523735 55.523735 55.523735 54.992639 54.287718 54.287718 54.287718 54.287718 54.287718 54.287718 54.287718 53.926919 53.075169 53.075169 53.075169 53.075169 53.075169 52.784365 52.590802 52.590802 52.590802 58.062767 58.051084 58.194631 58.194631 58.194631 58.171805 57.929143 57.32529 57.341293 57.309799 57.309799 57.938603 57.893441 57.731978 57.791368 57.87988 57.96278 57.96278 58.413279 58.396913 58.047228 58.043199 58.043199 58.017649 58.098503 58.121705 57.72857 56.979942 56.979942 57.074155 57.074155 57.074155 57.074155 56.985575 56.641147 56.39836 56.325921 56.325921 56.086824 55.978339 55.98395 56.032443 55.981212 163264 164598 165618 166148 166701 168204 169612 170918 172082 173193 173720 174295 175692 176980 178078 179252 180230 180677 181170 182459 183750 184891 185999 186957 187331 187846 189013 190109 191224 192262 192972 193406 193696 194178 195388 196476 197569 198279 198677 199155 200350 201362 202243 27386.98 27433.48 27433.48 27433.48 27791.44 27686.91 27976.84 27896.72 27931.02 27931.02 27931.02 27844.91 27778.07 27692.88 27739.73 27930.33 27930.33 27930.33 28308.46 28248.44 28331.92 28492.27 28653.87 28653.87 28653.87 28430.05 28645.66 29100.5 28292.73 28133.31 28133.31 28133.31 28133.31 27500.89 27940.47 27534.58 27665.64 27665.64 27665.64 27993.33 27995.6 28032.38 27901.98 0.248 0.257 0.310 0.250 0.270 0.310 0.282 0.280 0.270 0.270 0.270 0.270 0.280 0.240 0.251 0.250 0.255 0.260 0.270 0.270 0.330 0.255 0.253 0.279 0.279 0.295 0.280 0.271 0.273 0.306 0.250 0.281 0.265 0.300 0.275 0.260 0.265 0.270 0.270 0.275 0.267 0.275 0.278 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 9/18/20 9/19/20 9/20/20 9/21/20 9/22/20 9/23/20 9/24/20 9/25/20 9/26/20 9/27/20 9/28/20 9/29/20 9/30/20 10/1/20 10/2/20 10/3/20 10/4/20 10/5/20 10/6/20 10/7/20 10/8/20 10/9/20 10/10/20 10/11/20 10/12/20 10/13/20 10/14/20 10/15/20 10/16/20 10/17/20 10/18/20 10/19/20 10/20/20 10/21/20 10/22/20 10/23/20 32.593159 32.385982 32.385982 32.073641 32.073641 31.888428 31.547757 31.547757 31.547757 31.505751 31.505751 31.505751 31.811273 31.811273 31.811273 31.811273 31.552346 31.552346 31.552346 31.552346 31.552346 31.552346 31.552346 31.628771 31.628771 31.415529 31.131314 31.131314 31.131314 31.131314 31.131314 31.131314 30.504082 30.391838 30.391838 30.391838 52.590802 52.590802 52.590802 52.836267 52.497756 52.497756 52.497756 52.497756 52.497756 52.497756 52.497756 52.571008 52.5230 52.5230 52.520828 52.331479 52.331479 52.331479 52.675834 52.675834 52.675834 52.675834 52.675834 52.675834 52.675834 54.19666 54.19666 54.19666 54.19666 54.19666 54.19666 54.19666 53.027302 53.027302 53.027302 53.027302 55.94792 55.94792 55.986788 56.206525 56.215412 56.485242 56.499633 56.374286 56.46874 56.46874 56.415474 56.383355 56.459563 56.462899 56.4821 56.53996 56.591676 56.51929 56.781179 56.591352 56.617121 56.667652 56.667652 56.742816 56.742816 56.741423 56.676862 57.364492 57.372575 57.372575 57.372575 57.522551 57.615606 57.629239 57.47778 57.384171 203195 203856 204155 204535 205514 206628 207549 208444 209182 209459 209811 210787 211743 212661 213524 214284 214620 215045 215852 216781 217738 218647 219372 219699 220030 220873 221843 222716 223644 224313 224792 225244 226192 227413 228385 229287 27657.42 27657.42 27657.42 27147.7 27288.18 26763.13 26815.44 27173.96 27173.96 27173.96 27584.06 27452.66 27781.7 27816.9 27682.81 27682.81 27682.81 28148.64 27772.76 28303.46 28425.51 28586.9 28586.9 28586.9 28837.52 28679.81 28514 28494.2 28606.31 28606.31 28606.31 28195.42 28308.79 28210.82 28363.66 28335.57 0.278 0.251 0.240 0.261 0.258 0.259 0.253 0.252 0.252 0.260 0.256 0.280 0.252 0.219 0.204 0.150 0.200 0.210 0.240 0.202 0.205 0.200 0.230 0.220 0.202 0.214 0.250 0.231 0.230 0.218 0.220 0.209 0.193 0.150 0.185 0.200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A federal agency is developing a system to collect and analyze census data, including personally identifiable information (PII) and sensitive demographic details. The agency must protect individual...

Compute exponential smoothing forecasts with smoothing constant a=.3. Use Presidential 2020 Election Data and Homework data and templates.xlsx What is the forecast for Last Price on October 24? What...

M7_A1. Jennifer Kelly is a WCU student who has just finished her junior year. The data in Worksheet A1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) Compute the...

Compute moving average forecasts of interval MA(3). Use Presidential 2020 Election Data and Homework data and templates.xlsx What is the forecast for Last Price on October 24? What is MAE? What is...

Compute moving average forecasts of interval MA(5). Use Presidential 2020 Election Data and Homework data and templates.xlsx What is the forecast for Last Price on October 24? What is MAE? What is...

Compute moving average forecasts of interval MA(3). Use Presidential 2020 Election Data and Homework data and templates.xlsx What is the forecast for Last Price on October 24? What is MAE? What is...

Fall Semester, AY 2016-2017 ASSIGNMENT 1 BUSN 401-Quantitative Techniques in Business & Management Student's Name: ID Number: EXERCISE 1. Discuss the differences between statistics as numerical facts...

1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2...

20/FA Uperations Management (BUSI-3308-18, BUST-3308-16) ton 1 yet wered What is the value of a loyal customer in the small dog retail target market who buys 3 dog beds a year for $75.00, the gross...

Question. Material Handling Equipment (MHE) Forecasting The demand management department of a Material Handling Equipment (MHE) manufacturing company is responsible for generating demand forecasts...

FORECASTING HOMEWORK Using the textbook and powerpoints as your guide, complete the following forecasting calculations. Make sure that you show your work (this is important for partial credit). The...

Number 12.6 Please help me 502 Lagrangian and Hamiltonian Dynamics Chap. 12 12.6. A point mass m is constrained to move on a circle of radius R and acted on by a force F, as shown in Fig. P12.6....

Ben is single and 28 years of age. He earned a salary of $80,000 in 2020 as a computer tech by ICE Company. Ben was covered for the entire year 2020 under ICE's qualified pension plan for employees....

and credit a . Equipment; Accumulated Depreciation - Equipment b . Accumulaied Depreciation - Equipment; Equipment c . Equipment; Depreciation Expense - Equipment d . Accumulated Depreciation -...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...