B C D E F G H K L M N mpg disp hp drat wt X1 X2 X3 X4 3 Mazda RX4 21 160 110 3.9 2.62 Step 1 Mazda RX4 Wag 21 160 110 3.9 2.875 X1 X2 X3 X4 5 Datsun 710 22.8 108 93 3.85 2.32 VIF B.2 2.89 2.28 5.1 6 Hornet 4 Drive 21.4 258 110 3.08 3.215 Hornet Sportabout 18.7 360 175 3.15 3.44 Decision: Since VIF1 is the largest and is more than 5, we delete X1. 8 Valiant 18.1 225 105 2.76 3.46 9 Duster 360 14.3 360 245 3.21 3.57 Step 2 X2 X3 X4 10 Merc 240D 24.4 146.7 62 3.69 3.19 VIF 11 Merc 230 22.8 140.8 95 3.92 3.15 12 Merc 280 19.2 167.6 123 3.92 3.44 Decsion: 13 Merc 280C 17.8 167.6 123 3.92 3.44 14 Merc 450SE 16.4 275.8 180 3.07 4.07 15 Merc 450SL 17.3 275.8 180 3.07 3.73 Instructions: 16 Merc 450SLC 15.2 275.8 180 3.07 3.78 (1) keep the corresponding regression results into other worksheets 17 Cadillac Fleetwood 10.4 472 205 2.93 5.25 like what we did in the class. 18 Lincoln Continental 10.4 460 215 3 5.424 (2) fill VIF values into the above table. (3) make a decision, i.e., delete which variable, or not? 19 Chrysler Imperial 14.7 440 230 3.23 5.345 20 Fiat 128 32.4 78.7 66 4.08 2.2 21 Honda Civic 30.4 75.7 52 4.93 1.615 22 Toyota Corolla 33.9 71.1 65 4.22 1.835 23 Toyota Corona 21.5 120.1 97 3.7 2.465 24 Dodge Challenger 15.5 318 150 2.76 3.52 25 AMC Javelin 15.2 304 150 3.15 3.435 26 Camaro Z28 13.3 350 245 3.73 3.84 27 Pontiac Firebird 19.2 400 175 3.08 3.845 28 Fiat X1-9 27.3 79 66 4.08 1.935 29 Porsche 914-2 26 120.3 91 4.43 2.14 30 Lotus Europa 30.4 95.1 113 3.77 1.513 31 Ford Pantera L 15.8 351 264 4.22 3.17 32 Ferrari Dino 19.7 145 175 3.62 2.77 33 Maserati Bora 15 301 335 3.54 3.57 34 Volvo 142E 21.4 121 109 4.11 2.78 35 36 37 38We tried to select variables by calculating VIF for each variable for dataset mtcars - VIF.xIsx . Finish the calculation in the Excel file. (Answer this question by uploading the Excel file.)