# Descriptive Statiatics & Z Score

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 ad1c9bdddfhttps://brainmass.com/statistics/descriptive-statistics/descriptive-statiatics-score-425103

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