Explore BrainMass
Share

Explore BrainMass

    Statistics - Dot chart, Measures of Central Tendency

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    (a) 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

    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

    © BrainMass Inc. brainmass.com June 1, 2020, 7:37 pm ad1c9bdddf
    https://brainmass.com/statistics/quantative-analysis-of-data/253250

    Solution Summary

    A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

    $2.19

    ADVERTISEMENT