Question

For each of the following sets of numbers, calculate the statistics listed in the column to the right of the statistic label, or follow the directions listed.
Add any comments below each problem explaining what you found
	9 pts (comments worth 2)						9 pts (comments worth 2)						10 pts (comments worth 2)						12 pts (comments worth 2)						10 pts (5 for output, 5 for comments)
#1	227		This is a sample			#2	22		This is a population			#3	168		This is a sample			#4	108		This is a population			#5	Sample		Use Excel's Data Analysis function to run summary statistics on this data as a SAMPLE.
	231				1 pt each		23				1 pt each		160				1 pt each		201		alpha	0.05	1 pt each		108		Display results in cell AB12.
	204		mean				22		mean				170		mean				102		mean				201		This is the same data set as problem 4.
	210		median				24		median				170		median				97		median				102		Compare the results for #4 and #5, describe your thoughts (below the output table) about the results and the processes (formulas vs. Excel's analysis tool)
	203		mode				21		mode				172		mode				267		min				97
	211		min				21		min				163		min				82		max				267
	235		max				28		max				172		max				184		range				82
	232		range				22		range				171		range				325		std dev				184
	222		std dev				25		std dev				169		std dev				199		IQR				325
	222						25						167		IQR				381		Interval 1/2 width				199
	239						21						165						114		conf. upper				381
	203						25						171						446		conf. lower				114
	236						26						166						258						446
	231						28						175						100						258
	234						27						168						106						100
							20						164						78						106
							29						170						514						78
													117						235						514
													145						1079						235
													133						462						1079
													187						173						462
													129						786						173
													141						881						786
													157						205						881
													173						498						205
													191						367						498
													174						821						367
													162						571						821
													139						613						571
													147						334						613
																			145						334
																			927						145
																			636						927
																			394						636
																			887						394
																			922						887
																			404						922
																			514						404
																			328						514
																			662						328
																			789						662
																			230						789
																			96						230
																			584						96
																			742						584
	10 pts (4 for bins/output, 4 for graph, 2 for comments)																								742

Answer 1

#1 SUM= 3340 , N=15

MEAN= 222.6667

MEDIAN= 227

MODE=231

STANDARD DEVIATION= =13.06

MIN= 203

MA=239

RANGE= MAX-MIN= 239-203= 236

#2 ) SUM 409 , N=17

MEAN= 24.06

MEDIAN= 24

MODE= 22

STANDARD DEVIATION= 2.75

MIN= 20

MAX= 29

RANGE= MAX-MIN= 29-20= 9

#3) SUM = 4856, N=30

MEAN= 161.87 MODE= 170

MEDIAN= 167.5

STANDARD DEVIATION= 16.71

MIN=117

MAX=191

RANGE= MAX-MIN= 191-117= 74

LOWER QUARTILE= 154.5

UPPER QUARTILE= 171.25

IQR= 171.25-154.25= 16.75

#4) SUM= 15416 N=38

MEAN= 405.68

MEDIAN= 350.5

MODE= 514

STANDARD DEVIATION= 287.74

MIN= 78

MAX=1079

RANGE= MAX-MIN= 1079-78= 1071