Problem

(a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display...

(a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acceptable? Why or why not?

Survey of 282,549 Freshmen at 437 Colleges and Universities
Year	Percent Who Study at Least 6 Hours/Week	Percent Who Plan to Major in Business
1995	31.6	17.6
1996	31.6	18.2
1997	32.7	17.0
1998	30.9	16.0
1999	28.9	16.2
2000	26.1	16.3
2001	21.8	15.6
2002	21.9	15.8