CARS 2 Data file is Below. Not allowed to attached attachments to questions. Do ASAP

HEADERS :

Name

Cmpg

Eng

Vol

2.9 The CARS2 data file contains information for 127 new U.S. front-wheel drive passenger cars for the 2011 model year. These data come from a larger dataset (U.S. Environmental Protection Agency and U.S. Department of Energy, 2011), which is analyzed more fully in a case study in Section 6.2. a. Transform city miles per gallon into city gallons per hundred miles." In other words, create a new variable called Cgphm equal to 100/ Cmpg [computer help #6]. To check that you have done the transformation correctly, confirm that the sample mean of Cgphm is 4.613. b. Consider predicting Cgphm from either engine size in liters (variable Eng) or interior passenger and cargo volume in hundreds of cubic feet (variable Vol). Estimate and compare two alternative simple linear regression models: In the first, Eng is the predictor, while in the second, Vol is the predictor. Write a report about two pages long that compares the two models using three numerical methods for evaluating regression models and one graphical method [computer help #25 and #26]. Which of the two models would you recommend for explaining/predicting Cgphm? c. Report the regression standard error (s) for the model you recommended in part (b) and use this number to say something about the predictive ability of your model. Acura TL 2wd 3.5L Audi A3 24 Audi A4 2L Audi A5 Cabriolet 2L Audi A6 3.2L Buick Lacrosse 2.4L Buick Lacrosse 3.6L Buick Lucerne 4.6L Buick Lucerne FFV 3.9L Buick Regal 2.4L Buick Regal FFV 2L Cadillac DTS 4.6L Chevrolet Aveo 1.6L Chevrolet Aveo 5 1.6L Chevrolet Cruze 1.4L Chevrolet Cruze 1.8L Chevrolet Cruze ECO 1.4L Chevrolet Impala FFV 3.5L Chevrolet Impala FFV 3.9L Chevrolet Malibu 2.4L Chevrolet Malibu 3.6L Chevrolet Malibu FFV 2.4L Chrysler 200 2.4L Chrysler 200 Convertible 2.4L 18 3.5 1.11 22 2.0 1.09 22 2.0 1.03 22 2.0 0.91 21 3.2 1.14 19 2.4 1.16 17 3.6 1.16 15 4.6 1.21 17 3.9 1.21 19 2.4 1.11 18 2.0 1.11 15 4.6 1.32 25 1.6 1.03 25 1.6 0.98 24 1.4 1.10 22 1.8 1.10 26 1.4 1.10 19 3.5 1.24 17 3.9 1.24 22 2.4 1.11 17 3.6 1.11 22 2.4 1.11 21 2.4 1.15 20 2.4 1.01 Chrysler 200 Convertible FFV 3.6L Chrysler 200 FFV 3.6L Dodge Avenger 2.4L Dodge Avenger FFV 3.6L Dodge Caliber 2.4L Dodge Caliber 2L Ford Fiesta Fwd 1.6L Ford Fiesta SFE Fwd 1.6L Ford Focus Fwd 2L Ford Fusion Fwd 2.5L Ford Fusion Fwd 3.5L Ford Fusion Fwd FFV 3L Ford Taurus Fwd 3.5L Honda Accord 2DR Coupe 2.4L Honda Accord 2DR Coupe 3.5L Honda Accord 4DR Sedan 2.4L Honda Accord 4DR Sedan 3.5L Honda Civic 1.8L Hyundai Accent 1.6L Hyundai Azera 3.3L Hyundai Azera 3.8L Hyundai Elantra 1.8L Hyundai Elantra Touring 2L Hyundai Sonata 2.4L 19 3.6 1.01 19 3.6 1.15 21 2.4 1.14 19 3.6 1.14 22 2.4 1.12 23 2.0 1.12 29 1.6 0.97 29 1.6 0.97 25 2.0 1.07 23 2.5 1.16 18 3.5 1.16 20 3.0 1.17 18 3.5 1.22 22 2.4 1.04 19 3.5 1.04 23 2.4 1.21 20 3.5 1.21 25 1.8 0.96 27 1.6 1.04 20 3.3 1.24 19 3.8 1.24 29 1.8 1.11 23 2.0 1.29 22 2.4 1.20 Hyundai Sonata 2L Kia Forte Koup 2.4L Kia Forte Koup 2L Kia Optima 2.4L Kia Optima 2L Kia Rio 1.6L Kia Rondo 2.4L Kia Rondo 2.7L Kia SOUL 1.6L Kia SOUL 2L Lexus ES 350 3.5L Lincoln-Mercury Milan Fwd 2.5L Lincoln-Mercury Milan Fwd FFV 3L Lincoln-Mercury MKS Fwd 3.5L Lincoln-Mercury MKZ Fwd 3.5L Mazda 2 1.5L Mazda 3 2.5L Mazda 3 2L Mazda 6 2.5L Mazda 6 3.7L Mini Cooper 1.6L Mini Cooper Countryman 1.6L Mini Cooper S 1.6L Mini Cooper S Clubman 1.6L 22 2.0 1.20 23 2.4 1.02 25 2.0 1.02 24 2.4 1.17 22 2.0 1.17 27 1.6 1.04 20 2.4 1.40 18 2.7 1.40 26 1.6 1.26 24 2.0 1.26 19 3.5 1.10 23 2.5 1.16 20 3.0 1.16 17 3.5 1.23 18 3.5 1.15 27 1.5 1.00 22 2.5 1.06 24 2.0 1.06 22 2.5 1.19 18 3.7 1.19 28 1.6 0.82 25 1.6 1.03 26 1.6 0.82 26 1.6 0.97 Mini Cooper S Convertible 1.6L Mini Cooper S Countryman 1.6L Mini Mini Clubman 1.6L Mini Mini Convertible 1.6L Mitsubishi Eclipse 2.4L Mitsubishi Eclipse 3.8L Mitsubishi Eclipse Spyder 2.4L Mitsubishi Eclipse Spyder 3.8L Mitsubishi Galant 2.4L Mitsubishi Lancer 2.4L Mitsubishi Lancer 2L Mitsubishi Lancer Sportback 2L Nissan Altima 2.5L Nissan Altima 3.5L Nissan Altima Coupe 2.5L Nissan Altima Coupe 3.5L Nissan Cube 1.8L Nissan Juke 1.6L Nissan Maxima 3.5L Nissan Sentra 2.5L Nissan Sentra 2L Nissan Versa 1.6L Nissan Versa 1.8L Saab 9-3 Sport Sedan 2L 26 1.6 0.80 25 1.6 1.03 27 1.6 0.97 27 1.6 0.80 20 2.4 0.98 17 3.8 0.98 20 2.4 0.81 16 3.8 0.81 21 2.4 1.14 23 2.4 1.05 25 2.0 1.05 25 2.0 1.09 23 2.5 1.16 20 3.5 1.16 23 2.5 0.97 20 3.5 0.97 27 1.8 1.09 27 1.6 0.96 19 3.5 1.10 24 2.5 1.10 27 2.0 1.10 25 1.6 1.08 24 1.8 1.08 19 2.0 1.05 Scion tc 2.5L Scion xB 2.4L Scion xD 1.8L Suzuki Kizashi 2.4L Suzuki Kizashi S 2.4L Suzuki Swift + 1.6L Suzuki SX4 2L Suzuki SX4 Sedan 2L Suzuki SX4 Sport Anniversary Edition 2L Toyota Avalon 3.5L Toyota Camry 2.5L Toyota Camry 3.5L Toyota Corolla 1.8L Toyota Corolla 2.4L Toyota Corolla Matrix 1.8L Toyota Corolla Matrix 2.4L Toyota Yaris 1.5L Volkswagen CC 2L Volkswagen EOS 2L Volkswagen GOLF 2.5L Volkswagen GTI 2L Volkswagen Jetta 2.5L Volkswagen Jetta 2L Volkswagen Jetta Sportwagen 2.5L 23 2.5 1.05 22 2.4 1.23 27 1.8 0.95 23 2.4 1.05 23 2.4 1.05 25 1.6 0.98 23 2.0 0.98 25 2.0 1.04 23 2.0 1.04 20 3.5 1.21 22 2.5 1.16 20 3.5 1.16 26 1.8 1.04 22 2.4 1.04 25 1.8 1.14 21 2.4 1.14 29 1.5 1.00 22 2.0 1.07 22 2.0 0.88 24 2.5 1.09 24 2.0 1.09 24 2.5 1.10 23 2.0 1.10 24 2.5 1.25 Volvo C30 Fwd 2.5L Volvo C70 Fwd 2.5L Volvo S40 Fwd 2.5L Volvo S80 Fwd 3.2L Volvo V50 Fwd 2.5L Volvo XC60 Fwd 3.2L Volvo XC70 Fwd 3.2L 21 2.5 1.04 19 2.5 0.97 21 2.5 1.05 19 3.2 1.13 21 2.5 1.25 18 3.2 1.33 18 3.2 1.35 2.9 The CARS2 data file contains information for 127 new U.S. front-wheel drive passenger cars for the 2011 model year. These data come from a larger dataset (U.S. Environmental Protection Agency and U.S. Department of Energy, 2011), which is analyzed more fully in a case study in Section 6.2. a. Transform city miles per gallon into city gallons per hundred miles." In other words, create a new variable called Cgphm equal to 100/ Cmpg [computer help #6]. To check that you have done the transformation correctly, confirm that the sample mean of Cgphm is 4.613. b. Consider predicting Cgphm from either engine size in liters (variable Eng) or interior passenger and cargo volume in hundreds of cubic feet (variable Vol). Estimate and compare two alternative simple linear regression models: In the first, Eng is the predictor, while in the second, Vol is the predictor. Write a report about two pages long that compares the two models using three numerical methods for evaluating regression models and one graphical method [computer help #25 and #26]. Which of the two models would you recommend for explaining/predicting Cgphm? c. Report the regression standard error (s) for the model you recommended in part (b) and use this number to say something about the predictive ability of your model. Acura TL 2wd 3.5L Audi A3 24 Audi A4 2L Audi A5 Cabriolet 2L Audi A6 3.2L Buick Lacrosse 2.4L Buick Lacrosse 3.6L Buick Lucerne 4.6L Buick Lucerne FFV 3.9L Buick Regal 2.4L Buick Regal FFV 2L Cadillac DTS 4.6L Chevrolet Aveo 1.6L Chevrolet Aveo 5 1.6L Chevrolet Cruze 1.4L Chevrolet Cruze 1.8L Chevrolet Cruze ECO 1.4L Chevrolet Impala FFV 3.5L Chevrolet Impala FFV 3.9L Chevrolet Malibu 2.4L Chevrolet Malibu 3.6L Chevrolet Malibu FFV 2.4L Chrysler 200 2.4L Chrysler 200 Convertible 2.4L 18 3.5 1.11 22 2.0 1.09 22 2.0 1.03 22 2.0 0.91 21 3.2 1.14 19 2.4 1.16 17 3.6 1.16 15 4.6 1.21 17 3.9 1.21 19 2.4 1.11 18 2.0 1.11 15 4.6 1.32 25 1.6 1.03 25 1.6 0.98 24 1.4 1.10 22 1.8 1.10 26 1.4 1.10 19 3.5 1.24 17 3.9 1.24 22 2.4 1.11 17 3.6 1.11 22 2.4 1.11 21 2.4 1.15 20 2.4 1.01 Chrysler 200 Convertible FFV 3.6L Chrysler 200 FFV 3.6L Dodge Avenger 2.4L Dodge Avenger FFV 3.6L Dodge Caliber 2.4L Dodge Caliber 2L Ford Fiesta Fwd 1.6L Ford Fiesta SFE Fwd 1.6L Ford Focus Fwd 2L Ford Fusion Fwd 2.5L Ford Fusion Fwd 3.5L Ford Fusion Fwd FFV 3L Ford Taurus Fwd 3.5L Honda Accord 2DR Coupe 2.4L Honda Accord 2DR Coupe 3.5L Honda Accord 4DR Sedan 2.4L Honda Accord 4DR Sedan 3.5L Honda Civic 1.8L Hyundai Accent 1.6L Hyundai Azera 3.3L Hyundai Azera 3.8L Hyundai Elantra 1.8L Hyundai Elantra Touring 2L Hyundai Sonata 2.4L 19 3.6 1.01 19 3.6 1.15 21 2.4 1.14 19 3.6 1.14 22 2.4 1.12 23 2.0 1.12 29 1.6 0.97 29 1.6 0.97 25 2.0 1.07 23 2.5 1.16 18 3.5 1.16 20 3.0 1.17 18 3.5 1.22 22 2.4 1.04 19 3.5 1.04 23 2.4 1.21 20 3.5 1.21 25 1.8 0.96 27 1.6 1.04 20 3.3 1.24 19 3.8 1.24 29 1.8 1.11 23 2.0 1.29 22 2.4 1.20 Hyundai Sonata 2L Kia Forte Koup 2.4L Kia Forte Koup 2L Kia Optima 2.4L Kia Optima 2L Kia Rio 1.6L Kia Rondo 2.4L Kia Rondo 2.7L Kia SOUL 1.6L Kia SOUL 2L Lexus ES 350 3.5L Lincoln-Mercury Milan Fwd 2.5L Lincoln-Mercury Milan Fwd FFV 3L Lincoln-Mercury MKS Fwd 3.5L Lincoln-Mercury MKZ Fwd 3.5L Mazda 2 1.5L Mazda 3 2.5L Mazda 3 2L Mazda 6 2.5L Mazda 6 3.7L Mini Cooper 1.6L Mini Cooper Countryman 1.6L Mini Cooper S 1.6L Mini Cooper S Clubman 1.6L 22 2.0 1.20 23 2.4 1.02 25 2.0 1.02 24 2.4 1.17 22 2.0 1.17 27 1.6 1.04 20 2.4 1.40 18 2.7 1.40 26 1.6 1.26 24 2.0 1.26 19 3.5 1.10 23 2.5 1.16 20 3.0 1.16 17 3.5 1.23 18 3.5 1.15 27 1.5 1.00 22 2.5 1.06 24 2.0 1.06 22 2.5 1.19 18 3.7 1.19 28 1.6 0.82 25 1.6 1.03 26 1.6 0.82 26 1.6 0.97 Mini Cooper S Convertible 1.6L Mini Cooper S Countryman 1.6L Mini Mini Clubman 1.6L Mini Mini Convertible 1.6L Mitsubishi Eclipse 2.4L Mitsubishi Eclipse 3.8L Mitsubishi Eclipse Spyder 2.4L Mitsubishi Eclipse Spyder 3.8L Mitsubishi Galant 2.4L Mitsubishi Lancer 2.4L Mitsubishi Lancer 2L Mitsubishi Lancer Sportback 2L Nissan Altima 2.5L Nissan Altima 3.5L Nissan Altima Coupe 2.5L Nissan Altima Coupe 3.5L Nissan Cube 1.8L Nissan Juke 1.6L Nissan Maxima 3.5L Nissan Sentra 2.5L Nissan Sentra 2L Nissan Versa 1.6L Nissan Versa 1.8L Saab 9-3 Sport Sedan 2L 26 1.6 0.80 25 1.6 1.03 27 1.6 0.97 27 1.6 0.80 20 2.4 0.98 17 3.8 0.98 20 2.4 0.81 16 3.8 0.81 21 2.4 1.14 23 2.4 1.05 25 2.0 1.05 25 2.0 1.09 23 2.5 1.16 20 3.5 1.16 23 2.5 0.97 20 3.5 0.97 27 1.8 1.09 27 1.6 0.96 19 3.5 1.10 24 2.5 1.10 27 2.0 1.10 25 1.6 1.08 24 1.8 1.08 19 2.0 1.05 Scion tc 2.5L Scion xB 2.4L Scion xD 1.8L Suzuki Kizashi 2.4L Suzuki Kizashi S 2.4L Suzuki Swift + 1.6L Suzuki SX4 2L Suzuki SX4 Sedan 2L Suzuki SX4 Sport Anniversary Edition 2L Toyota Avalon 3.5L Toyota Camry 2.5L Toyota Camry 3.5L Toyota Corolla 1.8L Toyota Corolla 2.4L Toyota Corolla Matrix 1.8L Toyota Corolla Matrix 2.4L Toyota Yaris 1.5L Volkswagen CC 2L Volkswagen EOS 2L Volkswagen GOLF 2.5L Volkswagen GTI 2L Volkswagen Jetta 2.5L Volkswagen Jetta 2L Volkswagen Jetta Sportwagen 2.5L 23 2.5 1.05 22 2.4 1.23 27 1.8 0.95 23 2.4 1.05 23 2.4 1.05 25 1.6 0.98 23 2.0 0.98 25 2.0 1.04 23 2.0 1.04 20 3.5 1.21 22 2.5 1.16 20 3.5 1.16 26 1.8 1.04 22 2.4 1.04 25 1.8 1.14 21 2.4 1.14 29 1.5 1.00 22 2.0 1.07 22 2.0 0.88 24 2.5 1.09 24 2.0 1.09 24 2.5 1.10 23 2.0 1.10 24 2.5 1.25 Volvo C30 Fwd 2.5L Volvo C70 Fwd 2.5L Volvo S40 Fwd 2.5L Volvo S80 Fwd 3.2L Volvo V50 Fwd 2.5L Volvo XC60 Fwd 3.2L Volvo XC70 Fwd 3.2L 21 2.5 1.04 19 2.5 0.97 21 2.5 1.05 19 3.2 1.13 21 2.5 1.25 18 3.2 1.33 18 3.2 1.35