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