# Graphing Mean, Median And Mode With Excel

Graphing Mean, Median And Mode With Excel

Using the data from your Week 3 Mean, Median, and Mode assignment, describe the skewness and kurtosis with the distribution graph.

#### How many pages is this assigment?

REV/710 v4

Mean, Median, and Mode

REV/710 v4

Page 2 of 2

## Mean, Median, and Mode

Find the mean, median, mode, range, interquartile range, and standard deviation of the following two examples.

## Example 1

 X (income) No. of persons 200 24 250 26 180 16 300 20 350 6 280 30

Mean: Total X (income) = 1560 / 6 = 260 ———– Total No. of persons = 122 / 6 = 20.3333333

Median: X (income) 265 ———- Total No. of persons 22

Mode: 200, 250, 180, 300, 350, 280 Min (180) Max (350) —- 24, 26, 16, 20, 6, 30 Min (6) Max (30)

Range: 170 ——- 24

Interquartile Range: (XU-XL) : 117.5 —— (XU-XL): 13.5

Standard Deviation:

INCOME Count 6, Total 1560 Mean 260 / SqR of Variance 6356099433

Total No. of persons Count 6, Total 122 Mean 20.333333 / SqR of Variance 8.524474567

## Example 2

 X (income) No. of persons Cumulative frequency (cf) 180 16 16 200 24 40 250 26 66 280 30 96

Mean: X (income) 227.5 No. of persons 24 Cumulative frequency (cf) 54.5

Median: X (income) 225 No. of persons 25 Cumulative frequency (cf) 53

Mode: X (income) 180, 200, 250, 280 No. of persons 16, 24, 26, 30 Cumulative frequency (cf) 16, 40, 66, 96

Range: X (income) 100 No. of persons 14 Cumulative frequency (cf) 80

Interquartile Range: X (income) 87.5 No. of persons 11 Cumulative frequency (cf) 66.5

Standard Deviation: X (income) 45.73474245

No. of persons 5.887840578

Cumulative frequency (cf) 34.38507428