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.

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

REV/710 v4

Mean, Median, and Mode

REV/710 v4

Page 2 of 2

 

C:\Users\djshirey\OneDrive - University of Phoenix\F_Drive\Style Guides\UPX Logos\Horizontal format\UOPX_Sig_Hor_Black_Medium.png

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

 

 

 

 

Copyright 2020 by University of Phoenix. All rights reserved.

Copyright 2020 by University of Phoenix. All rights reserved.