The first Rose Bowl (football) was played in 1902

1​‌‍‍‍‌‍‍‌‍‌‌‍‍‍‌‍‌‌‌‍​. The first Rose Bowl (football) was played in 1902. The next one was not played until 1916, but a Rose Bowl has been played every year since then. The margin of victory in each of the 100 Rose Bowls from 1902 through 2016 is shown below (0 indicates a tie). (a) Prepare a stem-and-leaf plot. (b) Prepare a frequency distribution and histogram (you may either specify the bins yourself or use automatic bins). (c) Describe the distribution, based on these displays. (A worksheet named as RoseBowl is available in the attached dataset) 2. Below are batting averages of the New York Yankees players who were at bat five times or more in 2006. (a) Construct a frequency distribution. Explain how you chose the number of bins and the bin limits. (b) Make a histogram and describe its appearance. (c) Repeat, using a different number of bins and different bin limits. (d) Did your visual impression of the data change when you changed the number of bins? Explain. (A worksheet named as Yankees is available in the attached dataset) 3. (a) Use Excel to make a scatter plot, placing Dolona on the X-axis and ZalParm on the Y-axis. Add titles and modify the default colors, fonts, etc., as you judge appropriate to make the scatter plot effective. (b) Describe the relationship (if any) between X and Y. Weak? Stro​‌‍‍‍‌‍‍‌‍‌‌‍‍‍‌‍‌‌‌‍​ng? Negative? Positive? Linear? Nonlinear? (c) Make a line chart showing both time series variables on the same chart. Does the line chart support your conclusions from the scatter plot? (A worksheet named as StockPrices is available in the attached dataset) 4. 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? (A worksheet named as CarColor is available in the attached dataset) 5. (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to disp
lay 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? (A worksheet named as Petroleum is available in the attached dataset) 6. (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data.

Sample Solution