Explore BrainMass
Share

Statistics - Dot chart, Measures of Central Tendency

This content was STOLEN 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 October 25, 2018, 1:07 am 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
See Also This Related BrainMass Solution

Statistics definition and applications

Define and discuss the following statistical terms within the context of a business example. Each answer should be one paragraph in length.

1. Statistics and descriptive statistics
2. Population and Sample
3. Cardinal, Ordinal, and Scale Data
4. Random sample, random error, sampling error
5. Qualitative variables
6. Quantitative variables
7. Discrete variables
8. Continuous variable
9. Observational study
10. Designed experiment
11. Null and Alternate Hypothesis
12. Randomized design and matched pair design
13. Scales of measurement, nominal scale, ordinal scale, ratio scale, and interval
scale
14. Bar chart, pie chart, histogram, dot plot, stem and leaf plot, ogive
15. Measures of central tendency, mean, median, and mode Measures of
central tendency

View Full Posting Details