The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website, September 8, 2012). A portion of the data for 149 compact, midsize, and large cars is shown in the table below. Click on the datafile logo to reference the data. DATA file TABLE 2.13 FUEL EFFICIENCY DATA FOR 311 CARS Car Size Displacement Cylinders Drive Fuel Type City MPG Hwy MPG 1 Compact 2.0 4 F P 22 30 2 Compact 2.0 4 A P 21 29 3 Compact 2.0 A P 21 31 94 Midsize 3.5 95 Midsize 2.5 . 148 Large 6.7 149 Large 6.7 .22 12 12 RRPR RRR 25 33 11 18 11 18 The data set contains the following variables: Size: Compact, Midsize, and Large Displacement: Engine size in liters Cylinders: Drive: Fuel Type: Number of cylinders in the engine All wheel (A), front wheel (F), and rear wheel (R) 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 FuelData2012. If your answer is zero, enter "0". a. Prepare a crosstabulation of the data on Size (rows) and Hwy MPG (columns). Use classes of 15-19, 20-24, 25-29, 30-34, 35- 39, and 40-44 for Hwy MPG. Hwy MPG Size 15-19 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. The input in the box below will not be graded, but may be reviewed and considered by your instructor. b. Comment on the relationship between Size and Hwy MPG. The input in the box below will not be graded, but may be reviewed and considered by your instructor. 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, 30- 34, 35-39, and 40-44 for City MPG. City MPG 30-34 35-39 40-44 Total Drive 10-14 15-19 20-24 25-29 A 3 43 57 5 0 F 0 8 43 48 82 16 R 10 33 32 4 0 Total d. Comment on the relationship between Drive and City MPG. The input in the box below will not be graded, but may be reviewed and considered by your instructor. 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, 30-34, 35-39, and 40-44 for City MPG. 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, 30-34, 35-39, and 40-44 for City MPG. City MPG Fuel Type 10-14 15-19 20-24 25-29 30-34 35-39 40-44 Total P 26 43 75 15 R 13 58 94 16 1 Total f. Comment on the relationship between Fuel Type and City MPG. The input in the box below will not be graded, but may be reviewed and considered by your instructor