Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Is there a significant difference in mean miles/gallon between cars that weigh 2000-2500 pounds and cars that weigh 2501-3000 pounds? Please include Means Descriptive Stats
Is there a significant difference in "mean miles/gallon" between cars that weigh 2000-2500 pounds and cars that weigh 2501-3000 pounds?
Please include Means Descriptive Stats - Discuss Data outliers, include table (mean, std dev, Q1, Q3, fences,etc.; Charts -- frequency distribution, etc; Means Inferential Stats -Hypotheses; Critical Values (Why and how selected?); Test Statistics (requirements, both methods); Test Conclusion (test statistics v. critical values); Interpretation Statement (see textbook format); Confidence Intervals
Manufacturer | Origin | Model | Type | Passengers | Price | Price_Category | CityMPG | CityMPG_Category | HighwayMPG | HighwayMPG_Category | EngineSize | Enginesize_Category | Horsepower | Horsepower_Category | FuelTank | Weight | Weight_Category | Mean Miles Per Gallon |
Mazda | non-US | RX-7 | Sporty | 2 | 32.5 | Expensive | 17 | Poor | 25 | Poor | 1.3 | Small | 255 | >=200 | 20 | 2895 | < 1.5 Ton | 21 |
Chevrolet | US | Corvette | Sporty | 2 | 38 | Expensive | 17 | Poor | 25 | Poor | 5.7 | Large | 300 | >=200 | 20 | 3380 | > 1.5 Ton | 21 |
Hyundai | non-US | Scoupe | Sporty | 4 | 10 | Cheap | 26 | Good | 34 | Good | 1.5 | Small | 92 | <100 | 11.9 | 2285 | < 1.5 Ton | 30 |
Honda | non-US | Prelude | Sporty | 4 | 19.8 | Moderate | 24 | Good | 31 | Good | 2.3 | Medium | 160 | 150 to <200 | 15.9 | 2865 | < 1.5 Ton | 27.5 |
Honda | non-US | Accord | Compact | 4 | 17.5 | Moderate | 24 | Good | 31 | Good | 2.2 | Medium | 140 | 100 to <150 | 17 | 3040 | > 1.5 Ton | 27.5 |
Honda | non-US | Civic | Small | 4 | 12.1 | Cheap | 42 | Good | 46 | Good | 1.5 | Small | 102 | 100 to <150 | 11.9 | 2350 | < 1.5 Ton | 44 |
Geo | non-US | Storm | Sporty | 4 | 12.5 | Cheap | 30 | Good | 36 | Good | 1.6 | Small | 90 | <100 | 12.4 | 2475 | < 1.5 Ton | 33 |
Ford | US | Festiva | Small | 4 | 7.4 | Cheap | 31 | Good | 33 | Good | 1.3 | Small | 63 | <100 | 10 | 1845 | < 1.5 Ton | 32 |
Dodge | US | Stealth | Sporty | 4 | 25.8 | Expensive | 18 | Poor | 24 | Poor | 3 | Large | 300 | >=200 | 19.8 | 3805 | > 1.5 Ton | 21 |
Ford | US | Mustang | Sporty | 4 | 15.9 | Moderate | 22 | Good | 29 | Poor | 2.3 | Medium | 105 | 100 to <150 | 15.4 | 2850 | < 1.5 Ton | 25.5 |
Geo | non-US | Metro | Small | 4 | 8.4 | Cheap | 46 | Good | 50 | Good | 1 | Small | 55 | <100 | 10.6 | 1695 | < 1.5 Ton | 48 |
Ford | US | Probe | Sporty | 4 | 14 | Cheap | 24 | Good | 30 | Good | 2 | Medium | 115 | 100 to <150 | 15.5 | 2710 | < 1.5 Ton | 27 |
Suzuki | non-US | Swift | Small | 4 | 8.6 | Cheap | 39 | Good | 43 | Good | 1.3 | Small | 70 | <100 | 10.6 | 1965 | < 1.5 Ton | 41 |
Subaru | non-US | Justy | Small | 4 | 8.4 | Cheap | 33 | Good | 37 | Good | 1.2 | Small | 73 | <100 | 9.2 | 2045 | < 1.5 Ton | 35 |
Toyota | non-US | Celica | Sporty | 4 | 18.4 | Moderate | 25 | Good | 32 | Good | 2.2 | Medium | 135 | 100 to <150 | 15.9 | 2950 | < 1.5 Ton | 28.5 |
Volkswagen | non-US | Corrado | Sporty | 4 | 23.3 | Expensive | 18 | Poor | 25 | Poor | 2.8 | Medium | 178 | 150 to <200 | 18.5 | 2810 | < 1.5 Ton | 21.5 |
Volkswagen | non-US | Fox | Small | 4 | 9.1 | Cheap | 25 | Good | 33 | Good | 1.8 | Small | 81 | <100 | 12.4 | 2240 | < 1.5 Ton | 29 |
Pontiac | US | Firebird | Sporty | 4 | 17.7 | Moderate | 19 | Poor | 28 | Poor | 3.4 | Large | 160 | 150 to <200 | 15.5 | 3240 | > 1.5 Ton | 23.5 |
Mazda | non-US | 323 | Small | 4 | 8.3 | Cheap | 29 | Good | 37 | Good | 1.6 | Small | 82 | <100 | 13.2 | 2325 | < 1.5 Ton | 33 |
Lexus | non-US | SC300 | Midsize | 4 | 35.2 | Expensive | 18 | Poor | 23 | Poor | 3 | Large | 225 | >=200 | 20.6 | 3515 | > 1.5 Ton | 20.5 |
Mercury | US | Capri | Sporty | 4 | 14.1 | Cheap | 23 | Good | 26 | Poor | 1.6 | Small | 100 | 100 to <150 | 11.1 | 2450 | < 1.5 Ton | 24.5 |
Pontiac | US | LeMans | Small | 4 | 9 | Cheap | 31 | Good | 41 | Good | 1.6 | Small | 74 | <100 | 13.2 | 2350 | < 1.5 Ton | 36 |
Plymouth | US | Laser | Sporty | 4 | 14.4 | Cheap | 23 | Good | 30 | Good | 1.8 | Small | 92 | <100 | 15.9 | 2640 | < 1.5 Ton | 26.5 |
BMW | non-US | 535i | Midsize | 4 | 30 | Expensive | 22 | Good | 30 | Good | 3.5 | Large | 208 | >=200 | 21.1 | 3640 | > 1.5 Ton | 26 |
Chevrolet | US | Camaro | Sporty | 4 | 15.1 | Moderate | 19 | Poor | 28 | Poor | 3.4 | Large | 160 | 150 to <200 | 15.5 | 3240 | > 1.5 Ton | 23.5 |
Nissan | non-US | Sentra | Small | 5 | 11.8 | Cheap | 29 | Good | 33 | Good | 1.6 | Small | 110 | 100 to <150 | 13.2 | 2545 | < 1.5 Ton | 31 |
Nissan | non-US | Altima | Compact | 5 | 15.7 | Moderate | 24 | Good | 30 | Good | 2.4 | Medium | 150 | 150 to <200 | 15.9 | 3050 | > 1.5 Ton | 27 |
Oldsmobile | US | Cutlass_Ci | Midsize | 5 | 16.3 | Moderate | 23 | Good | 31 | Good | 2.2 | Medium | 110 | 100 to <150 | 16.5 | 2890 | < 1.5 Ton | 27 |
Oldsmobile | US | Achieva | Compact | 5 | 13.5 | Cheap | 24 | Good | 31 | Good | 2.3 | Medium | 155 | 150 to <200 | 15.2 | 2910 | < 1.5 Ton | 27.5 |
Nissan | non-US | Maxima | Midsize | 5 | 21.5 | Expensive | 21 | Good | 26 | Poor | 3 | Large | 160 | 150 to <200 | 18.5 | 3200 | > 1.5 Ton | 23.5 |
Mitsubishi | non-US | Diamante | Midsize | 5 | 26.1 | Expensive | 18 | Poor | 24 | Poor | 3 | Large | 202 | >=200 | 19 | 3730 | > 1.5 Ton | 21 |
Mazda | non-US | 626 | Compact | 5 | 16.5 | Moderate | 26 | Good | 34 | Good | 2.5 | Medium | 164 | 150 to <200 | 15.5 | 2970 | < 1.5 Ton | 30 |
Mazda | non-US | Protege | Small | 5 | 11.6 | Cheap | 28 | Good | 36 | Good | 1.8 | Small | 103 | 100 to <150 | 14.5 | 2440 | < 1.5 Ton | 32 |
Cadillac | US | Seville | Midsize | 5 | 40.1 | Expensive | 16 | Poor | 25 | Poor | 4.6 | Large | 295 | >=200 | 20 | 3935 | > 1.5 Ton | 20.5 |
Mercedes-Benz | non-US | 190E | Compact | 5 | 31.9 | Expensive | 20 | Poor | 29 | Poor | 2.3 | Medium | 130 | 100 to <150 | 14.5 | 2920 | < 1.5 Ton | 24.5 |
Mitsubishi | non-US | Mirage | Small | 5 | 10.3 | Cheap | 29 | Good | 33 | Good | 1.5 | Small | 92 | <100 | 13.2 | 2295 | < 1.5 Ton | 31 |
Mercury | US | Cougar | Midsize | 5 | 14.9 | Cheap | 19 | Poor | 26 | Poor | 3.8 | Large | 140 | 100 to <150 | 18 | 3610 | > 1.5 Ton | 22.5 |
Buick | US | Riviera | Midsize | 5 | 26.3 | Expensive | 19 | Poor | 27 | Poor | 3.8 | Large | 170 | 150 to <200 | 18.8 | 3495 | > 1.5 Ton | 23 |
Acura | non-US | Legend | Midsize | 5 | 33.9 | Expensive | 18 | Poor | 25 | Poor | 3.2 | Large | 200 | >=200 | 18 | 3560 | > 1.5 Ton | 21.5 |
Toyota | non-US | Camry | Midsize | 5 | 18.2 | Moderate | 22 | Good | 29 | Poor | 2.2 | Medium | 130 | 100 to <150 | 18.5 | 3030 | > 1.5 Ton | 25.5 |
Audi | non-US | 90 | Compact | 5 | 29.1 | Expensive | 20 | Poor | 26 | Poor | 2.8 | Medium | 172 | 150 to <200 | 16.9 | 3375 | > 1.5 Ton | 23 |
Volkswagen | non-US | Passat | Compact | 5 | 20 | Expensive | 21 | Good | 30 | Good | 2 | Medium | 134 | 100 to <150 | 18.5 | 2985 | < 1.5 Ton | 25.5 |
Volvo | non-US | 850 | Midsize | 5 | 26.7 | Expensive | 20 | Poor | 28 | Poor | 2.4 | Medium | 168 | 150 to <200 | 19.3 | 3245 | > 1.5 Ton | 24 |
Volvo | non-US | 240 | Compact | 5 | 22.7 | Expensive | 21 | Good | 28 | Poor | 2.3 | Medium | 114 | 100 to <150 | 15.8 | 2985 | < 1.5 Ton | 24.5 |
Acura | non-US | Integra | Small | 5 | 15.9 | Moderate | 25 | Good | 31 | Good | 1.8 | Small | 140 | 100 to <150 | 13.2 | 2705 | < 1.5 Ton | 28 |
Saab | non-US | 900 | Compact | 5 | 28.7 | Expensive | 20 | Poor | 26 | Poor | 2.1 | Medium | 140 | 100 to <150 | 18 | 2775 | < 1.5 Ton | 23 |
Pontiac | US | Grand_Prix | Midsize | 5 | 18.5 | Moderate | 19 | Poor | 27 | Poor | 3.4 | Large | 200 | >=200 | 16.5 | 3450 | > 1.5 Ton | 23 |
Pontiac | US | Sunbird | Compact | 5 | 11.1 | Cheap | 23 | Good | 31 | Good | 2 | Medium | 110 | 100 to <150 | 15.2 | 2575 | < 1.5 Ton | 27 |
Saturn | US | SL | Small | 5 | 11.1 | Cheap | 28 | Good | 38 | Good | 1.9 | Small | 85 | <100 | 12.8 | 2495 | < 1.5 Ton | 33 |
Toyota | non-US | Tercel | Small | 5 | 9.8 | Cheap | 32 | Good | 37 | Good | 1.5 | Small | 82 | <100 | 11.9 | 2055 | < 1.5 Ton | 34.5 |
Subaru | non-US | Legacy | Compact | 5 | 19.5 | Moderate | 23 | Good | 30 | Good | 2.2 | Medium | 130 | 100 to <150 | 15.9 | 3085 | > 1.5 Ton | 26.5 |
Subaru | non-US | Loyale | Small | 5 | 10.9 | Cheap | 25 | Good | 30 | Good | 1.8 | Small | 90 | <100 | 15.9 | 2490 | < 1.5 Ton | 27.5 |
Hyundai | non-US | Excel | Small | 5 | 8 | Cheap | 29 | Good | 33 | Good | 1.5 | Small | 81 | <100 | 11.9 | 2345 | < 1.5 Ton | 31 |
Hyundai | non-US | Elantra | Small | 5 | 10 | Cheap | 22 | Good | 29 | Poor | 1.8 | Small | 124 | 100 to <150 | 13.7 | 2620 | < 1.5 Ton | 25.5 |
Chevrolet | US | Corsica | Compact | 5 | 11.4 | Cheap | 25 | Good | 34 | Good | 2.2 | Medium | 110 | 100 to <150 | 15.6 | 2785 | < 1.5 Ton | 29.5 |
Eagle | US | Summit | Small | 5 | 12.2 | Cheap | 29 | Good | 33 | Good | 1.5 | Small | 92 | <100 | 13.2 | 2295 | < 1.5 Ton | 31 |
Ford | US | Taurus | Midsize | 5 | 20.2 | Expensive | 21 | Good | 30 | Good | 3 | Large | 140 | 100 to <150 | 16 | 3325 | > 1.5 Ton | 25.5 |
Ford | US | Tempo | Compact | 5 | 11.3 | Cheap | 22 | Good | 27 | Poor | 2.3 | Medium | 96 | <100 | 15.9 | 2690 | < 1.5 Ton | 24.5 |
Ford | US | Escort | Small | 5 | 10.1 | Cheap | 23 | Good | 30 | Good | 1.8 | Small | 127 | 100 to <150 | 13.2 | 2530 | < 1.5 Ton | 26.5 |
Hyundai | non-US | Sonata | Midsize | 5 | 13.9 | Cheap | 20 | Poor | 27 | Poor | 2 | Medium | 128 | 100 to <150 | 17.2 | 2885 | < 1.5 Ton | 23.5 |
Dodge | US | Shadow | Small | 5 | 11.3 | Cheap | 23 | Good | 29 | Poor | 2.2 | Medium | 93 | <100 | 14 | 2670 | < 1.5 Ton | 26 |
Chevrolet | US | Cavalier | Compact | 5 | 13.4 | Cheap | 25 | Good | 36 | Good | 2.2 | Medium | 110 | 100 to <150 | 15.2 | 2490 | < 1.5 Ton | 30.5 |
Dodge | US | Colt | Small | 5 | 9.2 | Cheap | 29 | Good | 33 | Good | 1.5 | Small | 92 | <100 | 13.2 | 2270 | < 1.5 Ton | 31 |
Infiniti | non-US | Q45 | Midsize | 5 | 47.9 | Expensive | 17 | Poor | 22 | Poor | 4.5 | Large | 278 | >=200 | 22.5 | 4000 | > 1.5 Ton | 19.5 |
Lexus | non-US | ES300 | Midsize | 5 | 28 | Expensive | 18 | Poor | 24 | Poor | 3 | Large | 185 | 150 to <200 | 18.5 | 3510 | > 1.5 Ton | 21 |
Chrysler | US | LeBaron | Compact | 6 | 15.8 | Moderate | 23 | Good | 28 | Poor | 3 | Large | 141 | 100 to <150 | 16 | 3085 | > 1.5 Ton | 25.5 |
Pontiac | US | Bonneville | Large | 6 | 24.4 | Expensive | 19 | Poor | 28 | Poor | 3.8 | Large | 170 | 150 to <200 | 18 | 3495 | > 1.5 Ton | 23.5 |
Chrylser | US | Concorde | Large | 6 | 18.4 | Moderate | 20 | Poor | 28 | Poor | 3.3 | Large | 153 | 150 to <200 | 18 | 3515 | > 1.5 Ton | 24 |
Dodge | US | Spirit | Compact | 6 | 13.3 | Cheap | 22 | Good | 27 | Poor | 2.5 | Medium | 100 | 100 to <150 | 16 | 2970 | < 1.5 Ton | 24.5 |
Eagle | US | Vision | Large | 6 | 19.3 | Moderate | 20 | Poor | 28 | Poor | 3.5 | Large | 214 | >=200 | 18 | 3490 | > 1.5 Ton | 24 |
Dodge | US | Dynasty | Midsize | 6 | 15.6 | Moderate | 21 | Good | 27 | Poor | 2.5 | Medium | 100 | 100 to <150 | 16 | 3080 | > 1.5 Ton | 24 |
Audi | non-US | 100 | Midsize | 6 | 37.7 | Expensive | 19 | Poor | 26 | Poor | 2.8 | Medium | 172 | 150 to <200 | 21.1 | 3405 | > 1.5 Ton | 22.5 |
Chrysler | US | Imperial | Large | 6 | 29.5 | Expensive | 20 | Poor | 26 | Poor | 3.3 | Large | 147 | 100 to <150 | 16 | 3570 | > 1.5 Ton | 23 |
Buick | US | Century | Midsize | 6 | 15.7 | Moderate | 22 | Good | 31 | Good | 2.2 | Medium | 110 | 100 to <150 | 16.4 | 2880 | < 1.5 Ton | 26.5 |
Chevrolet | US | Caprice | Large | 6 | 18.8 | Moderate | 17 | Poor | 26 | Poor | 5 | Large | 170 | 150 to <200 | 23 | 3910 | > 1.5 Ton | 21.5 |
Lincoln | US | Continenta | Midsize | 6 | 34.3 | Expensive | 17 | Poor | 26 | Poor | 3.8 | Large | 160 | 150 to <200 | 18.4 | 3695 | > 1.5 Ton | 21.5 |
Cadillac | US | DeVille | Large | 6 | 34.7 | Expensive | 16 | Poor | 25 | Poor | 4.9 | Large | 200 | >=200 | 18 | 3620 | > 1.5 Ton | 20.5 |
Chevrolet | US | Lumina | Midsize | 6 | 15.9 | Moderate | 21 | Good | 29 | Poor | 2.2 | Medium | 110 | 100 to <150 | 16.5 | 3195 | > 1.5 Ton | 25 |
Oldsmobile | US | Eighty-Eig | Large | 6 | 20.7 | Expensive | 19 | Poor | 28 | Poor | 3.8 | Large | 170 | 150 to <200 | 18 | 3470 | > 1.5 Ton | 23.5 |
Ford | US | Crown_Vict | Large | 6 | 20.9 | Expensive | 18 | Poor | 26 | Poor | 4.6 | Large | 190 | 150 to <200 | 20 | 3950 | > 1.5 Ton | 22 |
Buick | US | LeSabre | Large | 6 | 20.8 | Expensive | 19 | Poor | 28 | Poor | 3.8 | Large | 170 | 150 to <200 | 18 | 3470 | > 1.5 Ton | 23.5 |
Buick | US | Roadmaster | Large | 6 | 23.7 | Expensive | 16 | Poor | 25 | Poor | 5.7 | Large | 180 | 150 to <200 | 23 | 4105 | > 1.5 Ton | 20.5 |
Lincoln | US | Town_Car | Large | 6 | 36.1 | Expensive | 18 | Poor | 26 | Poor | 4.6 | Large | 210 | >=200 | 20 | 4055 | > 1.5 Ton | 22 |
Volkswagen | non-US | Eurovan | Van | 7 | 19.7 | Moderate | 17 | Poor | 21 | Poor | 2.5 | Medium | 109 | 100 to <150 | 21.1 | 3960 | > 1.5 Ton | 19 |
Dodge | US | Caravan | Van | 7 | 19 | Moderate | 17 | Poor | 21 | Poor | 3 | Large | 142 | 100 to <150 | 20 | 3705 | > 1.5 Ton | 19 |
Mazda | non-US | MPV | Van | 7 | 19.1 | Moderate | 18 | Poor | 24 | Poor | 3 | Large | 155 | 150 to <200 | 19.6 | 3735 | > 1.5 Ton | 21 |
Oldsmobile | US | Silhouette | Van | 7 | 19.5 | Moderate | 18 | Poor | 23 | Poor | 3.8 | Large | 170 | 150 to <200 | 20 | 3715 | > 1.5 Ton | 20.5 |
Ford | US | Aerostar | Van | 7 | 19.9 | Moderate | 15 | Poor | 20 | Poor | 3 | Large | 145 | 100 to <150 | 21 | 3735 | > 1.5 Ton | 17.5 |
Chevrolet | US | Lumina_APV | Van | 7 | 16.3 | Moderate | 18 | Poor | 23 | Poor | 3.8 | Large | 170 | 150 to <200 | 20 | 3715 | > 1.5 Ton | 20.5 |
Toyota | non-US | Previa | Van | 7 | 22.7 | Expensive | 18 | Poor | 22 | Poor | 2.4 | Medium | 138 | 100 to <150 | 19.8 | 3785 | > 1.5 Ton | 20 |
Nissan | non-US | Quest | Van | 7 | 19.1 | Moderate | 17 | Poor | 23 | Poor | 3 | Large | 151 | 150 to <200 | 20 | 4100 | > 1.5 Ton | 20 |
Chevrolet | US | Astro | Van | 8 | 16.6 | Moderate | 15 | Poor | 20 | Poor | 4.3 | Large | 165 | 150 to <200 | 27 | 4025 | > 1.5 Ton | 17.5 |
correlation coefficient (r ) = | 0.733198 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started