Refer to exercise 37 and the data in the file named Fuel Data2012. a. Prepare a crosstabulation
Question:
Refer to exercise 37 and the data in the file named Fuel Data2012.
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) indicate 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 (cross tabulation) and a graphical summary (scatter diagram). In this case which approach do you prefer? Explain.
Step by Step Answer:
Essentials Of Modern Business Statistics With Microsoft Excel
ISBN: 9780840062383
5th Edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams