Discuss the following:
Q1: Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. (b) Would more than one kind of display be acceptable? Why or why not?
U.S. Fatal Crash Statistics, 2000 Fatal
Age Group Percent of Drivers Percent of Fatal Crashes
15-20 6.8 14.6
21-24 6.7 10.5
25-34 19.3 20.8
35-44 22.1 19.7
45-54 18.9 14.6
55-64 11.9 8.4
65-69 4.4 2.7
70+ 9.9 8.4
Q2: How many days in advance do travelers purchase their airline tickets? Below are data showing the advance days for a sample of 28 passengers on United Airlines Flight 815 from Chicago to Los Angeles. (a) Prepare a dot plot and discuss it. (b) Calculate the mean, median, mode, and midrange. (c) Calculate the quartiles, midhinge, and coefficient of quartile variation. (d) Why can't you use the geometric mean for this data set? (e) Which is the best measure of central tendency? Why?
Days
11 7 11 4 15 14 71 29 8 7 16 28 17 249
0 20 77 18 14 3 15 52 20 0 9 9 21 3