Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Question 1. Fuel Economy for Midsize Cars. The Department of Energy provides fue

ID: 3205591 • Letter: Q

Question

Question 1. Fuel Economy for Midsize Cars. The Department of Energy provides fuel economy ratings for all cars and light trucks sold in the United States. The Minitab Express file for this problem contains the estimated miles per gallon for highway driving for the 205 cars classified as midsize in 2014. Use this data set to test the claim that manual transmission vehicles get better highway mileage at the 10% significance level.

Model Cyl L Transmission City Combination Highway Gas/Diesel 2014 Bentley Flying Spur 12 6 Automatic 9 11 15 E85 2014 Bentley Mulsanne 8 6.8 Automatic 11 13 18 Premium Gas 2014 Ferrari FF 12 6.3 Automatic 11 13 16 Premium Gas 2014 Bentley Flying Spur 12 6 Automatic 12 15 20 Premium Gas 2014 Buick LaCrosse AWD 6 3.6 Automatic 12 14 18 E85 2014 Cadillac CTS 8 6.2 Automatic 12 14 18 Premium Gas 2014 Jaguar XF FFV 6 3 Automatic 13 15 19 E85 2014 Rolls-Royce Wraith 12 6.6 Automatic 13 15 21 Premium Gas 2014 BMW M5 8 4.4 Automatic 14 16 20 Premium Gas 2014 Buick LaCrosse 6 3.6 Automatic 14 16 20 E85 2014 Cadillac CTS 8 6.2 Manual 14 16 19 Premium Gas 2014 Cadillac CTS V 8 6.2 Manual 14 16 19 Premium Gas 2014 Cadillac CTS V 8 6.2 Manual 14 16 19 Premium Gas 2014 Chrysler 200   6 3.6 Automatic 14 16 21 E85 2014 Dodge Avenger 6 3.6 Automatic 14 16 24 E85 2014 Dodge Challenger SRT8 8 6.4 Automatic 14 17 23 Premium Gas 2014 Dodge Challenger SRT8 8 6.4 Manual 14 17 23 Premium Gas 2014 Audi S8 8 4 Automatic 15 19 26 Premium Gas 2014 BMW M5 8 4.4 Manual 15 17 22 Premium Gas 2014 Dodge Challenger 8 5.7 Automatic 15 18 25 Midgrade Gas 2014 Dodge Challenger 8 5.7 Manual 15 18 23 Premium Gas 2014 Jaguar XF 8 5 Automatic 15 18 23 Premium Gas 2014 Jaguar XF FFV 8 5 Automatic 15 18 23 Premium Gas 2014 Jaguar XF FFV 8 5 Automatic 15 18 23 E85 2014 Maserati Ghibli V6 AWD 6 3 Automatic 15 18 25 Premium Gas 2014 Maserati Ghibli 6 3 Automatic 15 19 25 Premium Gas 2014 Mercedes-Benz E350   6 3.5 Automatic 15 18 22 E85 2014 Mercedes-Benz E63 AMG S 4matic 8 5.5 Automatic 15 18 22 Premium Gas 2014 Audi RS 7 8 4 Automatic 16 19 27 Premium Gas 2014 BMW 550i xDrive 8 4.4 Automatic 16 19 24 Premium Gas 2014 Cadillac CTS Sedan 6 3.6 Automatic 16 18 24 Premium Gas 2014 Infiniti Q70 8 5.6 Automatic 16 19 24 Premium Gas 2014 Infiniti Q70 AWD 8 5.6 Automatic 16 18 23 Premium Gas 2014 Jaguar XF AWD 6 3 Automatic 16 19 26 Premium Gas 2014 Lexus LS 460 8 4.6 Automatic 16 19 24 Premium Gas 2014 Lexus LS 460 AWD 8 4.6 Automatic 16 18 23 Premium Gas 2014 Lexus LS 460 L 8 4.6 Automatic 16 19 24 Premium Gas 2014 Lexus LS 460 L AWD 8 4.6 Automatic 16 18 23 Premium Gas 2014 Mercedes-Benz E350 4matic 6 3.5 Automatic 16 18 21 E85 2014 Mercedes-Benz E63 AMG 8 5.5 Automatic 16 19 24 Premium Gas 2014 Mercedes-Benz E63 AMG S 8 5.5 Automatic 16 19 24 Premium Gas 2014 Mercedes-Benz E63 AMG 4matic 8 5.5 Automatic 16 19 23 Premium Gas 2014 Acura TL 4WD 6 3.7 Manual 17 20 25 Premium Gas 2014 Audi A8 8 4 Automatic 17 21 28 Premium Gas 2014 Audi S7 8 4 Automatic 17 20 27 Premium Gas 2014 Audi S6 8 4 Automatic 17 20 27 Premium Gas 2014 BMW 550i 8 4.4 Automatic 17 20 25 Premium Gas 2014 Buick LaCrosse AWD 6 3.6 Automatic 17 20 26 Regular Gas 2014 Dodge Dart 4 2 Automatic 17 19 24 E85 2014 Infiniti Q70 AWD 6 3.7 Automatic 17 20 24 Premium Gas 2014 Jaguar XF FFV 6 3 Automatic 17 21 28 Premium Gas 2014 Acura TL 4WD 6 3.7 Automatic 18 21 26 Premium Gas 2014 Audi A8 6 3 Automatic 18 21 28 Premium Gas 2014 Audi A7 Quattro 6 3 Automatic 18 21 28 Premium Gas 2014 Audi A6 Quattro 6 3 Automatic 18 22 27 Premium Gas 2014 Buick LaCrosse 6 3.6 Automatic 18 21 28 Regular Gas 2014 Cadillac CTS Sedan AWD 6 3.6 Automatic 18 21 26 Regular Gas 2014 Cadillac CTS AWD 6 3.6 Automatic 18 21 26 Regular Gas 2014 Cadillac CTS 6 3.6 Automatic 18 21 27 Regular Gas 2014 Cadillac CTS Sedan   6 3.6 Automatic 18 22 29 Regular Gas 2014 Dodge Challenger 6 3.6 Automatic 18 21 27 Midgrade Gas 2014 Honda Accord 6 3.5 Manual 18 22 28 Regular Gas 2014 Infiniti Q70 6 3.7 Automatic 18 21 26 Premium Gas 2014 Lincoln MKZ AWD 6 3.7 Automatic 18 21 26 Regular Gas 2014 Mercedes-Benz E550 4matic 8 4.7 Automatic 18 21 24 Premium Gas 2014 Subaru Legacy AWD 6 3.6 Automatic 18 20 25 Regular Gas 2014 Volvo S80 AWD 6 3 Automatic 18 21 25 Regular Gas 2014 Buick Regal 4 2.4 Automatic 19 23 31 Regular Gas 2014 Buick Regal AWD 4 2 Automatic 19 22 27 Regular Gas 2014 Cadillac CTS Sedan AWD 4 2 Automatic 19 22 28 Regular Gas 2014 Chrysler 200   6 3.6 Automatic 19 22 29 Regular Gas 2014 Dodge Avenger 6 3.6 Automatic 19 22 29 Regular Gas 2014 Infiniti Q50a AWD 6 3.7 Automatic 19 22 27 Premium Gas 2014 Infiniti Q50 AWD 6 3.7 Automatic 19 22 27 Premium Gas 2014 Jaguar XF 4 2 Automatic 19 23 30 Premium Gas 2014 Lexus GS 350 AWD 6 3.5 Automatic 19 21 26 Premium Gas 2014 Lexus LS 600h L 8 5 Automatic 19 20 23 Premium Gas 2014 Lexus GS 350 AWD 6 3.5 Automatic 19 23 29 Premium Gas 2014 Lincoln MKZ FWD 6 3.7 Automatic 19 22 28 Regular Gas 2014 Nissan Maxima 6 3.5 Automatic 19 22 26 Premium Gas 2014 Acura RLX 6 3.5 Automatic 20 24 31 Premium Gas 2014 Acura TL 2WD 6 3.5 Automatic 20 23 29 Premium Gas 2014 Audi A6 Quattro 4 2 Automatic 20 23 29 Premium Gas 2014 BMW 535i 6 3 Automatic 20 24 30 Premium Gas 2014 BMW 535i 6 3 Manual 20 23 30 Premium Gas 2014 BMW 528i xDrive 6 3 Automatic 20 23 29 Premium Gas 2014 Chrysler 200 6spd 4 2.4 Automatic 20 24 31 Regular Gas 2014 Dodge Avenger 6spd 4 2.4 Automatic 20 24 31 Regular Gas 2014 Infiniti Q50a 6 3.7 Automatic 20 23 30 Premium Gas 2014 Infiniti Q50 6 3.7 Automatic 20 23 29 Premium Gas 2014 Kia Optima 4 2 Automatic 20 24 31 Regular Gas 2014 Mercedes-Benz E350 4matic 6 3.5 Automatic 20 22 27 Premium Gas 2014 Mercedes-Benz E350   6 3.5 Automatic 20 24 30 Premium Gas 2014 Mercedes-Benz E350 4matic 6 3.5 Automatic 20 23 28 Premium Gas 2014 Volkswagen Passat 6 3.6 Automatic 20 23 28 Premium Gas 2014 Volvo S80 AWD 6 3.2 Automatic 20 23 29 Regular Gas 2014 Buick Regal   4 2 Automatic 21 24 30 Regular Gas 2014 Chevrolet Malibu 4 2 Automatic 21 24 30 Regular Gas 2014 Chrysler 200 4spd 4 2.4 Automatic 21 24 30 Regular Gas 2014 Dodge Avenger 4spd 4 2.4 Automatic 21 24 30 Regular Gas 2014 Honda Accord 6 3.5 Automatic 21 25 32 Regular Gas 2014 Honda Accord 6 3.5 Automatic 21 26 34 Regular Gas 2014 Lexus ES 350 6 3.5 Automatic 21 24 31 Regular Gas 2014 Subaru Legacy AWD 4 2.5 Manual 21 24 29 Regular Gas 2014 Toyota Camry 6 3.5 Automatic 21 25 31 Regular Gas 2014 Toyota Avalon   6 3.5 Automatic 21 24 31 Regular Gas 2014 BMW 528i xDrive 4 2 Automatic 22 26 33 Premium Gas 2014 Chevrolet Cruze 4 1.8 Automatic 22 27 35 Regular Gas 2014 Dodge Dart GT 4 2.4 Automatic 22 26 31 Regular Gas 2014 Dodge Dart 4 2.4 Manual 22 27 35 Regular Gas 2014 Ford Fusion AWD 4 2 Automatic 22 25 31 Regular Gas 2014 Ford Fusion FWD 4 2 Automatic 22 26 33 Regular Gas 2014 Ford Fusion FWD 4 2.5 Automatic 22 26 34 Regular Gas 2014 Lincoln MKZ AWD 4 2 Automatic 22 25 31 Regular Gas 2014 Lincoln MKZ FWD 4 2 Automatic 22 26 33 Regular Gas 2014 Nissan Altima 6 3.5 Automatic 22 25 31 Regular Gas 2014 Volkswagen Passat 5 2.5 Automatic 22 25 31 Regular Gas 2014 Volkswagen Passat 5 2.5 Manual 22 26 32 Regular Gas 2014 BMW 528i 4 2 Automatic 23 27 34 Premium Gas 2014 BMW ActiveHybrid 5 6 3 Automatic 23 26 30 Premium Gas 2014 Dodge Dart 4 2.4 Automatic 23 27 35 Regular Gas 2014 Dodge Dart GT 4 2.4 Manual 23 27 33 Regular Gas 2014 Ford Fusion FWD 4 1.5 Automatic 23 28 36 Regular Gas 2014 Kia Optima 4 2.4 Automatic 23 27 34 Regular Gas 2014 Audi A7 Quattro 6 3 Automatic 24 29 38 Diesel 2014 Audi A6 Quattro 6 3 Automatic 24 29 38 Diesel 2014 Dodge Dart 4 2 Automatic 24 27 34 Regular Gas 2014 Honda Accord 4 2.4 Manual 24 28 34 Regular Gas 2014 Hyundai Elantra GT 4 2 Automatic 24 27 33 Regular Gas 2014 Hyundai Elantra GT 4 2 Manual 24 28 34 Regular Gas 2014 Hyundai Elantra 4 2 Automatic 24 28 35 Regular Gas 2014 Hyundai Elantra 4 2 Manual 24 28 34 Regular Gas 2014 Hyundai Elantra Coupe 4 2 Automatic 24 28 34 Regular Gas 2014 Kia Forte 4 2 Automatic 24 28 36 Regular Gas 2014 Kia Forte 4 2 Manual 24 28 35 Regular Gas 2014 Mercedes-Benz E400 Hybrid 6 3.5 Automatic 24 26 30 Premium Gas 2014 Subaru Legacy AWD 4 2.5 Automatic 24 27 32 Regular Gas 2014 Volkswagen Passat 4 1.8 Manual 24 28 35 Regular Gas 2014 Volkswagen Passat 4 1.8 Automatic 24 28 34 Regular Gas 2014 Audi A6 4 2 Automatic 25 28 33 Premium Gas 2014 Buick Regal eAssist 4 2.4 Automatic 25 29 36 Regular Gas 2014 Buick LaCrosse eAssist 4 2.4 Automatic 25 29 36 Regular Gas 2014 Chevrolet Cruze 4 1.8 Manual 25 29 36 Regular Gas 2014 Chevrolet Malibu eAssist 4 2.4 Automatic 25 29 36 Regular Gas 2014 Chevrolet Sonic 5 4 1.8 Automatic 25 28 35 Regular Gas 2014 Chevrolet Sonic 5 RS 4 1.4 Automatic 25 28 33 Regular Gas 2014 Chevrolet Malibu 4 2.5 Automatic 25 29 36 Regular Gas 2014 Dodge Dart 4 2 Manual 25 29 36 Regular Gas 2014 Ford Fusion FWD 4 1.6 Manual 25 29 37 Regular Gas 2014 Ford Fusion FWD 4 1.5 Automatic 25 29 37 Regular Gas 2014 Kia Forte 4 1.8 Automatic 25 29 36 Regular Gas 2014 Kia Forte 4 1.8 Manual 25 29 37 Regular Gas 2014 Mazda 6 4 2.5 Manual 25 29 37 Regular Gas 2014 Toyota Camry 4 2.5 Automatic 25 28 35 Regular Gas 2014 BMW 535d 6 3 Automatic 26 30 38 Diesel 2014 BMW 535d xDrive 6 3 Automatic 26 30 37 Diesel 2014 Chevrolet Cruze Eco 4 1.4 Automatic 26 31 39 Regular Gas 2014 Chevrolet Cruze 4 1.4 Automatic 26 30 38 Regular Gas 2014 Chevrolet Sonic 5 4 1.8 Manual 26 30 35 Regular Gas 2014 Chevrolet Cruze 4 1.4 Manual 26 30 38 Regular Gas 2014 Honda Accord   4 2.4 Automatic 26 29 34 Regular Gas 2014 Kia Forte Eco 4 2 Automatic 26 29 35 Regular Gas 2014 Mazda 6 4 2.5 Automatic 26 30 38 Regular Gas 2014 Chevrolet Cruze 4 2 Automatic 27 33 46 Diesel 2014 Chevrolet Sonic 5 4 1.4 Automatic 27 31 37 Regular Gas 2014 Chevrolet Sonic 5 RS 4 1.4 Manual 27 30 34 Regular Gas 2014 Dodge Dart 4 1.4 Automatic 27 31 37 Premium Gas 2014 Honda Accord 4 2.4 Automatic 27 30 36 Regular Gas 2014 Hyundai Elantra Limited 4 1.8 Automatic 27 31 37 Regular Gas 2014 Hyundai Elantra 4 1.8 Manual 27 31 37 Regular Gas 2014 Mazda 3 5-Door 4 2.5 Automatic 27 31 37 Regular Gas 2014 Mercedes-Benz E250 Bluetec 4matic 4 2.1 Automatic 27 31 38 Diesel 2014 Nissan Altima 4 2.5 Automatic 27 31 38 Regular Gas 2014 Nissan Sentra 4 1.8 Manual 27 30 36 Regular Gas 2014 Toyota Corolla 4 1.8 Automatic 27 31 36 Regular Gas 2014 Acura RLX Hybrid 6 3.5 Automatic 28 30 32 Premium Gas 2014 Chevrolet Cruze Eco 4 1.4 Manual 28 33 42 Regular Gas 2014 Dodge Dart Aero 4 1.4 Automatic 28 32 40 Premium Gas 2014 Dodge Dart Aero 4 1.4 Manual 28 32 40 Premium Gas 2014 Hyundai Elantra 4 1.8 Automatic 28 32 38 Regular Gas 2014 Mercedes-Benz E250 Bluetec 4 2.1 Automatic 28 33 42 Diesel 2014 Toyota Corolla 4 1.8 Manual 28 31 37 Regular Gas 2014 Infiniti Q70 Hybrid 6 3.5 Automatic 29 31 34 Premium Gas 2014 Lexus GS 450h 6 3.5 Automatic 29 31 34 Premium Gas 2014 Mazda 3 5-Door 4 2 Manual 29 33 40 Regular Gas 2014 Mazda 3 5-Door 4 2 Automatic 30 33 40 Regular Gas 2014 Nissan Sentra 4 1.8 Automatic 30 34 39 Regular Gas 2014 Nissan Sentra FE 4 1.8 Automatic 30 34 40 Regular Gas 2014 Toyota Corolla LE Eco 4 1.8 Automatic 30 35 42 Regular Gas 2014 Volkswagen Passat 4 2 Manual 30 34 40 Diesel 2014 Kia Optima Hybrid EX 4 2.4 Automatic 35 37 39 Regular Gas 2014 Hyundai Sonata Hybrid 4 2.4 Automatic 36 38 40 Regular Gas 2014 Hyundai Sonata Hybrid Limited 4 2.4 Automatic 36 37 40 Regular Gas 2014 Kia Optima Hybrid 4 2.4 Automatic 36 38 40 Regular Gas 2014 Lincoln MKZ Hybrid FWD 4 2 Automatic 38 38 37 Regular Gas 2014 Ford Fusion Energi Plug-in Hybrid 4 2 Automatic 40 38 36 Regular Gas 2014 Ford C-MAX Energi Plug-in Hybrid 4 2 Automatic 40 38 36 Regular Gas 2014 Lexus ES 300h 4 2.5 Automatic 40 40 39 Regular Gas 2014 Toyota Camry Hybrid XLE/SE 4 2.5 Automatic 40 40 38 Regular Gas 2014 Toyota Avalon Hybrid 4 2.5 Automatic 40 40 39 Regular Gas 2014 Toyota Camry Hybrid LE 4 2.5 Automatic 43 41 39 Regular Gas 2014 Ford Fusion Hybrid FWD 4 2 Automatic 44 42 41 Regular Gas 2014 Honda Accord Plug-in Hybrid 4 2 Automatic 47 46 46 Regular Gas 2014 Honda Accord Hybrid 4 2 Automatic 50 47 45 Regular Gas 2014 Toyota Prius 4 1.8 Automatic 51 50 48 Regular Gas 2014 Toyota Prius Plug-in Hybrid 4 1.8 Automatic 51 50 49 Regular Gas

Explanation / Answer

We cannot provide solutions using the paid softwares such as mintab , an open source alternative R shall be used, However , the concepts remain the same

The complete R snippet is as follows

# read the data into R dataframe
data.df<- read.csv("C:\Users\586645\Downloads\Chegg\carfuel.csv",header=TRUE)
str(data.df)


t.test(data.df$Highway~data.df$Transmission,conf.level=0.90)

The result is

   Welch Two Sample t-test

data: data.df$Highway by data.df$Transmission
t = -1.3957, df = 45.009, p-value = 0.1697
alternative hypothesis: true difference in means is not equal to 0
90 percent confidence interval:
-3.854334 0.355648
sample estimates:
mean in group Automatic mean in group Manual
30.70520 32.45455

H0 : There is no difference in the mean highway mileage of 2 transmission types

H`1: The manual transmission casrs give better mileage than the automatic transmission.

As the p value is not less than our alpha =0.1 , hence we fail to reject the null hypothesis and conclude that There is no difference in the mean highway mileage of 2 transmission types

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote