data analysis hw 4-2

Sheet1

	Data for Classroom Assignment - Class #2, Assignment I
	IQ values of 6 samples of 40 random individuals each
	Sample 1		Sample 2		Sample 3		Sample 4		Sample 5		Sample 6		BIN sizes for Histogram			Descriptive Statistics: Sample 1
																Statistics
	94		85		119		94		85		100		60			Variable	N	N*	Mean	StDev	Minimum	Q1	Median	Q3	Maximum	IQR
	92		84		93		92		123		64		70			Sample 1	40	0	100.68	11.6	69	93.25	101	110.75	126	17.5
	106		95		100		106		87		101		80
	95		133		83		95		112		103		90
	69		93		110		69		113		103		100
	104		123		83		104		116		80		110			Bin	Frequency
	101		118		105		101		86		98		120			60	0
	100		82		100		100		80		95		130			70	1
	94		112		91		94		106		96					80	1
	111		94		77		111		112		124					90	5
	88		91		85		88		72		126					100	11
	112		112		99		112		98		86					110	12
	103		98		115		103		81		104					120	9
	101		98		98		101		91		118					130	1
	111		100		89		111		86		94					More	0
	78		100		108		78		75		110
	119		89		97		119		105		96
	95		104		110		95		84		98					Bin	Frequency
	86		95		82		86		110		85					60	0
	93		95		83		93		69		98					70	1
	112		112		124		112		124		97					80	3
	126		100		140		126		107		85					90	10
	94		97		107		94		95		86					100	5
	107		103		104		107		103		113					110	12
	86		107		138		86		99		87					120	6
	103		110		95		103		102		112					130	3
	115		101		129		115		95		94					More	0
	101		105		104		101		83		84
	110		87		112		110		101		83
	107		100		118		107		90		77					Bin	Frequency
	102		119		92		102		114		90					60	0
	99		115		107		99		109		94					70	1
	112		105		119		112		102		112					80	3
	115		101		78		115		112		97					90	8
	99		81		94		99		86		102					100	13
	88		111		108		88		110		102					110	8
	88		100		93		88		108		102					120	5
	105		89		116		105		101		111					130	2
	114		90		98		114		84		94					More	0
	92		92		105		92		124		77
															SD of sample means = SEM
Summary Statistics		Quartile.Exc											mean of sample means		actual	theoretical calc
sample mean	100.7		100.7		102.7		100.7		98.5		97.0		100.0		2.01	1.83	2.4349537983
median	101.0		100.0		102.0		101.0		101.0		97.0					w SD 11.6	w SD 15.4
mode	94.0		100.0		83.0		94.0		112.0		94.0		range of sample means
sample SD	11.6		11.6		15.4		11.6		14.6		13.0	13.0	97	102.7
Standard error of the mean (SEM)	1.83		1.84		2.43		1.83		2.30		2.05	2.05
minimum	69.0		81.0		77.0		69.0		69.0		64.0
maximum	126.0		133.0		140.0		126.0		124.0		126.0
range	57.0		52.0		63.0		57.0		55.0		62.0		BIN sizes for Histogram
Q1	93.75	93.25	92.8		92.8		93.8		86.0		86.8		60
Q2	101.00	101.00	100.0		102.0		101.0		101.0		97.0		70
Q3	110.25	110.75	107.8		110.5		110.3		110.0		103.0		80
Q4	126.00	ERROR:#NUM!	133.0		140.0		126.0		124.0		126.0		90
90th %ile	114.9		117.7		123.5		114.9		115.8		112.9		100
50th %ile	101.0		100.0		102.0		101.0		101.0		97.0		110
	MINITAB												120
Mean	100.68		sample mean	100.675									130
StDev	11.6		sample SD	11.5966120163
Minimum	69		minimum	69	Q.EXC
Q1	93.25		Q1	93.75	93.25
Median	101		median	101	101.00	conclusion: MINITAB calculates QUARTILE.EXC
Q3	110.75		Q3	110.25	110.75
Maximum	126		maximum	126
IQR	17.5		IQR	16.5
			range	57
	Sample 1			Sample 2			Sample 3
	Bin	Frequency		Bin	Frequency		Bin	Frequency
	60	0		60	0		60	0
	70	1		70	0		70	0
	80	1		80	0		80	2
	90	5		90	8		90	6
	100	11		100	15		100	12
	110	12		110	8		110	10
	120	9		120	7		120	6
	130	1		130	1		130	2
	More	0		More	1		More	2
	sample means sorted				Data for bar graph
		"BINS"	frequency		sample mean	frequency
	96.95	97	1		70	0
	98.5	98.5	1		75	0
	100.675	100.7	3		80	0
	100.65				85	0
	100.675				90	0
	102.7	102.7	1		95	0
					98	2
					101	3
					103	1
					110	0
					115	0
					120	0
					125	0
					130	0

Histogram - Sample 1

Frequency 60 70 80 90 100 110 120 130 More 0 1 1 5 11 12 9 1 0

Bin

Frequency

Histogram - Sample 2

Frequency 60 70 80 90 100 110 120 130 More 0 0 0 8 15 8 7 1 1

Bin

Frequency

Histogram -Sample 3

Frequency 60 70 80 90 100 110 120 130 More 0 0 2 6 12 10 6 2 2

Bin

Frequency

Distribution of sample means

sample means 70 75 80 85 90 95 98 101 103 110 115 120 125 130 0 0 0 0 0 0 2 3 1 0 0 0 0 0 70 75 80 85 90 95 98 101 103 110 115 120 125 130 70 75 80 85 90 95 98 101 103 110 115

Histogram -Sample 3

Frequency 60 70 80 90 100 110 120 130 More 0 0 2 6 12 10 6 2 2

Bin

Frequency

Histogram Sample 4

Frequency 60 70 80 90 100 110 120 130 More 0 1 1 5 11 12 9 1 0

Frequency

Histogram Sample 5

Frequency 60 70 80 90 100 110 120 130 More 0 1 3 10 5 12 6 3 0

Frequency

Histogram - Sample 6

Frequency 60 70 80 90 100 110 120 130 More 0 1 3 8 13 8 5 2 0

Frequency