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. A portion of the data from 2018 for 341

The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. A portion of the data from 2018 for 341 compact, midsize, and large cars is shown in the following table.

Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG
1 Compact 1.4 4 F R 27 40
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 P 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)Construct 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.

Size Hwy MPG Total
20-24 25-29 30-34 35-39 40-44
Compact
Large
Midsize
Total

(b)Comment on the relationship between Size and Hwy MPG.The least efficient size seems to be ________ Large Compact Midsize .(c)Construct 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.

Drive City MPG Total
10-14 15-19 20-24 25-29 30-34
A
F
R
Total

(d)Comment on the relationship between Drive and City MPG.Higher fuel efficiencies are associated with ________ rear front all wheel drive cars.(e)Construct 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.

Fuel Type City MPG Total
10-14 15-19 20-24 25-29 30-34
P
R
Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Business Reporting For Decision Making

Authors: Jacqueline Birt, Keryn Chalmers, Albie Brooks, Suzanne Byrne, Judy Oliver

4th Edition

978-0730302414, 0730302415

Students also viewed these Accounting questions