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.

https://brainmass.com/statistics/descriptive-statistics/descriptive-statiatics-score-425103

#### Solution Preview

1. Compute the mean, median, mode, variance, and standard deviation of the two variables Cholesterol and HDL.
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.