Overview

bfi 73
histograms
BFI Summer 2001
ttest independent samples

Sheet 1: bfi 73

Term	Sex	Age	Height	Weight	BodyFat	Term	Sex	Age	Height	Weight	BodyFat
71	F	19	56	93	14.9	71	M	19	66	165.2	16.4
71	F	19	59	112	25.1	71	M	19	66	119.6	6.9
71	F	19	59	115.2	21.8	71	M	19	68	151.2	12.1
71	F	19	61	166.4	40.4	71	M	19	69	155.2	13.1
71	F	19	61	120.2	23.7	71	M	19	71	137.6	8.4
71	F	20	59	122.6	28.9	71	M	19	71	248.8	30.6
71	F	20	60	150	38	71	M	20	64	145.2	17
71	F	20	60	117.6	25.3	71	M	20	65	213	31.8
71	F	20	60.5	108.6	20.6	71	M	20	67.5	122.2	9.7
71	F	20	61	170.8	37	71	M	21	66	134.2	13.6
71	F	20	61	137.2	32.5	71	M	21	66	204.4	33.2
71	F	20	62	126	25.5	71	M	21	68	182.6	22.1
71	F	20	62	181	41.8	71	M	22	64	183.8	27.7
71	F	20	63	127.4	25.3	71	M	22	69	169	19.1
71	F	20	63	139.4	28.1	71	M	22	72	174	15.4
71	F	20	66	211.8	42.4	71	M	23	69	183.8	20.2
71	F	20	67	264.2	47.7	71	M	24	66	174.4	22.1
71	F	21	62	122.6	25.6	71	M	27	68	208.4	27.6
71	F	21	62	183	38.4	72	M	18	69	150.8	12.8
71	F	21	62	117.2	25.3	72	M	19	65	125.6	10.9
71	F	21	62.5	118.6	25	72	M	19	67	252	33.6
71	F	21	63	140	32	72	M	20	61	116.6	22.1
71	F	21	64	152.8	27.3	72	M	20	61	197.8	42.3
71	F	22	61	120.8	31.8	72	M	20	68	187	18
71	F	22	64	136.2	30.2	72	M	20	71	163.2	14.1
71	F	22	65	250.4	48	72	M	21	62	131.6	17.2
71	F	22	65	216.6	44.1	72	M	21	65.5	137.4	12.9
72	F	19	58	119	24.4	72	M	24	66	173.4	22
72	F	19	62	155.8	31.9	72	M	24	70	168.2	18.4
72	F	20	60	151.6	37.7	72	M	25	71	176.8	15.2
72	F	21	64	195.8	39.6	72	M	31	69	211.2	30.6
72	F	22	63	122.2	31.2	73	M	17	63	146.8	30.5
72	F	23	59	112.2	21.5	73	M	19	64	142.2	15.1
72	F	23	64	137	28.5	73	M	19	66	133	12
72	F	24	69	185.2	19.9	73	M	19	66	125.4	10.6
73	F	17	61	130.2	28.8	73	M	19	67	181.8	21.1
73	F	18	60	121	25.2	73	M	20	65	132	10
73	F	18	63	130.6	25.2	73	M	20	65	124.6	11.1
73	F	19	58	110.2	25	73	M	20	66	135.8	11.3
73	F	19	58	95.4	18	73	M	20	67	230.4	34.4
73	F	19	60	121.2	27.7	73	M	20	67	124.6	9.9
73	F	19	60	115	21.4	73	M	20	68	199.2	24.2
73	F	20	59	122.8	29	73	M	21	67	189.6	20.4
73	F	20	61	138.8	28.4	73	M	22	66	246.6	30.9
73	F	20	61	115.4	20.6	73	M	23	67	158	19.2
73	F	20	61	114.2	21.2	73	M	23	68	171.2	15
73	F	20	62	201.2	39.4	73	M	24	63	164	23.5
73	F	20	63	137.6	27.1	73	M	24	69	180.2	19.3
73	F	20	64	122.8	23.7	73	M	24	69	179	18.4
73	F	21	61	159.6	36.7	73	M	27	69	208.6	25.3
73	F	21	62	101	18.6
73	F	21	62	90.2	6.9
73	F	21	63	129.8	29.3
73	F	21	65	161	36.8
73	F	22	60	132.2	28.5
73	F	22	62	130.8	25.9
73	F	23	61	117.6	26.4
73	F	24	62	96.8	14.9
73	F	24	63	200.2	44.2
73	F	26	65	226	40.9
73	F	27	64	215.2	46.6
73	F	31	60	183.4	42.4
73	F	31	66	170.8	39.8
73	F	35	63	143.2	33.4


	Females							Males
		Age	Height	Weight	BodyFat			Age	Height	Weight	BodyFat
	Count	64	64	64	64			50	50	50	50
	min	17	56	90.2	6.9			17	61	116.6	6.9
	max	35	69	264.2	48			31	72	252	42.3
	range	18	13	174	41.1			14	11	135.4	35.4
	mode	20	61	117.6	25.3			20	66	124.6	22.1
	median	20	62	130.7	28.45			20	67	168.6	18.4
	mean	21.23	61.88	144.29	29.9			21.2	66.86	168.74	19.59
	stdev	3.08	2.35	38.79	8.79			2.64	2.55	35.3	8.17
	cv	0.15	0.04	0.27	0.29			0.12	0.04	0.21	0.42

	-2	15.08	57.17	66.72	12.33			15.92	61.75	98.15	3.25
	2	27.39	66.58	221.86	47.47			26.48	71.97	239.34	35.92

Sheet 2: histograms

	Female				Male
	Age	Height	Weight	BodyFat	Age	Height	Weight	BodyFat
min	17	56	90.2	6.9	17	61	116.6	6.9
max	35	69	264.2	48	31	72	252	42.3
range	18	13	174	41.1	14	11	135.4	35.4
bins	5	5	5	5	5	5	5	5
width	3.6	2.6	34.8	8.22	2.8	2.2	27.08	7.08

	Age	Height	Weight	BodyFat	Age	Height	Weight	BodyFat
Bin one	20.6	58.6	125	15.12	19.8	63.2	143.68	13.98
Bin two	24.2	61.2	159.8	23.34	22.6	65.4	170.76	21.06
Bin three	27.8	63.8	194.6	31.56	25.4	67.6	197.84	28.14
Bin four	31.4	66.4	229.4	39.78	28.2	69.8	224.92	35.22
Bin five	35	69	264.2	48	31	72	252	42.3

Frequencies	Age	Height	Weight	BodyFat	Age	Height	Weight	BodyFat
	34	4	27	3	14	5	15	15
	25	25	20	9	23	7	11	16
	2	21	8	28	10	18	14	10
	2	12	7	13	2	14	6	8
	1	2	2	11	1	6	4	1
Sum is sample size	64	64	64	64	50	50	50	50

	Age	Height	Weight	BodyFat	Age	Height	Weight	BodyFat
RF	0.53	0.06	0.42	0.05	0.28	0.1	0.3	0.3
	0.39	0.39	0.31	0.14	0.46	0.14	0.22	0.32
	0.03	0.33	0.13	0.44	0.2	0.36	0.28	0.2
	0.03	0.19	0.11	0.2	0.04	0.28	0.12	0.16
	0.02	0.03	0.03	0.17	0.02	0.12	0.08	0.02
Sum is one	1	1	1	1	1	1	1	1

Female body fat
BodyFat	Freq	RF
15.12	3	0.05
23.34	9	0.14
31.56	28	0.44
39.78	13	0.2
48	11	0.17
	64	1





Male body fat
BodyFat or x	Freq	RF or p(x)	*xP(x)**
13.98	15	0.3	4.19
17.96	16	0.32	5.75
22.54	10	0.2	4.51
27.12	8	0.16	4.34
31.7	1	0.02	0.63
	50	1	19.42

Sheet 3: BFI Summer 2001

n	Gender	Age	Height	Weight	Body Fat
1	F	19	64	184	37.5
2	F	19	63	127	22.8
3	F	20	61	161.5	35.8
4	F	19	62	122.8	25.2
5	F	19	62	116.8	25.5
6	F	20	64	148.6	32.9
7	F	19	59.5	131.6	28.1
8	F	19	62	132	27.9
9	F	29	64	284.8	50.1
10	F	19	63	119.6	22.1
11	F	19	61.5	125.2	28
12	F	20	62	159.8	35.5
13	F	21	60	188.6	40.8
14	F	20	59.5	128.6	28.4
15	F	23	61	126.2	22.2
16	F	19	60	95.8	15.6
17	F	19	60	112.6	22.8
18	F	23	62	148	31.6
19	F	18	64	151.8	34
20	F	21	63.5	130.6	26.2

	count	20	20	20	20
	mean	20.3	61.9	144.8	29.7
	sx	2.4	1.6	40.3	7.9
	mode	19	62	#VALUE!	22.8
	median	19	62	131.1	28.05
	skew	2.7	-0.1	2.4	0.8
	alpha	0.05	0.05	0.05	0.05
	confidence	1.07	0.69	17.65	3.44
	SE	0.55	0.35	9.01	1.76	sx/sqrt(n)
	z statistic	1.96	1.96	1.96	1.96	NORMSINV(1-alpha/2)
	t statistic	2.09	2.09	2.09	2.09	TINV(alpha,d.f.)
	E: z*sx/sqrt(n)	1.07	0.69	17.65	3.44
	E: t*sx/sqrt(n)	1.15	0.73	18.85	3.68
	x-E	19.1	61.2	125.9	26.0
	x+E	21.4	62.6	163.6	33.3

n	Gender	Age	Height	Weight	Body Fat
1	M	18	68	154.4	14.7
2	M	23	66.5	175.2	23.4
3	M	22	65	200.4	30.2
4	M	18	63	155	18.3
5	M	22	73	433.8	45.9
6	M	22	69.5	225.2	32.5
7	M	19	67.5	190	19.8
8	M	32	66	187.6	25.7
9	M	20	66	156.4	16.4
10	M	23	60.5	190.8	35.2
11	M	20	65	134.2	10.5
12
13
14
15
16

	count	11	11	11	11
	mean	21.7	66.4	200.3	24.8
	sx	3.9	3.3	81.6	10.4
	mode	22	65	#VALUE!	#VALUE!
	median	22	66	187.6	23.4
	skew	2.0	0.3	2.7	0.7
	alpha	0.05	0.05	0.05	0.05
	confidence	2.29	1.94	48.22	6.17
	SE	1.17	0.99	24.60	3.15
	z statistic	1.96	1.96	1.96	1.96
	t statistic	2.23	2.23	2.23	2.23
	E: z*sx/sqrt(n)	2.29	1.94	48.22	6.17
	E: t*sx/sqrt(n)	2.60	2.20	54.82	7.01
	x-E	19.1	64.2	145.5	17.8
	x+E	24.3	68.6	255.1	31.8


	Data for MS 150 Test Two Summer 2001
	P(x<31)	0.5			10.5
	P(x>39)	0.16			14.7
	400	63.46			16.4
					18.2
	P(x>?)=0.20	0.84			19.8
	mean	31			23.4
	stdev	8			25.7
	x>	37.73			30.2
					32.5
	Confidence	13.15			35.2
	mean	470			45.9
	x-E	456.85
	x+E	483.15		mean	24.77	24.77
		Yep		stdev	10.44	10.44
				n	11	11
				alpha	0.1	0.05
				df	10	10
				tc	1.81	2.23
				SE	3.15	3.15
				E	5.71	7.01
				x-E	19.07	17.76
				x+e	30.48	31.79

					-0.46
					0.67

Sheet 4: ttest independent samples

	x	y	Weight M 2001	Weight m2007
n	11	13	154.4	150.8
mean	176.92	168.6	175.2	125.6
stdev	27.07	38	200.4	252
tc	2.23		155	116.6
st err of mean	13.33			197.8
margin of Error E	29.7		225.2	187
mean difference	8.32		190	163.2
lower bound mean diff	-5.01		187.6	131.6
upper bound mean diff	38.02		156.4	137.4
			190.8	173.4
			134.2	168.2
				176.8
				211.2

			0.55