Automotive manufacturers need a more in-depth analysis that involves fuel consumption statistics from some of the models sold in the US. Their Research and Development departments need to know the relationship between engine sizes, CO2 emissions, and miles per gallon on city and highway. This analysis will contribute to the decision to reduce engine sizes and include electric-assisted systems in the powertrain or maintain current engine configurations for a certain number of years. Answer the following questions. Include any plots/graphs to support your answers. 

1. Is there a strong or weak relationship between engine size and CO2 emissions? Explain.

 2. What can the measurement of this response tell about the relationship in Question#1? 

3. Does the engine size and MPG have a linear relationship? If not, can it be transformed into a linear relationship? Explain. 

4. What can the measurement of the response tell about the relationship in Question#3? 

5. Calculate assumed combined miles per gallon [(MPGcity + MPGhighway)/2]. With combined miles per gallon, what is the prediction for an MPGCombined given the engine size? 6. Based on the results of your analysis: a. Do you recommend including electric-assisted systems as part of the powertrain for the new generations of the models listed below? 

b. Is the data provided enough to make solid conclusions for this analysis? Explain.

Transcribed Image Text:

Year 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Make FORD BUICK TOYOTA HYUNDAI ALFA ROMEO BMW ACURA FORD CHEVROLET PORSCHE INFINITI LEXUS INFINITI CADILLAC PORSCHE GMC BMW TOYOTA 4C COUPE 230i COUPE TLX A-SPEC F-150 COLORADO PANAMERA 4S Q50 AWD RED SPORT LS 500 AWD QX60 AWD XTS 911 TURBO MERCEDES-BENZ AMG C 63 SIERRA FFV ALPINA B6 XDRIVE GRAN COUPI COMPACT TUNDRA 4WD GLE 550 4MATIC DB11 V12 SUBURBAN MERCEDES-BENZ ASTON MARTIN CHEVROLET INFINITI DODGE ASTON MARTIN CHEVROLET Model ECOSPORT ENCORE YARIS HATCHBACK TUCSON AWD JEEP BMW Class SUV-SMALL SUV - SMALL COMPACT SUV-SMALL TWO-SEATER SUBCOMPACT QX80 4WD CHALLENGER RAPIDE S SILVERADO 4WD GRAND CHEROKEE 4X4 SRT M760i XDRIVE EngineSize Cylinders Transmissior FuelType FuelConsCity FuelConsHwy FuelConsComb MPG CO2 MPGCity MPGHwy 34 195 1 1.4 1.5 1.6 1.8 2 COMPACT 2.4 PICKUP TRUCK - STANDAR 2.7 2.8 PICKUP TRUCK - SMALL FULL-SIZE 2.9 MID-SIZE 3 MID-SIZE SUV-SMALL 3.4 3.5 3.6 FULL-SIZE MINICOMPACT COMPACT 3.8 4 PICKUP TRUCK - STANDAR 4.3 4.4 4.7 5.2 PICKUP TRUCK - STANDAR 4.6 SUV-STANDARD MINICOMPACT SUV-STANDARD SUV - STANDARD MID-SIZE SUBCOMPACT 5.3 5.6 5.7 6 PICKUP TRUCK - STANDAR 6.2 SUV-STANDARD 6.4 FULL-SIZE 6.6 3 4 4 4 4 4 4 6 4 6 6 6 6 6 6 8 6 8 8 8 12 8 8 8 12 8 8 12 AS6 AS6 A4 AM7 AM6 AS8 AM8 AS10 A6 AM8 AS7 AS10 AV7 AS6 AM7 A7 A6 AS8 AS6 A9 A8 A6 AS7 M6 A8 A8 A8 AS8 X X X X Z Z Z X D Z Z Z Z X Z Z X Z X Z Z X Z Z Z NNN 8.6 9.3 7.9 9.9 9.7 9.8 10.2 11.9 10.8 11.3 12.5 13.0 12.5 13.2 12.6 13.4 13.4 14.7 16.8 15.2 15.5 15.1 17.4 15.6 16.7 16.0 18.3 17.7 8.1 7.2 6.8 8.5 6.9 6.8 7.4 9.0 8.0 8.5 9.3 8.7 9.0 8.5 9.9 9.6 10.0 9.6 13.1 11.4 11.4 10.4 12.2 10.1 10.9 11.7 12.6 11.9 8.4 8.3 7.4 9.3 8.4 8.4 8.9 10.6 9.6 10.1 11.1 11.0 10.9 11.1 11.4 11.7 11.8 12.4 14.9 13.5 13.7 13.0 15.1 13.1 22 307 14.1 20 332 14.1 20 331 15.7 18 368 15.1 19 355 34 194 38 173 30 221 34 197 34 197 32 209 27 249 29 257 28 235 25 260 26 259 26 257 25 260 25 266 24 274 24 278 23 292 19 354 21 317 21 322 22 305 19 354 33 30 36 28 29 29 28 24 26 25 23 22 23 21 22 21 21 19 17 19 18 19 16 18 17 18 15 16 35 39 41 33 41 41 38 31 35 33 30 32 31 33 28 29 28 29 22 25 25 27 23 28 26 24 22 24 Year 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Make FORD BUICK TOYOTA HYUNDAI ALFA ROMEO BMW ACURA FORD CHEVROLET PORSCHE INFINITI LEXUS INFINITI CADILLAC PORSCHE GMC BMW TOYOTA 4C COUPE 230i COUPE TLX A-SPEC F-150 COLORADO PANAMERA 4S Q50 AWD RED SPORT LS 500 AWD QX60 AWD XTS 911 TURBO MERCEDES-BENZ AMG C 63 SIERRA FFV ALPINA B6 XDRIVE GRAN COUPI COMPACT TUNDRA 4WD GLE 550 4MATIC DB11 V12 SUBURBAN MERCEDES-BENZ ASTON MARTIN CHEVROLET INFINITI DODGE ASTON MARTIN CHEVROLET Model ECOSPORT ENCORE YARIS HATCHBACK TUCSON AWD JEEP BMW Class SUV-SMALL SUV - SMALL COMPACT SUV-SMALL TWO-SEATER SUBCOMPACT QX80 4WD CHALLENGER RAPIDE S SILVERADO 4WD GRAND CHEROKEE 4X4 SRT M760i XDRIVE EngineSize Cylinders Transmissior FuelType FuelConsCity FuelConsHwy FuelConsComb MPG CO2 MPGCity MPGHwy 34 195 1 1.4 1.5 1.6 1.8 2 COMPACT 2.4 PICKUP TRUCK - STANDAR 2.7 2.8 PICKUP TRUCK - SMALL FULL-SIZE 2.9 MID-SIZE 3 MID-SIZE SUV-SMALL 3.4 3.5 3.6 FULL-SIZE MINICOMPACT COMPACT 3.8 4 PICKUP TRUCK - STANDAR 4.3 4.4 4.7 5.2 PICKUP TRUCK - STANDAR 4.6 SUV-STANDARD MINICOMPACT SUV-STANDARD SUV - STANDARD MID-SIZE SUBCOMPACT 5.3 5.6 5.7 6 PICKUP TRUCK - STANDAR 6.2 SUV-STANDARD 6.4 FULL-SIZE 6.6 3 4 4 4 4 4 4 6 4 6 6 6 6 6 6 8 6 8 8 8 12 8 8 8 12 8 8 12 AS6 AS6 A4 AM7 AM6 AS8 AM8 AS10 A6 AM8 AS7 AS10 AV7 AS6 AM7 A7 A6 AS8 AS6 A9 A8 A6 AS7 M6 A8 A8 A8 AS8 X X X X Z Z Z X D Z Z Z Z X Z Z X Z X Z Z X Z Z Z NNN 8.6 9.3 7.9 9.9 9.7 9.8 10.2 11.9 10.8 11.3 12.5 13.0 12.5 13.2 12.6 13.4 13.4 14.7 16.8 15.2 15.5 15.1 17.4 15.6 16.7 16.0 18.3 17.7 8.1 7.2 6.8 8.5 6.9 6.8 7.4 9.0 8.0 8.5 9.3 8.7 9.0 8.5 9.9 9.6 10.0 9.6 13.1 11.4 11.4 10.4 12.2 10.1 10.9 11.7 12.6 11.9 8.4 8.3 7.4 9.3 8.4 8.4 8.9 10.6 9.6 10.1 11.1 11.0 10.9 11.1 11.4 11.7 11.8 12.4 14.9 13.5 13.7 13.0 15.1 13.1 22 307 14.1 20 332 14.1 20 331 15.7 18 368 15.1 19 355 34 194 38 173 30 221 34 197 34 197 32 209 27 249 29 257 28 235 25 260 26 259 26 257 25 260 25 266 24 274 24 278 23 292 19 354 21 317 21 322 22 305 19 354 33 30 36 28 29 29 28 24 26 25 23 22 23 21 22 21 21 19 17 19 18 19 16 18 17 18 15 16 35 39 41 33 41 41 38 31 35 33 30 32 31 33 28 29 28 29 22 25 25 27 23 28 26 24 22 24

Answer rating: 100% (QA)

1 Better gasoline combustion is achieved when the percentages and concentrations of oxygen 02 carbon ... View the full answer