Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c) Is there a relationship between car weight and horsepower for cars weighing from 2500-3100 lbs? Provide meaningful descriptive statistics about the data such as

c) Is there a relationship between car weight and horsepower for cars weighing from 2500-3100 lbs?

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

Hyers-Ulam Stability Of Ordinary Differential Equations

Authors: Arun Kumar Tripathy

1st Edition

1000386902, 9781000386905

More Books

Students also viewed these Mathematics questions