Prepare a crosstabulation of the data on displacement rows


Question: Refer to exercise and the data in the file named FuelData2012.

a. Prepare a crosstabulation of the data on Displacement (rows) and Hwy MPG (columns). Use classes of 1-2.2-3,3-4, 4-5, 5-6, and 6-7 for Displacement. Use classes of 15-19.20-24.25-29.30-34. and 35-39 for Hwy MPG.

b. Comment on the relationship. if any. between Displacement and Hwy MPG.

c. Develop a scatter diagram of the data on Displacement and Hwy MPG. Use the vertical axis for Hwy MPG.

d. What does the scatter diagram developed in part (c) indictee about the relationship. if any. between Displacement and Hwy MPG?

e. In investigating the relationship between Displacement and Hwy MPG you developed a tabular summary of the data (crosstabulation) and a graphical summary (scatter diagram). In this case which approach do you prefer? Explain.

Exercise: 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 Table 2.14. The data set contains the following variables:

657_2.0.png

The complete data set is contained in the file named FuelData2012.

a. Prepare a crosstabulation of the data on Size (rays) and Hwy MPG (columns). Use classes of 15-19.20-24.25-29,30-34.35-39. and 40-44 for Hu, MPG.

b. Comment on the relationship between Size and Hwy MPG.

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.

d. Comment on the relationship between Drive and 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.

f. Comment on the relationship between Fuel Type and City MPG.

2333_2.png

Request for Solution File

Ask an Expert for Answer!!
Management Theories: Prepare a crosstabulation of the data on displacement rows
Reference No:- TGS02250242

Expected delivery within 24 Hours