Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Is there an association between engine size and horsepower? (Consider the four categories for Hp listed in the data file)? Provide meaningful descriptive statistics

a) Is there an association between engine size and horsepower? (Consider the four categories for Hp listed in the data file)?

Provide meaningful descriptive statistics about the data such as mean, median, standard deviation, range, quartiles, IQR, fences, outliers, etc. and put this data in a table. Include charts that will best display the data - usually bar graphs, histograms, regression plots, are effective. Make sure your tables and charts are appropriately labeled and clearly discussed in your text.

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

9781118774113, 1118774116, 111803791X, 978-1118037911

Students also viewed these Mathematics questions

Question

TMC questions. please explain steps used.

Answered: 1 week ago