Explore BrainMass

Explore BrainMass

    Descriptive Statiatics & Z Score

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

    Attached are two files (Excel and Word).

    Excel comes with 2 questions and, Word comes with 1 question.

    This week my class covered the average and the standard deviation; the normal approximation for data.

    © BrainMass Inc. brainmass.com June 4, 2020, 1:53 am ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/descriptive-statiatics-score-425103

    Attachments

    Solution Preview

    Please see the attachments.

    1. Compute the mean, median, mode, variance, and standard deviation of the two variables Cholesterol and HDL.
    Answer
    Cholesterol HDL
    Combined Mean 272.2333333 25.17857143
    Combined Median 262.5 25
    Combined Mode 311 27
    Combined Variance 2418.874713 31.41137566
    Combined S.D. 49.18205682 5.604585235

    Cholesterol
    Group 1 Group 2 Group 3 Group 4
    Mean 278.5 290.125 269 254.6666667
    Median 292 271 256 252
    Mode #N/A #N/A #N/A 252
    Variance 1288.3 5490.410714 1742.666667 1146.25
    S.D. 35.89289623 74.09730572 41.74525921 33.85631403

    HDL
    Group 1 Group 2 Group 3 Group 4
    Mean 26.33333333 20.5 27.16666667 27.5
    Median 27 20.5 26 26.5
    Mode 27 24 22 33
    Variance 6.266666667 34 32.16666667 24
    S.D. 2.503331114 5.830951895 5.671566509 4.898979486

    2. In one paragraph, interpret the values of the above descriptive statistics.
    Answer
    Mean is defined as the arithmetic average of data, that is, the sum of all the numbers divided by the number of observations ...

    Solution Summary

    The solution provides step by step method for the calculation of descriptive statistics and z score. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included.

    $2.19

    ADVERTISEMENT