Share
Explore BrainMass

Chez Pierre Mean, Median, Mode; coefficient of variation

4.6 On Friday night, the owner of Chez Pierre in downtown Chicago noted the amount spent for
dinner for 28 four-person tables.

(a) Use Excel or MegaStat to find the mean, median, and mode.
(b) Do these measures of central tendency agree? Explain.
(c) Are the data symmetric or skewed? If skewed, which direction?
(d) Note strengths or weaknesses of each statistic of central tendency for the data.

95 103 109 170 114 113 107
124 105 80 104 84 176 115
69 95 134 108 61 160 128
68 95 61 150 52 87 136

4.16 Prof. Hardtack gave four Friday quizzes last semester in his 10-student senior tax accounting
class.

(a) Using Excel, find the mean, standard deviation, and coefficient of variation for each quiz.
(b) How do these data sets differ in terms of central tendency and dispersion?
(c) Briefly describe and compare student performance on each quiz.

Quiz 1: 60, 60, 60, 60, 71, 73, 74, 75, 88, 99
Quiz 2: 65, 65, 65, 65, 70, 74, 79, 79, 79, 79
Quiz 3: 66, 67, 70, 71, 72, 72, 74, 74, 95, 99
Quiz 4: 10, 49, 70, 80, 85, 88, 90, 93, 97, 98

Solution Preview

See attached Excel file.

4.6 (A)
mean=107.25
median=106
mode=95

Microsoft Excel's mean function is =AVERAGE(range of data). Just enter your data in a column or a row and tell Excel where it is and it will use the AVERAGE function to determine the arithmetic mean for you.

So, if ...

Solution Summary

The coefficient of variations mean, median and modes are examined.

$2.19