Explore BrainMass

Explore BrainMass

    Chez Pierre Mean, Median, Mode; coefficient of variation

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

    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

    © BrainMass Inc. brainmass.com June 4, 2020, 12:34 am ad1c9bdddf
    https://brainmass.com/business/business-management/chez-pierre-mean-median-mode-coefficient-variation-346038

    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

    ADVERTISEMENT