Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Road construction contracts in Florida are awarded based on competitive, sealed bids. The contractor who submits the lowest bid wins the contract. During the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
2. Road construction contracts in Florida are awarded based on competitive, sealed bids. The contractor who submits the lowest bid wins the contract. During the 1980's, the Florida Attorney General (FLAG) suspected contractors of practicing bid collusion, Le., setting the winning bid price above the fair price in order to increase profit. By comparing the bid prices (and other bld variables) of the fixed (or rigged) I contracts to the competitively bid contracts, FLAG was able to establish benchmarks for detecting future bid-rigging. FLAG collected data for 235 highway construction contracts. The data (ELAG sav) is attached and a description of the variables are given below: Column 1: Contract number Column 2: Contract cost (thousand dollars) Column 3: DOT engineer's cost estimate (thousand dollars) Column 4: Ratio of the second lowest bid to low bid Column 5: Ratio of the third lowest bid to low bid Column 6: Ratio of highest bid to low bid Column 7: Bid status (1Fixed, O=Competitive) Column &: Location (1=South Florida, O=not) Column 9: Ratio of number of bidders to number of plan holders Column 10: DOT engineer's estimate of number of workdays required (1) Bulld a regression model for the contract cost. Apply stepwise regression to select the independent variables from variables in columns 3-10 (2) Interpret the estimated coefficients of the regression model obtained in (1) (3) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any (4) Discuss the seriousness of multicollinearity in the model obtained in (1) MacBook Air Column 3: DOT engineer's cost estimate (thousand dollars) Column 4: Ratio of the second lowest bid to low bld Column 5: Ratio of the third lowest bid to low bld Column 6: Ratio of highest bid to low bid Column 7: Bid status (1-Fixed, 0-Competitive) Column 8: Location (1=South Florida, O-not) Column 9: Ratio of number of bidders to number of plan holders Column 10: DOT engineer's estimate of number of workdays required (1) Build a regression model for the contract cost. Apply stepwise regression to select the Independent variables from variables in columns 3-10. (2) Interpret the estimated coefficients of the regression model obtained in (1). (3) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any. (4) Discuss the seriousness of multicollinearity in the model obtained in (1). (5) Make a histogram of the dependent variable (Contract Cost), comment on the shape of the histogram. (6) Do a natural log transformation of the dependent variable (name it for ContractCost), make a histogram of Contractcost, comment on the shape of the histogram. (7) Take natural log transformation of "DOT engineer's cost estimate" (name it LORROT). Build a regression to estimate lorContractCost Apply stepwise regression to select Independent variables (replace "DOT engineer's cost estimate with log DOT"), (8) Interpret the estimated coefficients of the regression model obtained in (6). 19) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any. (10) Discuss the serlousness of multicollinearity in the model obtained in (6). MacBook Air 0 0 K ISI VS VE ZA! BA 1 2 3 101 1.01 1.12 106 1.01 VB 1 1 0 4 1 0 0 5 101 6 7 8 SOM 0 1 1 1 0 1 9 10 lelos 0 1 0 13 1 1 127 1410 109 114 133 1AR 128 1.14 1.08 105 163 158 124 131 120 111 1.21 115 3 1 1 0 O 14 15 16 12 0 0 0 1 0 D 0 1 1 1 1 1 1.27 1 1 0 1 1.01 1.06 1.10 1.09 1.05 107 1.08 1.08 1.02 1.16 1.07 1.08 1.05 1.02 107 1.02 105 1.06 1.11 108 1.12 100 1.00 102 104 1.02 102 1:01 1.10 101 1.04 107 1.06 1.08 110 115 101 1.01 1.22 111 110 1109 1714 1.17 1.28 1:19 1.14 105 1.05 1.19 1.16 124 121 1.20 1.11 121 109 108 113 1.10 1.18 117 1.05 105 1.27 1.02 1.03 1:05 116 1:09 106 113 1.13 108 126 112 1.15 1.15 1.10 1 1 SENARANNARS A V VA 2879 43 138699 2 134.00 85.71 3 202.33 248.89 4 39722 467 49 158.54 117.72 1128.11 100N 93 7 40033 472.98 8 581.64 785.39 9 353 96 37002 10 138.71 174.25 11 383.66 410.95 12 3910.94 3405.94 13 362.92 385 96 14 196.50 235.41 15 637 99 62741 16 152.06 175.40 17 375.00 432.33 2284.56 1499.04 19 S51.45 497.74 20 239.57 194,65 21 207.87 16799 22 540.48 767 80 23 230.54 260.30 24 299.87 24704 25 2368.84 2456.77 26 496 49 879.40 27 1564.87 1303:40 28 238703 6107.93 29 195.68 199.09 30 830.47 715 46 179.06 208.72 150.35 199.09 240.06 629.24 586.81 709 85 537.12 67642 392.69 490:55 216.47 406.47 38 1559.37 192531 39 8831 143.07 40 26845 305.09 41 189.02 26955 42 192.81 227.70 256.22 436.79 44 11361 132.39 43 124.99 121.61 116 57 11421 14:13 172.71 48 36.19 6444 49 251339 312439 50 135351 151752 5 31282 37537 52 202.50 300 32 53 604331 707499 54 22808! 2823.87 1 0 0 1 VIO 03 250 DO 0.75 AS DO 0:50 120.00 0.50 180.00 038 0.00 0.60 200.00 0.60 70.00 050 2000 0.57 75.00 083 70.00 043 60X) 045 350.00 0.88 100.00 0.70 120.00 050 140.00 050 75.00 052 120.00 0.60 270.00 0.60 100.00 0.60 65.00 0.62 50.00 0.40 90.00 0.43 125.00 060 80 DO 0.31 320.00 0.58 140.00 0.33 200.00 0.62 340,00 0.60 50.00 0.52 135.00 0.63 90.00 0.64 100.00 0.71 120.00 0.60 120.00 023 225.00 0.50 180.00 0.52 130.00 0.43 250.00 0.71 55.00 9.67 75.00 0.36 115.00 0.83 60.00 0.88 225.00 0.69 70.00 0.52 40.00 0.52 35.00 0.60 50.00 0.53 6000 0.57 255.00 0,41 200.00 0.62 149.00 0:42 100.00 0:58 350.00 0.53 30:00 0 0 1 1 0 113 1.10 1:49 138 1.05 106 1.27 109 1.61 1-55 1,73 139 1.26 1.65 1:58 1.60 1.50 1.33 1.95 1:45 0 0 ZE EE VE SE SE LE 135 36 0 0 0 0 0 0 1 1 38 39 40 141 42 43 44 25 6 O 0 0 OO g 104 100 1 0 0 101 0 1.61 1.27 1.92 13 0 D Or 101 1.00 1.00 1.09 125 102 1.13 1.00 D 0 0 0 0 D 1 O 113 1.22 1.14 1:32 1.04 1.23 1:05 123 1:03 09 90 51 32 51 34 OST TET IVE VS1 GET 1 0 O 102 1.08 139 log K E 1109 2.30 0 1 189 159 155 189 126 145 Poloplevel HDMI 1.36 1 1 o 145 1.25 aald O HD 55 56 57 58 55 60 61 62 63 64 65 66 62 68 69 70 71 72 73 74 75 76 77 1:36 1:20 O 0 0 0 1 1 123 OOOOOOOO 0 1 D 1DB 117 102 101 1.00 1.06 1.07 102 101 109 1.00 1.00 107 114 1.30 1.20 1.07 101 1.05 100 1.00 1.05 107 1.00 1.29 1.00 1.00 1.15 1.08 101 100 1.00 101 1.05 1.06 103 102 114 107 101 1,05 112 100 102 104 105 105 102 1.71 1.96 147 138 1.36 1.49 1:34 1.22 2.09 1.46 2.39 1.22 1.32 0 0 0 0 5 5422021 282387 SS 99.92 118.99 56 146159 1774.72 57 121757 1841. OB 58 258 44 306 44 59 115AZ 117.94 60 46.93 540.01 61 72886 763.02 62 3929.92 394157 63 18169 194.82 64 479 47 487.17 65 93.48 92.36 66 2301.07 2505.60 67 136.06 181.09 68 144.06 252.92 69 65.17 84.75 70 161.33 164.03 71 1138 54 1254.62 72 84.79 9763 73 749.13 859.34 74 43.67 41.09 75 2920.71 2812.50 76 32.63 40.05 77 1115.12 1148.53 78 50.66 59.86 79 2229.34 2434,60 80 2159.85 2698.59 81 45.91 51.89 82 122.31 13752 83 14781 14334 84 470.71 447.75 85 188.67 20246 86 476517 5035.94 82 168.53 163.67 95.86 95.63 89 106.92 10789 90 698.48 64643 92 296.00 959.69 92 689.73 80151 93 3184 90584 94 215015 216137 95 169.75 18732 96 92358 88737 97 2527 47 26161 98 726 58 79827 99 1187.10 1573.45 100 18 02 149.28 10 147.56 162 23 04:24 11602 58052 575.41 100 445.52 3503 105 1106 120.07 106 4517 0828 107 00:00 103145 100 4954 54131 0 0.53 056 0.52 092 0.70 0.85 0.63 0.23 0.67 0.63 0.53 0.83 0.78 0.33 0.67 0.54 0.80 0.68 0.60 0.93 0.80 0.50 0.70 0.64 057 0.46 0.50 057 0.67 0.60 0.57 0.54 0.52 0.80 080 0.70 0.58 0.64 101 1.02 1.10 1.11 104 1.06 1.16 1.05 103 109 1:23 1:31 1.37 1.10 103 1.10 1.05 1.22 1.12 1.26 1.09 1.63 1.09 1.06 1.52 1.12 116 101 *09 105 108 109 1.07 1.11 1:16 1:15 104 107 1.12 1.00 1.15 1.09 111 1-27 124 79 BO 81 82 83 O 2013 390.00 70.00 220.00 350.00 75.00 65.DO 120,00 200.00 400.00 50.00 140.00 60.00 400.00 100.00 90.00 60.00 100.00 200.00 50.00 180.00 30.00 315.00 35. DO 250.00 50.00 450.00 360.00 60.00 30.00 50.00 150.00 120.00 300.00 30.00 30.00 30.00 180.00 175.00 210.00 190.00 400.00 100.00 130,00 350.00 220.00 230.00 40.00 GOOD 75.00 223.00 150.00 70.00 35.00 425.00 100D DOOHOOOOOOOOOOOOOOOOOOO 0 1 0 o 0 0 86 88 89 90 91 92 1.16 132 1.70 1.27 1.30 1.40 129 165 128 1.27 123 129 119 1:29 14: 12: 136 0 038 0 95 96 97 0 1 1 4 0 0.64 0.53 0.75 088 0.50 0 45 0.50 083 0.67 058 0125 036 0.71 0.75 03 300 103 102 103 104 105 de 107 10 116 1127 154 13 242 10 121 1.13 ODOO 101 133 100 12 120 200 16 19 1.13 143 1024 TOO 1:23 14 0 O For + 0 H 145 1.24 1:39 116 BIG DOO 139 D D 0 1 1 0 0 0 1 105 109 110 111 112 113 114 115 116 117 518 119 120 121 122 123 124 125 126 127 128 129 130 131 132 130 134 135 D 395.98 1.20 1.00 104 101 1.03 103 101 107 100 102 1.08 1.00 1.13 1.05 1.10 121 1.05 1.03 103 1.03 1.02 1.04 1.01 1.13 1.01 1.05 105 105 1.02 1.01 100 1.04 101 103 1.03 1.23 114 1.11 11.06 110 1.09 143 107 102 1.04 108 104 1.16 112 1.20 1.26 1.73 1.05 111 1.06 1.04 1.05 1.13 1.17 1.33 1.18 107 1.08 104 107 113 111 1 30 106 DDODDOOOOOOOOOOOOOOOOOOOOOOOO OOOO 0 1 1 0 107 800,60 1031 AS 108 495 A7 541.81 109 1370.06 137792 110 607 51 809.09 111 152.72 16124 112 728 20 916.97 213 181.59 146.46 114 462.92 50479 115 169.38 144.51 116 2473.26 2618 24 117 2346.77 244781 118 170.42 196.75 119 77.85 109.91 120 4770.88 751133 121 303 34 341 22 122 419.00 123 150.55 174.48 124 1404.08 1573.83 125 1691.66 162708 126 5195.22 6365.13 127 3815.88 4960.82 128 122.62 95.38 129 1571.15 1759.21 130 4385.47 5555.82 131 449756 5186 30 132 23.67 3254 133 1048.86 1040 53 23951 315.11 135 260.54 351.80 13889 12331 137 128.38 15189 138 284.98 315.97 139 27:32 10104 140 5411:51 5086.25 143 3854 60 399103 142 2976.03 2832:43 143 25751 205-86 144 36 44 42104 182.52 223:13 146 136702 1433.62 147 7631 75.25 148 174788 1493.45 149 573442 542731 150 5884.70609741 151 34652 331 10 152 546.40 153 76084 71824 154 169.77 17595 155 138.79 15162 150 315.76 39421 1157 108212 10587 153 253.60 27093 239 43.15 545.26 269 10270.10462.40 161 1300 + 1.18 143 3120 1.02 1.06 1.34 1.07 115 142 1:40 1.26 1.73 1.25 1.12 1.30 1.07 1.07 127 1.72 1.52 2.23 1.28 1.18 1.18 107 1:13 111 1.30 130 1.49 1:56 1.06 110 126 135 105 13! 132 122 148 1960 1 1 1 0 0.73 0.83 OSB 0.67 0.75 0.62 0.75 0.50 0.50 0.33 OBO 0.75 050 052 0.78 043 0.50 0.58 0.63 0.43 0.18 0.40 0.63 0.32 0.26 0.78 0.67 0.80 0.80 0.50 0.60 0.50 0.50 0.39 0:41 0:38 0.80 0.75 0.40 0.80 0.25 0.55 0.89 0.39 0.63 0.45 0.50 O 1 1 425.00 140 DO 400 DO 185 DO 155.DO 185.00 135.00 175.00 145.00 630.00 455.00 75.00 80.00 500.00 210.00 185.00 110,00 550.00 500.00 805.00 450.00 120.00 385.00 600.00 750.00 60.00 300.00 100.00 120.00 150.00 75.00 110.00 90.00 815.00 800.00 440.00 130.00 45.00 90.00 475.00 90,00 445.00 70000 900.00 190.00 490,00 185.00 125.00 69.00 150.00 40000 200.00 230.00 120.00 450.00 1 137 138 1 0 1140 141 142 10 1:07 0 117 105 110 1 1 126 0 0 o 1 145 146 147 IE 149 1150 151 ESZ 353 3154 101 1:02 5.00 107 102 101 102 103 1412 129 1.02 1.02 1:03 OOO 0 108 106 1.19 103 103 112 13 105 103 10 1:12 B1854 0 1 1 05 156 557 355 159 1160 0 COOOOO 100 HO 102 200 04 105 108 113 135 134 25 12 123 1:34 115 . 13 0.25 0.38 0.67 050 DO 562 040 091 tag * T 1 olole 1 0 E 10 109 125 121 107 1313 102 D 0 0 164 1 1 0 0 D 131 0 0 1 1 0 1 165 164 165 166 167 168 5169 170 171 172 273 174 175 176 172 178 179 10 181 162 183 184 185 186 0 0 1 1 + OOOOOO D 100 102 144 109 101 103 1.02 1.07 1.04 119 1.06 1.01 1.14 100 1.04 101 105 1.03 1.07 105 1:02 104 1.02 1.04 1.06 116 110 1.04 106 1.00 108 1.01 104 103 1 1 1 1 lo 0 0 1 0 1 104 122 1.22 106 135 1.08 108 109 108 1.06 1.09 107 107 110 1.02 1.06 1.16 1.18 112 105 LOR 1.16 1.09 105 106 1:13 1 0 1 1 1 0 F 103 1.38 131 121 1.33 1.13 110 131 129 122 122 109 137 1.11 1.08 1.09 1.08 1106 118 1.07 107 1:33 1.25 1.06 1.24 1.19 112 107 10B 139 1.09 119 106 1.19 105 1.15 1.18 1.12 1.09 1.02 1.05 118 1.13 1.40 1.18 103 1.09 1.12 119 1.11 107 1.16 1 1 A 162 714018 215201 163 6584.11 5949.35 164 666.72 54152 165 108. OS 99.56 106.10 95.29 167 549.64 413.08 168 127204 949.46 169 12282 13226 170 35945 333 AS 171 1731.47 167253 172 31.72 28.30 173 3299.96 2805 89 124 480.56 480.31 175 673.09 655.81 176 116.99 9994 177 1157.39 891.21 178 165.80 131.99 179 668.53 596 89 180 7622.16 787119 181 20132 182.94 1821270.05 130633 1831055614 1148.65 164 5212 23 5090.86 185 5654.86 5447.59 186 856.46 935.14 88.98 66.06 185 200.00 168.99 189 23404 179.74 190 116.56 125 BS 191 8211 9304 192 20781 21425 193 463.28 474.89 1947385.55 8460.87 195. 91.56 2003: 196 546.16 52292 192 740.30 810 26 198 888.44 383 199 656.75 750.82 1884.39 1550 49 4197.79 202 256-20 181.95 203 1949.63 1880.83 204 23528 230.75 205 35.18 3921 206 244.76 221 88 648.92 563.88 208 39147 35053 209 26778 24951 210 2130.04 2019 27 211 10123 303.19 212 107790 87872 210 92738 90203 214 241.70 243:37 65.79 H236 2:6 1206 44 1210 33 flag 1 1 0A3 0.50 0.56 O.SO 0.86 0.60 056 0.30 9.50 0.35 0.50 044 0.67 083 0.75 0.75 043 0.75 0.38 0743 0.75 0.45 0.56 0.38 0.50 0.50 0.75 0.80 0.75 0.75 0.50 0.89 0.23 0.57 0.38 0.44 0.83 0.44 0.43 0.50 O.RO 0.44 0.83 0.60 0.80 0.60 0.60 0.36 0.71 0.60 0. 0.25 0.75 0.44 400.00 675.00 240.00 55.00 125.00 120.00 450.00 130.00 190,00 400.00 60.00 525 DO 125.00 100.00 100.00 450.00 120.00 120.00 700.00 90.00 195.00 400.00 500.00 500.00 375.00 90.00 90.00 170.00 80.00 100.00 155.00 215.00 505.00 90.00 165.00 275.00 250.00 180.00 350.00 660.00 330.00 330.00 90.00 45.00 90.00 140.00 10000 255.00 450.00 110.00 190.00 400.00 45.00 60.00 295.00 190 191 192 193 0 0 OOOOO 0 0 0 0 195 192 100 HOON 0 0 199 200 1 100 1.02 1.03 1.02 1.00 101 105 1.03 104 107 1.09 102 103 004 . TOZ 1 1 1 1 1 1 1 1 1 1 1.11 102 O 202 203 204 205 205 207 200 209 1 103 101 102 1 207 1 101 0 0 0 0 211 109 1.40 103 101 1.09 107 117 1.11 106 116 117 1.20 23 0 1 0 1.04 1:11 1 OR 104 111 103 119 100 213 214 215 216 212 1 0 1 2 215 1.50 0 0 + 1201 HI 105 1.09 1.03 109 1.12 1.19 1.11 1 1 1 0 1 Ololog 53 SERIES 10 1 0 0 107 1.02 103 104 1.11 1.08 1.04 1.11 105 1.19 1.00 1.02 1.01 HO 12 13 14 15 16 17 18 19 20 21 22 1 1 1 0 0 0 1 o 1 1 OOO Holo 205 2:44.76 WATER 207 648.92 563.88 208 391.47 358.53 209 267.78 249.91 210 213004 2019.87 211 301.23 303.19 212 1077.90 878.72 213 927.38 902.03 214 241.70 243.97 215 65.79 82.36 216 1208.44 1230.33 217 9453 35 9479.73 218 7098.11 8296.80 219 912 06 1137.65 220 259.99 319.59 221 8992 25 10743.60 222 33988 428.82 223 833 66 859.74 224 4833.82 6225.04 225 271.94 223.89 226 2966.28 4433 47 227 577.37 701.07 228 10480 32 10276.29 229 462.39 444.19 230 2558.19 2741.05 231 2814.91 2816.73 232 119.81 122.16 233 3184.86 3373.04 234 473.20 54801 235 400.48 496.68 1.00 1.01 103 OH 1.09 1.07 1.17 1.11 1.06 1.16 1.17 1.20 1.31 1.03 1.04 1.29 1.07 1.05 1.24 1.06 1.07 1.03 1.31 1.26 1.04 1.04 1:16 1.12 107 1.03 113 1.08 W0 0.60 0.60 0.36 0.71 0.60 0.80 0.25 0.75 0.44 0.31 032 0.50 0.33 0.80 0.45 0.38 0.33 0.53 0.67 0.25 0.25 0.69 0.80 0.44 0.55 0.67 0.58 0.38 0.50 1 90.00 140.00 100.00 255.00 450.00 110.00 190.00 400.00 45.00 60.00 295.00 500.00 510.00 220.00 90.00 650.00 165.00 450.00 520.00 110.00 720.00 150.00 570.00 120.00 365.00 540.00 90.00 240.00 130.00 90.00 23 1.16 117 123 1.50 1.14 1.20 1.29 1.07 1.37 124 6.05 1.37 1.11 1.51 1:26 1.30 1.06 1.20 1:25 1:30 1.36 113 1.19 o 1 OOH OH 1.20 1.05 1.00 1.01 1.08 1.00 1.03 1.04 1.14 1.02 1.00 1.00 1:11 1.07 1 1 1 1 OOO OO 1 24 225 326 327 28 229 230 231 232 233 334 235 236 237 236 239 240 241 242 243 244 245 246 247 248 249 259 251 252 253 254 355 2. Road construction contracts in Florida are awarded based on competitive, sealed bids. The contractor who submits the lowest bid wins the contract. During the 1980's, the Florida Attorney General (FLAG) suspected contractors of practicing bid collusion, Le., setting the winning bid price above the fair price in order to increase profit. By comparing the bid prices (and other bld variables) of the fixed (or rigged) I contracts to the competitively bid contracts, FLAG was able to establish benchmarks for detecting future bid-rigging. FLAG collected data for 235 highway construction contracts. The data (ELAG sav) is attached and a description of the variables are given below: Column 1: Contract number Column 2: Contract cost (thousand dollars) Column 3: DOT engineer's cost estimate (thousand dollars) Column 4: Ratio of the second lowest bid to low bid Column 5: Ratio of the third lowest bid to low bid Column 6: Ratio of highest bid to low bid Column 7: Bid status (1Fixed, O=Competitive) Column &: Location (1=South Florida, O=not) Column 9: Ratio of number of bidders to number of plan holders Column 10: DOT engineer's estimate of number of workdays required (1) Bulld a regression model for the contract cost. Apply stepwise regression to select the independent variables from variables in columns 3-10 (2) Interpret the estimated coefficients of the regression model obtained in (1) (3) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any (4) Discuss the seriousness of multicollinearity in the model obtained in (1) MacBook Air Column 3: DOT engineer's cost estimate (thousand dollars) Column 4: Ratio of the second lowest bid to low bld Column 5: Ratio of the third lowest bid to low bld Column 6: Ratio of highest bid to low bid Column 7: Bid status (1-Fixed, 0-Competitive) Column 8: Location (1=South Florida, O-not) Column 9: Ratio of number of bidders to number of plan holders Column 10: DOT engineer's estimate of number of workdays required (1) Build a regression model for the contract cost. Apply stepwise regression to select the Independent variables from variables in columns 3-10. (2) Interpret the estimated coefficients of the regression model obtained in (1). (3) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any. (4) Discuss the seriousness of multicollinearity in the model obtained in (1). (5) Make a histogram of the dependent variable (Contract Cost), comment on the shape of the histogram. (6) Do a natural log transformation of the dependent variable (name it for ContractCost), make a histogram of Contractcost, comment on the shape of the histogram. (7) Take natural log transformation of "DOT engineer's cost estimate" (name it LORROT). Build a regression to estimate lorContractCost Apply stepwise regression to select Independent variables (replace "DOT engineer's cost estimate with log DOT"), (8) Interpret the estimated coefficients of the regression model obtained in (6). 19) Conduct a residual analysis to check for violations of the model assumption. Suggest remedies for the violations if any. (10) Discuss the serlousness of multicollinearity in the model obtained in (6). MacBook Air 0 0 K ISI VS VE ZA! BA 1 2 3 101 1.01 1.12 106 1.01 VB 1 1 0 4 1 0 0 5 101 6 7 8 SOM 0 1 1 1 0 1 9 10 lelos 0 1 0 13 1 1 127 1410 109 114 133 1AR 128 1.14 1.08 105 163 158 124 131 120 111 1.21 115 3 1 1 0 O 14 15 16 12 0 0 0 1 0 D 0 1 1 1 1 1 1.27 1 1 0 1 1.01 1.06 1.10 1.09 1.05 107 1.08 1.08 1.02 1.16 1.07 1.08 1.05 1.02 107 1.02 105 1.06 1.11 108 1.12 100 1.00 102 104 1.02 102 1:01 1.10 101 1.04 107 1.06 1.08 110 115 101 1.01 1.22 111 110 1109 1714 1.17 1.28 1:19 1.14 105 1.05 1.19 1.16 124 121 1.20 1.11 121 109 108 113 1.10 1.18 117 1.05 105 1.27 1.02 1.03 1:05 116 1:09 106 113 1.13 108 126 112 1.15 1.15 1.10 1 1 SENARANNARS A V VA 2879 43 138699 2 134.00 85.71 3 202.33 248.89 4 39722 467 49 158.54 117.72 1128.11 100N 93 7 40033 472.98 8 581.64 785.39 9 353 96 37002 10 138.71 174.25 11 383.66 410.95 12 3910.94 3405.94 13 362.92 385 96 14 196.50 235.41 15 637 99 62741 16 152.06 175.40 17 375.00 432.33 2284.56 1499.04 19 S51.45 497.74 20 239.57 194,65 21 207.87 16799 22 540.48 767 80 23 230.54 260.30 24 299.87 24704 25 2368.84 2456.77 26 496 49 879.40 27 1564.87 1303:40 28 238703 6107.93 29 195.68 199.09 30 830.47 715 46 179.06 208.72 150.35 199.09 240.06 629.24 586.81 709 85 537.12 67642 392.69 490:55 216.47 406.47 38 1559.37 192531 39 8831 143.07 40 26845 305.09 41 189.02 26955 42 192.81 227.70 256.22 436.79 44 11361 132.39 43 124.99 121.61 116 57 11421 14:13 172.71 48 36.19 6444 49 251339 312439 50 135351 151752 5 31282 37537 52 202.50 300 32 53 604331 707499 54 22808! 2823.87 1 0 0 1 VIO 03 250 DO 0.75 AS DO 0:50 120.00 0.50 180.00 038 0.00 0.60 200.00 0.60 70.00 050 2000 0.57 75.00 083 70.00 043 60X) 045 350.00 0.88 100.00 0.70 120.00 050 140.00 050 75.00 052 120.00 0.60 270.00 0.60 100.00 0.60 65.00 0.62 50.00 0.40 90.00 0.43 125.00 060 80 DO 0.31 320.00 0.58 140.00 0.33 200.00 0.62 340,00 0.60 50.00 0.52 135.00 0.63 90.00 0.64 100.00 0.71 120.00 0.60 120.00 023 225.00 0.50 180.00 0.52 130.00 0.43 250.00 0.71 55.00 9.67 75.00 0.36 115.00 0.83 60.00 0.88 225.00 0.69 70.00 0.52 40.00 0.52 35.00 0.60 50.00 0.53 6000 0.57 255.00 0,41 200.00 0.62 149.00 0:42 100.00 0:58 350.00 0.53 30:00 0 0 1 1 0 113 1.10 1:49 138 1.05 106 1.27 109 1.61 1-55 1,73 139 1.26 1.65 1:58 1.60 1.50 1.33 1.95 1:45 0 0 ZE EE VE SE SE LE 135 36 0 0 0 0 0 0 1 1 38 39 40 141 42 43 44 25 6 O 0 0 OO g 104 100 1 0 0 101 0 1.61 1.27 1.92 13 0 D Or 101 1.00 1.00 1.09 125 102 1.13 1.00 D 0 0 0 0 D 1 O 113 1.22 1.14 1:32 1.04 1.23 1:05 123 1:03 09 90 51 32 51 34 OST TET IVE VS1 GET 1 0 O 102 1.08 139 log K E 1109 2.30 0 1 189 159 155 189 126 145 Poloplevel HDMI 1.36 1 1 o 145 1.25 aald O HD 55 56 57 58 55 60 61 62 63 64 65 66 62 68 69 70 71 72 73 74 75 76 77 1:36 1:20 O 0 0 0 1 1 123 OOOOOOOO 0 1 D 1DB 117 102 101 1.00 1.06 1.07 102 101 109 1.00 1.00 107 114 1.30 1.20 1.07 101 1.05 100 1.00 1.05 107 1.00 1.29 1.00 1.00 1.15 1.08 101 100 1.00 101 1.05 1.06 103 102 114 107 101 1,05 112 100 102 104 105 105 102 1.71 1.96 147 138 1.36 1.49 1:34 1.22 2.09 1.46 2.39 1.22 1.32 0 0 0 0 5 5422021 282387 SS 99.92 118.99 56 146159 1774.72 57 121757 1841. OB 58 258 44 306 44 59 115AZ 117.94 60 46.93 540.01 61 72886 763.02 62 3929.92 394157 63 18169 194.82 64 479 47 487.17 65 93.48 92.36 66 2301.07 2505.60 67 136.06 181.09 68 144.06 252.92 69 65.17 84.75 70 161.33 164.03 71 1138 54 1254.62 72 84.79 9763 73 749.13 859.34 74 43.67 41.09 75 2920.71 2812.50 76 32.63 40.05 77 1115.12 1148.53 78 50.66 59.86 79 2229.34 2434,60 80 2159.85 2698.59 81 45.91 51.89 82 122.31 13752 83 14781 14334 84 470.71 447.75 85 188.67 20246 86 476517 5035.94 82 168.53 163.67 95.86 95.63 89 106.92 10789 90 698.48 64643 92 296.00 959.69 92 689.73 80151 93 3184 90584 94 215015 216137 95 169.75 18732 96 92358 88737 97 2527 47 26161 98 726 58 79827 99 1187.10 1573.45 100 18 02 149.28 10 147.56 162 23 04:24 11602 58052 575.41 100 445.52 3503 105 1106 120.07 106 4517 0828 107 00:00 103145 100 4954 54131 0 0.53 056 0.52 092 0.70 0.85 0.63 0.23 0.67 0.63 0.53 0.83 0.78 0.33 0.67 0.54 0.80 0.68 0.60 0.93 0.80 0.50 0.70 0.64 057 0.46 0.50 057 0.67 0.60 0.57 0.54 0.52 0.80 080 0.70 0.58 0.64 101 1.02 1.10 1.11 104 1.06 1.16 1.05 103 109 1:23 1:31 1.37 1.10 103 1.10 1.05 1.22 1.12 1.26 1.09 1.63 1.09 1.06 1.52 1.12 116 101 *09 105 108 109 1.07 1.11 1:16 1:15 104 107 1.12 1.00 1.15 1.09 111 1-27 124 79 BO 81 82 83 O 2013 390.00 70.00 220.00 350.00 75.00 65.DO 120,00 200.00 400.00 50.00 140.00 60.00 400.00 100.00 90.00 60.00 100.00 200.00 50.00 180.00 30.00 315.00 35. DO 250.00 50.00 450.00 360.00 60.00 30.00 50.00 150.00 120.00 300.00 30.00 30.00 30.00 180.00 175.00 210.00 190.00 400.00 100.00 130,00 350.00 220.00 230.00 40.00 GOOD 75.00 223.00 150.00 70.00 35.00 425.00 100D DOOHOOOOOOOOOOOOOOOOOOO 0 1 0 o 0 0 86 88 89 90 91 92 1.16 132 1.70 1.27 1.30 1.40 129 165 128 1.27 123 129 119 1:29 14: 12: 136 0 038 0 95 96 97 0 1 1 4 0 0.64 0.53 0.75 088 0.50 0 45 0.50 083 0.67 058 0125 036 0.71 0.75 03 300 103 102 103 104 105 de 107 10 116 1127 154 13 242 10 121 1.13 ODOO 101 133 100 12 120 200 16 19 1.13 143 1024 TOO 1:23 14 0 O For + 0 H 145 1.24 1:39 116 BIG DOO 139 D D 0 1 1 0 0 0 1 105 109 110 111 112 113 114 115 116 117 518 119 120 121 122 123 124 125 126 127 128 129 130 131 132 130 134 135 D 395.98 1.20 1.00 104 101 1.03 103 101 107 100 102 1.08 1.00 1.13 1.05 1.10 121 1.05 1.03 103 1.03 1.02 1.04 1.01 1.13 1.01 1.05 105 105 1.02 1.01 100 1.04 101 103 1.03 1.23 114 1.11 11.06 110 1.09 143 107 102 1.04 108 104 1.16 112 1.20 1.26 1.73 1.05 111 1.06 1.04 1.05 1.13 1.17 1.33 1.18 107 1.08 104 107 113 111 1 30 106 DDODDOOOOOOOOOOOOOOOOOOOOOOOO OOOO 0 1 1 0 107 800,60 1031 AS 108 495 A7 541.81 109 1370.06 137792 110 607 51 809.09 111 152.72 16124 112 728 20 916.97 213 181.59 146.46 114 462.92 50479 115 169.38 144.51 116 2473.26 2618 24 117 2346.77 244781 118 170.42 196.75 119 77.85 109.91 120 4770.88 751133 121 303 34 341 22 122 419.00 123 150.55 174.48 124 1404.08 1573.83 125 1691.66 162708 126 5195.22 6365.13 127 3815.88 4960.82 128 122.62 95.38 129 1571.15 1759.21 130 4385.47 5555.82 131 449756 5186 30 132 23.67 3254 133 1048.86 1040 53 23951 315.11 135 260.54 351.80 13889 12331 137 128.38 15189 138 284.98 315.97 139 27:32 10104 140 5411:51 5086.25 143 3854 60 399103 142 2976.03 2832:43 143 25751 205-86 144 36 44 42104 182.52 223:13 146 136702 1433.62 147 7631 75.25 148 174788 1493.45 149 573442 542731 150 5884.70609741 151 34652 331 10 152 546.40 153 76084 71824 154 169.77 17595 155 138.79 15162 150 315.76 39421 1157 108212 10587 153 253.60 27093 239 43.15 545.26 269 10270.10462.40 161 1300 + 1.18 143 3120 1.02 1.06 1.34 1.07 115 142 1:40 1.26 1.73 1.25 1.12 1.30 1.07 1.07 127 1.72 1.52 2.23 1.28 1.18 1.18 107 1:13 111 1.30 130 1.49 1:56 1.06 110 126 135 105 13! 132 122 148 1960 1 1 1 0 0.73 0.83 OSB 0.67 0.75 0.62 0.75 0.50 0.50 0.33 OBO 0.75 050 052 0.78 043 0.50 0.58 0.63 0.43 0.18 0.40 0.63 0.32 0.26 0.78 0.67 0.80 0.80 0.50 0.60 0.50 0.50 0.39 0:41 0:38 0.80 0.75 0.40 0.80 0.25 0.55 0.89 0.39 0.63 0.45 0.50 O 1 1 425.00 140 DO 400 DO 185 DO 155.DO 185.00 135.00 175.00 145.00 630.00 455.00 75.00 80.00 500.00 210.00 185.00 110,00 550.00 500.00 805.00 450.00 120.00 385.00 600.00 750.00 60.00 300.00 100.00 120.00 150.00 75.00 110.00 90.00 815.00 800.00 440.00 130.00 45.00 90.00 475.00 90,00 445.00 70000 900.00 190.00 490,00 185.00 125.00 69.00 150.00 40000 200.00 230.00 120.00 450.00 1 137 138 1 0 1140 141 142 10 1:07 0 117 105 110 1 1 126 0 0 o 1 145 146 147 IE 149 1150 151 ESZ 353 3154 101 1:02 5.00 107 102 101 102 103 1412 129 1.02 1.02 1:03 OOO 0 108 106 1.19 103 103 112 13 105 103 10 1:12 B1854 0 1 1 05 156 557 355 159 1160 0 COOOOO 100 HO 102 200 04 105 108 113 135 134 25 12 123 1:34 115 . 13 0.25 0.38 0.67 050 DO 562 040 091 tag * T 1 olole 1 0 E 10 109 125 121 107 1313 102 D 0 0 164 1 1 0 0 D 131 0 0 1 1 0 1 165 164 165 166 167 168 5169 170 171 172 273 174 175 176 172 178 179 10 181 162 183 184 185 186 0 0 1 1 + OOOOOO D 100 102 144 109 101 103 1.02 1.07 1.04 119 1.06 1.01 1.14 100 1.04 101 105 1.03 1.07 105 1:02 104 1.02 1.04 1.06 116 110 1.04 106 1.00 108 1.01 104 103 1 1 1 1 lo 0 0 1 0 1 104 122 1.22 106 135 1.08 108 109 108 1.06 1.09 107 107 110 1.02 1.06 1.16 1.18 112 105 LOR 1.16 1.09 105 106 1:13 1 0 1 1 1 0 F 103 1.38 131 121 1.33 1.13 110 131 129 122 122 109 137 1.11 1.08 1.09 1.08 1106 118 1.07 107 1:33 1.25 1.06 1.24 1.19 112 107 10B 139 1.09 119 106 1.19 105 1.15 1.18 1.12 1.09 1.02 1.05 118 1.13 1.40 1.18 103 1.09 1.12 119 1.11 107 1.16 1 1 A 162 714018 215201 163 6584.11 5949.35 164 666.72 54152 165 108. OS 99.56 106.10 95.29 167 549.64 413.08 168 127204 949.46 169 12282 13226 170 35945 333 AS 171 1731.47 167253 172 31.72 28.30 173 3299.96 2805 89 124 480.56 480.31 175 673.09 655.81 176 116.99 9994 177 1157.39 891.21 178 165.80 131.99 179 668.53 596 89 180 7622.16 787119 181 20132 182.94 1821270.05 130633 1831055614 1148.65 164 5212 23 5090.86 185 5654.86 5447.59 186 856.46 935.14 88.98 66.06 185 200.00 168.99 189 23404 179.74 190 116.56 125 BS 191 8211 9304 192 20781 21425 193 463.28 474.89 1947385.55 8460.87 195. 91.56 2003: 196 546.16 52292 192 740.30 810 26 198 888.44 383 199 656.75 750.82 1884.39 1550 49 4197.79 202 256-20 181.95 203 1949.63 1880.83 204 23528 230.75 205 35.18 3921 206 244.76 221 88 648.92 563.88 208 39147 35053 209 26778 24951 210 2130.04 2019 27 211 10123 303.19 212 107790 87872 210 92738 90203 214 241.70 243:37 65.79 H236 2:6 1206 44 1210 33 flag 1 1 0A3 0.50 0.56 O.SO 0.86 0.60 056 0.30 9.50 0.35 0.50 044 0.67 083 0.75 0.75 043 0.75 0.38 0743 0.75 0.45 0.56 0.38 0.50 0.50 0.75 0.80 0.75 0.75 0.50 0.89 0.23 0.57 0.38 0.44 0.83 0.44 0.43 0.50 O.RO 0.44 0.83 0.60 0.80 0.60 0.60 0.36 0.71 0.60 0. 0.25 0.75 0.44 400.00 675.00 240.00 55.00 125.00 120.00 450.00 130.00 190,00 400.00 60.00 525 DO 125.00 100.00 100.00 450.00 120.00 120.00 700.00 90.00 195.00 400.00 500.00 500.00 375.00 90.00 90.00 170.00 80.00 100.00 155.00 215.00 505.00 90.00 165.00 275.00 250.00 180.00 350.00 660.00 330.00 330.00 90.00 45.00 90.00 140.00 10000 255.00 450.00 110.00 190.00 400.00 45.00 60.00 295.00 190 191 192 193 0 0 OOOOO 0 0 0 0 195 192 100 HOON 0 0 199 200 1 100 1.02 1.03 1.02 1.00 101 105 1.03 104 107 1.09 102 103 004 . TOZ 1 1 1 1 1 1 1 1 1 1 1.11 102 O 202 203 204 205 205 207 200 209 1 103 101 102 1 207 1 101 0 0 0 0 211 109 1.40 103 101 1.09 107 117 1.11 106 116 117 1.20 23 0 1 0 1.04 1:11 1 OR 104 111 103 119 100 213 214 215 216 212 1 0 1 2 215 1.50 0 0 + 1201 HI 105 1.09 1.03 109 1.12 1.19 1.11 1 1 1 0 1 Ololog 53 SERIES 10 1 0 0 107 1.02 103 104 1.11 1.08 1.04 1.11 105 1.19 1.00 1.02 1.01 HO 12 13 14 15 16 17 18 19 20 21 22 1 1 1 0 0 0 1 o 1 1 OOO Holo 205 2:44.76 WATER 207 648.92 563.88 208 391.47 358.53 209 267.78 249.91 210 213004 2019.87 211 301.23 303.19 212 1077.90 878.72 213 927.38 902.03 214 241.70 243.97 215 65.79 82.36 216 1208.44 1230.33 217 9453 35 9479.73 218 7098.11 8296.80 219 912 06 1137.65 220 259.99 319.59 221 8992 25 10743.60 222 33988 428.82 223 833 66 859.74 224 4833.82 6225.04 225 271.94 223.89 226 2966.28 4433 47 227 577.37 701.07 228 10480 32 10276.29 229 462.39 444.19 230 2558.19 2741.05 231 2814.91 2816.73 232 119.81 122.16 233 3184.86 3373.04 234 473.20 54801 235 400.48 496.68 1.00 1.01 103 OH 1.09 1.07 1.17 1.11 1.06 1.16 1.17 1.20 1.31 1.03 1.04 1.29 1.07 1.05 1.24 1.06 1.07 1.03 1.31 1.26 1.04 1.04 1:16 1.12 107 1.03 113 1.08 W0 0.60 0.60 0.36 0.71 0.60 0.80 0.25 0.75 0.44 0.31 032 0.50 0.33 0.80 0.45 0.38 0.33 0.53 0.67 0.25 0.25 0.69 0.80 0.44 0.55 0.67 0.58 0.38 0.50 1 90.00 140.00 100.00 255.00 450.00 110.00 190.00 400.00 45.00 60.00 295.00 500.00 510.00 220.00 90.00 650.00 165.00 450.00 520.00 110.00 720.00 150.00 570.00 120.00 365.00 540.00 90.00 240.00 130.00 90.00 23 1.16 117 123 1.50 1.14 1.20 1.29 1.07 1.37 124 6.05 1.37 1.11 1.51 1:26 1.30 1.06 1.20 1:25 1:30 1.36 113 1.19 o 1 OOH OH 1.20 1.05 1.00 1.01 1.08 1.00 1.03 1.04 1.14 1.02 1.00 1.00 1:11 1.07 1 1 1 1 OOO OO 1 24 225 326 327 28 229 230 231 232 233 334 235 236 237 236 239 240 241 242 243 244 245 246 247 248 249 259 251 252 253 254 355

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Turning Money Into Wealth

Authors: Arthur J. Keown

6th Edition

0132719169, 978-0132719162

More Books

Students also viewed these Finance questions

Question

What should Belindas and Marcus next steps be?

Answered: 1 week ago