Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website). A portion of the data from

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website). A portion of the data from 2018 for 341 compact, midsize, and large cars is shown in the table below. Click on the datafile logo to reference the data DATA file Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG Compact 27 40 2 Compact R 27 35 Compact 1.4 28 38 1 1.4 4 F R 1.4 4 F 3 4 F R . . . . . . . 190 2.5 4 F R 36 Compact Large Midsize 27 22 4 191 192 F R 2.5 2.5 30 4 F R 21 32 . . . . . . . R P 13 21 R P 13 22 339 Large 6.0 12 340 Large 6.0 12 341 Large 6.6 12 The data set contains the following variables: 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 fueldata 2018. If your answer is zero, enter "O". 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 Large Midsize Total b. Comment on the relationship between Size and Hwy MPG. - Select your answer - C. 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 30-34 Total A F R Total d. Comment on the relationship between Drive and City MPG. Higher fuel efficiencies are associated with - Select your answer - 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 P R Total f. Comment on the relationship between Fuel Type and City MPG. Higher fuel efficiencies are associated with cars that use premium vfuel The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website). A portion of the data from 2018 for 341 compact, midsize, and large cars is shown in the table below. Click on the datafile logo to reference the data DATA file Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG Compact 27 40 2 Compact R 27 35 Compact 1.4 28 38 1 1.4 4 F R 1.4 4 F 3 4 F R . . . . . . . 190 2.5 4 F R 36 Compact Large Midsize 27 22 4 191 192 F R 2.5 2.5 30 4 F R 21 32 . . . . . . . R P 13 21 R P 13 22 339 Large 6.0 12 340 Large 6.0 12 341 Large 6.6 12 The data set contains the following variables: 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 fueldata 2018. If your answer is zero, enter "O". 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 Large Midsize Total b. Comment on the relationship between Size and Hwy MPG. - Select your answer - C. 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 30-34 Total A F R Total d. Comment on the relationship between Drive and City MPG. Higher fuel efficiencies are associated with - Select your answer - 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 P R Total f. Comment on the relationship between Fuel Type and City MPG. Higher fuel efficiencies are associated with cars that use premium vfuel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To solve this well organize the data into crosstabulations based on the specified categories Heres a ... 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

The Medicare Recovery Audit Contractor Program A Survival Guide For Healthcare Providers

Authors: Duane C. Abbey

1st Edition

1439821003, 978-1439821008

More Books

Students also viewed these Accounting questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago