# Question

(a) For each data set, find the median, midrange, and geometric mean. (b) Are they reason- able measures of central tendency? Explain.

a. Exam scores (9 students)

42, 55, 65, 67, 68, 75, 76, 78, 94

b. GPAs (8 students)

2.25, 2.55, 2.95, 3.02, 3.04, 3.37, 3.51, 3.66

c. Class absences (12 students)

0, 0, 0, 0, 0, 1, 2, 3, 3, 5, 5, 15

a. Exam scores (9 students)

42, 55, 65, 67, 68, 75, 76, 78, 94

b. GPAs (8 students)

2.25, 2.55, 2.95, 3.02, 3.04, 3.37, 3.51, 3.66

c. Class absences (12 students)

0, 0, 0, 0, 0, 1, 2, 3, 3, 5, 5, 15

## Answer to relevant Questions

(a) Write the Excel function for the 10 percent trimmed mean of a data set in cells A1:A50. (b) How many observations would be trimmed in each tail? (c) How many would be trimmed overall? On Friday night, the owner of Chez Pierre in downtown Chicago noted the amount spent for dinner at 28 four-person tables. (a) Find the mean, midrange, geometric mean, and 10 percent trimmed mean. (b) Do these measures of ...Find the mean absolute deviation (MAD) of these five numbers: 12, 18, 21, 22, 27. For each data set, which best indicates a "typical" data value (mean, median, either)? a. MPG for 7 Honda Civics: 21.8, 24.1, 24.6, 26.2, 28.4, 35.2, 36.3 b. Number of riders in 8 cars: 1, 1, 1, 1, 1, 1, 4, 6 c. Diners at 10 ...CitiBank recorded the number of customers to use a downtown ATM during the noon hour on 32 consecutive workdays. (a) Use Excel to find the quartiles. What do they tell you? (b) Find the midhinge. What does it tell you? (c) ...Post your question

0