1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance...

  
 
 
 

Transcribed Image Text:

1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 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 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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 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 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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 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 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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 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 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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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 1. Compute regression modeling forecasts (Model that only uses Days as a predictor). Use a significance level of .05. Use Presidential 2020 Election Data and Homework data and templates.xlsx a. What is the forecast for Last Price on October 24? b. What is MAE? c. What is MSE? d. What is MAPE? e. Is there a trend in the data? 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 Date 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 Worry about Infection Worry about Economy Effectiveness of Trump's Response Corona Virus Deaths Dow Ind. Ave. (Daily Inde: "Y" lowa (Lastprice Republican 18.43492 29398 0.415 22.7564 22.2899 26.48684 27.53751 18.43492 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 18.43492 22.2899 17.55785 22.2899 17.55785 25.62871 17.55785 25.62871 17.90033 25.62871 17.90033 17.90033 17.90033 19.82386 19.82386 19.82386 19.82386 19.82386 20.62768 22.4908 22.10178 22.4244 22.32016 22.14673 22.14673 23.27218 23.74623 23.46276 23.46276 24.29691 24.29691 24.29691 27.28671 27.9404 29.26733 30.44253 30.51298 30.5966 30.97512 25.62871 28.73197 28.73197 32.43756 32.43756 33.17934 33.17934 33.17934 33.83747 33.85994 34.21951 34.21951 34.21951 34.09245 34.88319 37.13918 42.46375 44.04733 45.38528 45.38528 47.62551 47.62551 52.73412 52.73412 54.05219 54.05219 55.76489 55.76489 55.76489 27.53751 27.53751 27.53751 27.53751 27.53751 27.53751 28.33005 28.85493 28.85493 38.02801 38.02801 39.05365 39.05365 42.81175 42.81175 43.73902 43.73902 45.39878 47.1093 47.45365 47.46267 49.0095 48.739 49.09423 49.09134 48.80058 49.0646 48.95124 48.58893 46.88491 46.76443 46.76443 46.16106 46.01105 46.332 46.1678 46.58516 46.63401 46.88109 oooo00 0 0 0 0 0 0 1 1 6 9 11 12 15 19 22 26 30 38 41 48 58 73 95 121 171 240 311 377 513 694 963 1270 1630 2132 2782 29232.19 29348.03 29219.98 28992.41 28992.41 28992.41 27960.8 27081.36 26957.59 25766.64 25409.36 25409.36 25409.36 26703.32 25917.41 27090.86 26121.28 25864.78 25864.78 25864.78 23851.02 25018.16 23553.22 21200.62 23185.62 23185.62 23185.62 20188.52 21237.38 19898.92 20087.19 19173.98 19173.98 19173.98 18591.93 20704.91 21200.55 22552.17 21636.78 21636.78 0.430 0.425 0.428 0.450 0.425 0.490 0.486 0.438 0.495 0.480 0.467 0.445 0.450 0.452 0.439 0.429 0.385 0.420 0.420 0.410 0.385 0.353 0.400 0.405 0.414 0.379 0.379 0.393 0.393 0.375 0.376 0.392 0.353 0.353 0.360 0.365 0.320 0.340 0.340 0.340 45 44 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 73 7 74 75 76 77 78 79 80 3/29/20 3/30/20 3/31/20 81 82 83 4/1/20 4/2/20 84 85 4/3/20 4/4/20 4/5/20 4/19/20 4/20/20 4/21/20 67 4/22/20 68 4/23/20 4/6/20 4/7/20 69 4/24/20 70 4/25/20 71 4/26/20 72 4/27/20 4/28/20 4/29/20 4/30/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 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 115 116 117 118 119 120 121 122 123 124 5/11/20 5/12/20 5/13/20 125 126 127 128 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 95 96 97 98 99 100 101 5/26/20 102 5/27/20 103 104 105 106 107 108 109 110 111 112 113 114 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/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 6/23/20 130 6/24/20 131 6/25/20 132 6/26/20 133 6/27/20 134 6/28/20 135 6/29/20 136 137 138 139 140 141 142 143 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 144 145 146 147 148 149 150 151 152 153 7/17/20 154 7/18/20 155 7/19/20 156 7/20/20 157 7/21/20 158 7/22/20 159 7/23/20 160 7/24/20 161 7/25/20 162 7/26/20 163 7/27/20 164 7/28/20 165 7/29/20 166 7/30/20 167 7/31/20 168 8/1/20 169 170 171 172 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/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 173 174 175 176 177 178 179 180 181 182 183 184 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 211 212 213 214 215 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 185 8/18/20 186 8/19/20 187 8/20/20 188 8/21/20 189 8/22/20 190 8/23/20 191 8/24/20 192 8/25/20 193 8/26/20 194 8/27/20 195 8/28/20 196 8/29/20 197 8/30/20 198 8/31/20 199 9/1/20 200 9/2/20 201 9/3/20 202 9/4/20 203 9/5/20 204 9/6/20 205 9/7/20 206 9/8/20 9/9/20 207 208 209 9/11/20 9/10/20 210 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 9/18/20 216 217 9/19/20 218 9/20/20 219 9/21/20 220 9/22/20 9/23/20 221 222 9/24/20 223 9/25/20 224 9/26/20 225 9/27/20 226 9/28/20 227 9/29/20 9/30/20 10/1/20 230 10/2/20 231 10/3/20 232 10/4/20 233 10/5/20 234 10/6/20 10/7/20 235 236 10/8/20 237 10/9/20 238 10/10/20 239 10/11/20 240 10/12/20 241 10/13/20 242 10/14/20 243 10/15/20 244 10/16/20 245 10/17/20 246 10/18/20 247 10/19/20 248 10/20/20 249 10/21/20 250 10/22/20 251 10/23/20 228 229 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

Answer rating: 100% (QA)

Solution The kinetic energy available for the beta particle and the an... View the full answer