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) x*P(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