Purchase Solution

Chez Pierre Mean, Median, Mode; coefficient of variation

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution
Solution Summary

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

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 ...

Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Operations Management

This quiz tests a student's knowledge about Operations Management

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Descriptive Statistics

    Calculate coefficient of variation Coefficient of variation = =0.8672/2.237*100 =38.7662 g. Define Mode : The mode is the value that occurs most frequently in a data set.

  • Statistical calculations on sample of chocolate chip cookies

    The solution gives detailed steps on computing mean, median, mode, variance, standard deviation, range, coefficient of variation and Z scores and performing relevant analysis.

  • Statistics of Weekly Overtime Hours

    a statistical analysis on the weekly overtime hours to determine mean, median, mode, mean deviation, standard deviation and coefficient of variance.

  • Descriptive Statistics, Normal Distribution

    Please see the attached file: 3 Questions on mean, median, mode, variance, standard deviation, and coefficient of variation, confidence interval etc have been answered.

  • Mean,Median,Mode,Range,Variance,Standard Deviation,Coeficien

    Calculate the coefficient of variation. The solution file is attached A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

  • Discussing the Distribution of a Data Population

    Coefficient of variation of domestic passengers =(10/47)*100=21% Coefficient of variation of overseas passengers =(15/78)*100=19% Comment on the difference in relative dispersion.

  • Elementary Statistics: Mean, Median and Mode

    The solution discusses elementary statistics including mean, median and mode.

  • Finding the Mean, Median, and Standard Deviation

    Part a) Compute the mean, median, and mode. Part b) Compute the range, variance, standard deviation, and coefficient of variation. Part c) Compute the minimum, maximum, sum, count, first quartile, third quartile and interquartile ranges.

  • Summary statistics

    49782 Summary statistics-mean, median, mode, first quartile, third quartile, range, interquartile range, 90th percentile, shape of the distribution, skewness, sample variance and sample standard deviation, coefficient of variation, grouped data 2.

View More Related Solutions