Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG Compact 1.4 4 F R 27 40 2 2 Compact 1.4 4 F R

image text in transcribed
image text in transcribed
image text in transcribed
Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG Compact 1.4 4 F R 27 40 2 2 Compact 1.4 4 F R 27 35 3 Compact 1.4 4 F R 28 38 190 Compact 2.5 4 F R 27 36 191 Large 2.5 4 F R 22 30 192 Midsize 2.5 4 F R 21 32 *** 339 Large 6.0 12 R P 13 21 340 Large 6.0 12 R 13 22 341 Large 6.0 12 R P 13 20 The data set contains the following variables. Size: Compact, Midsize, and Large Displacement: Engine size in liters Cylinders: Number of cylinders in the engine Drive: All wheel (A), front wheel (F), and rear wheel (R) Fuel Type: Premium (P) or regular (R) fuel City MPG: fuel efficiency rating for city driving in terms of miles per gallon Hwy MPG: fuel efficiency rating for highway driving in terms of miles per gallon The complete data set is contained in the file named FuelData2018. (a) Prepare a crosstabulation of the data on Size (rows) and Hwy MPG (columns). Use classes of 20-24, 25-29, 30-34, 35-39, and 40-44 for Hwy MPG Hwy MPG Size 20-24 25-29 30-34 35-39 40-44 Total Compact 0 X 100 X Large 3 X 0 Midsize O X 0 X Total 3 X 109 X (9) Prepare a crosstabulation of the data on Drive (rows) and City MPG (columns). Use classes of 10-14, 15-19, 20-24, 25-29, and 30-34 for City MPG. City MPG Drive 10-14 15-19 20-24 25-29 25-29 30-34 Total 11 R Total (d) Comment on the relationship between Drive and City MPG Higher fuel efficiencies are associated with front wheel drive cars, (e) Prepare a crosstabulation of the data on Fuel Type (rows) and City MPG (columns). Use classes of 10-14, 15-19, 20-24, 25-29, and 30-34 for City MPG City MPG Fuel Type 10-14 15-19 20-24 25-29 30-34 Total 3 X 10 X 0 X 0 X 10 X 3 X R 10 X 2 X 4 X 0 X 6 X Total 10 X 2 X 4 X 0 9 X

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

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago