DATA:Pue Data 2018 The U.S. Department of Energy's Fuel Economy Guide provides fue ency data for cars and trucks. A portion of the data from 2018 for 301 compact, misire, and large cars is shown in the following table Car Displacement Cylinders Drive Fuel Type City MPG Hwy MPG 1 Compact F R 27 40 2 Compact 1.4 4 27 3 4 20 38 Compact 1 2.5 F 27 36 190 Compact 191 Large 25 R 22 25 F R 21 3 1 60 12 R P 13 21 340 6.0 13 Large 12 22 R P 12 13 20 341 Large The data in the following variables Sue Compact, Hide and Large Displacement: Engine se inters Cylinders: Number of eyinders in the engine Drive All wheel (Al. front wheel (F), and rear wheel (R) Fuel Type Premium (P) or regular) Cty MPG full ency rating for trying in terms of miles per to Hwy MPG fecering for hy driving in terms of meer aan The complete date setioned in the named 2016 The complete data set is contained in the file named FuelData 2018 (a) Prepare a crosstabulation of the data on Size (rows) and Hwy MPG (columns). Use dasses 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 O 0 3 1 Large 1 0 0 4 Midsize O 1 0 lo 1 Total 3 X 0 X 2 X 3 X 1 X 341 X (b) Comment on the relationship between Size and Hwy MPG. The least efficient size seems to be Large (c) Prepare a crosstabulation of the data on Drive (rows) and Oty 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 OX D X D X 0 X ON X F 0 X 2 X 4 OX 6 X B X 0 X 0 0 3 X Total 3 X 0 X 2 X 4 X 0 X 9 x (d) Comment on the relationship between Drive and City MPG Higher fuel efficiencies are associated with front wheel drive cars (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 P 3 X 0 X 0 X 0 x 0 x 3 R 0 X 2 X 4 X 0 x 6 X Total 0 > 0 X 2 X 4 X 0 x X Comment on the relationship between Fuel Type and City MPG. Higher fuel efficiencies are associated with cars that use regular gas DATA:Pue Data 2018 The U.S. Department of Energy's Fuel Economy Guide provides fue ency data for cars and trucks. A portion of the data from 2018 for 301 compact, misire, and large cars is shown in the following table Car Displacement Cylinders Drive Fuel Type City MPG Hwy MPG 1 Compact F R 27 40 2 Compact 1.4 4 27 3 4 20 38 Compact 1 2.5 F 27 36 190 Compact 191 Large 25 R 22 25 F R 21 3 1 60 12 R P 13 21 340 6.0 13 Large 12 22 R P 12 13 20 341 Large The data in the following variables Sue Compact, Hide and Large Displacement: Engine se inters Cylinders: Number of eyinders in the engine Drive All wheel (Al. front wheel (F), and rear wheel (R) Fuel Type Premium (P) or regular) Cty MPG full ency rating for trying in terms of miles per to Hwy MPG fecering for hy driving in terms of meer aan The complete date setioned in the named 2016 The complete data set is contained in the file named FuelData 2018 (a) Prepare a crosstabulation of the data on Size (rows) and Hwy MPG (columns). Use dasses 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 O 0 3 1 Large 1 0 0 4 Midsize O 1 0 lo 1 Total 3 X 0 X 2 X 3 X 1 X 341 X (b) Comment on the relationship between Size and Hwy MPG. The least efficient size seems to be Large (c) Prepare a crosstabulation of the data on Drive (rows) and Oty 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 OX D X D X 0 X ON X F 0 X 2 X 4 OX 6 X B X 0 X 0 0 3 X Total 3 X 0 X 2 X 4 X 0 X 9 x (d) Comment on the relationship between Drive and City MPG Higher fuel efficiencies are associated with front wheel drive cars (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 P 3 X 0 X 0 X 0 x 0 x 3 R 0 X 2 X 4 X 0 x 6 X Total 0 > 0 X 2 X 4 X 0 x X Comment on the relationship between Fuel Type and City MPG. Higher fuel efficiencies are associated with cars that use regular gas