Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hint(s) Check My Work (1 remaining) 6. 7. O The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks
Hint(s) Check My Work (1 remaining) 6. 7. O 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 8 on the datafile logo to reference the data. DATA file Hwy MPG Car Size Displacement Cylinders Drive Fuel Type City MPG 1 Compact 1.4 T R 27 40 35 2 Compact 1.4 A 27 38 3 Compact 1.4 28 A . . 73 . . . . . 36 190 Compact 2.5 A A 30 191 Large 2.5 32 192 Midsize 2.5 A . . . . . . UDO . . 339 Large 6.0 12 13 21 340 Large 6.0 12 13 22 5.6 12 13 20 341 Large 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. If your answer is zero, enter "(". 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.C201 Hwy MPG Size 20 - 24 25 - 29 30 - 34 35 - 39 40 - 44 Total Compact x 3 X 1 X 1 X Large 3 * 1 0 X 0 X 4 X Midsize OX 0 X 1 X Total 3 X O X 2 X 3 X 1 X 9 b. Comment on the relationship between Size and Hwy MPG. Compact and large cars seem to be more fuel efficient than midsize cars. v 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 1 X O X ox O X 1 X F 2 4 x O X 6 X R 2 X OX OX 2 X Total 3 X 2 X 4 X O X 9 x d. Comment on the relationship between Drive and City MPG. Higher fuel efficiencies are associated with front v 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 ox X 3 X R OX 2 X O X 6 X Total 3 X 2 X 0 9 X f. Comment on the relationship between Fuel Type and City MPG. Higher fuel efficiencies are associated with cars that use regular fuel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started