Statistics Coursework
This piece of coursework that I am doing is look at relations between height, weight, gender and Body mass index of Mayfield High School. I will do this by taking a sample of 118 out of 1183 students. The hypotheses I have to find out are the following:
. Boys are taller than girls
2. The taller you are the heavier you are
3. The more television you watch the larger the body mass index.
I will use the data given by my teacher and then do a stratified sample. I am doing the stratified sample so that I can get the right proportion sample for each year group. Using my calculator, I choose a random number between 1 and 10, and then go down for whatever number it is. For example, if the random number was 8 and there were 141 boys/girls in the year group I would choose the numbers 8, 18, 28, 38...38. Then I will use systematic sampling to get the right amount of people in each year group. The calculations for each year using the stratified sample are in the following:
Year 7 Girls: 131 x 118 ? 13
1183
Year 7 Boys: 151 x 118 ? 15
1183
Year 8 Girls: 125 x 118 ? 12
1183
Year 8 Boys: 145 x 118 ? 15
1183
Year 9 Girls: 143 x 118 ? 14
1183
Year 9 Boys: 118 x 118 ? 12
1183
Year 10 Girls: 94 x 118 ? 9
1183
Year 10 Boys: 106 x 118 ? 11
1183
Year 11 Girls: 86 x 118 ? 9
1183
Year 11 Boys: 84 x 118 ? 8
1183
For my pilot questionnaire the questions I will ask are:
. Are you male or female? Male ?
Female ?
2. What year group are you in? 7 ?
8 ?
9 ?
10 ?
11 ?
3. How tall are you? 1.0 - 1.2m ?
1.2 - 1.4 ?
1.4 - 1.6 ?
1.6 - 1.8 ?
1.8 - 2.0 ?
4. How much do you weigh? 20 - 40kg ?
41 - 60 ?
61 - 80 ?
81 - 100 ?
4. Approximately, how many hours of TV do you watch in a week?
0 - 10 hrs ?
1 - 20 ?
21 - 30 ?
31 - 40 ?
41 - 50 ?
51 - 60 ?
Sample
Year Group
Surname
Forename 1
Average number of hours TV watched per week
Height (m)
Weight (kg)
Gender
BMI
7
Anderson
Kylie
4
.42
41
Female
20.33326721
7
Brown
Nealey
21
.63
50
Female
8.81892431
7
Coleman
Jenifer
8
.42
34
Female
6.86173378
7
Dean
Elizabeth
7
.55
50
Female
20.81165453
7
Hartnett
Sarah-Jane
22
.41
39
Female
9.61671948
7
Jackson
Julie
0
.41
40
Female
20.11971229
7
Kenny
Jennifer
4
.64
40
Female
4.87209994
7
Marton
Jan
26
.50
52
Female
23.11111111
7
Murphy
Kim
8
.36
44
Female
23.78892734
7
Platt
Sarah
4
.50
47
Female
20.88888889
7
Smith
Karan
38
.42
29
Female
4.38206705
7
Vickers
Holly
8
.60
57
Female
22.265625
7
Garvey
Francesca
8
.63
60
Female
22.58270917
7
Ahmoud
Asif
57
.42
26
Male
2.89426701
7
Billal
Hamza
9
.36
45
Male
24.32958478
7
Burrow
Daniel
20
.46
53
Male
24.86395196
7
Cohen
Neil
7
.55
38
Male
5.81685744
7
Dawson
James
20
.43
33
Male
6.13770845
7
Gwerm
Matthew
6
.62
50
Male
9.05197378
7
Hughes
Anthony
4.5
.44
42
Male
20.25462963
7
Khan
Jamal
3
.63
60
Male
22.58270917
7
Madden
Ben
0
.47
47
Male
21.75019668
7
McCally
Simon
25
.45
31
Male
4.74435196
7
Parker
Fred
0
.53
48
Male
20.504934
7
Sammy
Singh
30
.52
54
Male
23.37257618
7
Spencer
Joshua
22
.72
75
Male
25.35154137
7
Thorpe
Billy
7
.53
40
Male
7.087445
7
White
Dean
21
.55
45
Male
8.73048907
8
Bailey
Mellisa
4
.75
72
Female
23.51020408
8
Blackburn
Suzanne
26
.60
46
Female
7.96875
8
Castle
Natalie
4
.50
45
Female
20
8
Dixon
Ayeshia
7
.55
60
Female
24.97398543
8
Green
Claire
42
.62
53
Female
20.19509221
8
Healy
Emily
3
.67
42
Female
5.05970096
8
Indera
Emily
24
.52
45
Female
9.47714681
8
Kelly
Julie
4
.61
60
Female
23.14725512
8
MacIntosh
Halie
4
.74
49
Female
6.18443652
8
Moloney
Erin
24
.62
51
Female
9.43301326
8
Patel
Stephanie
25
.65
49
Female
7.99816345
8
Spencer
Kerry
9
.59
55
Female
21.75546853
8
Anderson
Paul
24
.67
52
Male
8.64534404
8
Borage
Frank
20
.74
45
Male
4.86325803
8
Casy
Matthew
4
.67
51
Male
8.28677973
8
Drago
William
7
.66
43
Male
5.60458702
8
Eagle
David
6
.53
45
Male
9.22337562
8
Hague
Anthony
3
.75
80
Male
26.12244898
8
Jarvel
Kenneth
4
.66
46
Male
6.69327914
8
Lall
Alex
3
.55
68
Male
28.30385016
8
Martin
Todd
30
.50
52
Male
23.11111111
8
Morris
James
7
.65
35
Male
2.85583104
8
Pritchard
Gareth
7
.74
61
Male
20.14797199
8
Shane
Christopher
56
.54
42
Male
7.70956316
8
Thomas
Jonathan
20
.60
74
Male
28.90625
8
Walker
John
7
.56
50
Male
20.54569362
9
Ali
Hannah
3
.62
52
Female
9.81405274
9
Bennett
Susan
20
.6
41
Female
6.015625
9
Brown
Caroline
37
.59
48
Female
8.98659072
9
Campbell
Nichole
.57
62
Female
25.15315023
9
Davies
Davina
7
.55
52
Female
21.64412071
9
Green
Sahara
21
.54
54
Female
22.76943835
9
Higgins
Jade
21
.57
48
Female
9.47340663
9
Jones
Carly
39
.51
48
Female
21.05170826
9
Langtle
Rebekah
7
.51
65
Female
28.5075216
9
McDonald
Louise
8
.59
46
Female
8.19548277
9
Packham
Amanda
24
.65
49
Female
7.99816345
9
Roberts
Sarah
24
.54
45
Female
8.97453196
9
Singh
Karam
2
.49
40
Female
8.01720643
9
Taylor
Bethany
8
.52
48
Female
20.77562327
9
Armarnio
Vintchenzo
21
.67
54
Male
9.36247266
9
Bravendere
Andrew
28
.62
40
Male
5.24157903
9
Dakir
Azhar
4
.55
47
Male
9.56295525
9
Glenn
Edward
20
.48
40
Male
8.26150475
9
Haugh
Jason
20
.80
48
Male
4.81481481
9
Itus
Arthur
0
.76
55
Male
7.75568182
9
Key
Ben
2.5
.58
51
Male
20.42941836
9
Malone
Kyle
30
.48
40
Male
8.26150475
9
Nevaps
Luap
20
.53
50
Male
21.35930625
9
Saturn
Perry
7
.72
62
Male
20.9572742
9
Theodopolopodus
Gustafina
30
.60
55
Male
21.484375
9
Abejuro
Herman
42
.60
60
Male
23.4375
0
Ali
Aisha
6
.52
45
Female
9.47714681
0
Bolton
Margarette
26
.62
48
Female
8.28989483
0
Chayse
Erica
2
.79
52
Female
6.22920633
0
Fisher
Emma
0
.53
51
Female
21.78649237
0
Hamilton
Jo
5
.73
65
Female
21.71806609
0
Kevill
Jaide
1
.57
48
Female
9.47340663
0
Mitha
Selina
This piece of coursework that I am doing is look at relations between height, weight, gender and Body mass index of Mayfield High School. I will do this by taking a sample of 118 out of 1183 students. The hypotheses I have to find out are the following:
. Boys are taller than girls
2. The taller you are the heavier you are
3. The more television you watch the larger the body mass index.
I will use the data given by my teacher and then do a stratified sample. I am doing the stratified sample so that I can get the right proportion sample for each year group. Using my calculator, I choose a random number between 1 and 10, and then go down for whatever number it is. For example, if the random number was 8 and there were 141 boys/girls in the year group I would choose the numbers 8, 18, 28, 38...38. Then I will use systematic sampling to get the right amount of people in each year group. The calculations for each year using the stratified sample are in the following:
Year 7 Girls: 131 x 118 ? 13
1183
Year 7 Boys: 151 x 118 ? 15
1183
Year 8 Girls: 125 x 118 ? 12
1183
Year 8 Boys: 145 x 118 ? 15
1183
Year 9 Girls: 143 x 118 ? 14
1183
Year 9 Boys: 118 x 118 ? 12
1183
Year 10 Girls: 94 x 118 ? 9
1183
Year 10 Boys: 106 x 118 ? 11
1183
Year 11 Girls: 86 x 118 ? 9
1183
Year 11 Boys: 84 x 118 ? 8
1183
For my pilot questionnaire the questions I will ask are:
. Are you male or female? Male ?
Female ?
2. What year group are you in? 7 ?
8 ?
9 ?
10 ?
11 ?
3. How tall are you? 1.0 - 1.2m ?
1.2 - 1.4 ?
1.4 - 1.6 ?
1.6 - 1.8 ?
1.8 - 2.0 ?
4. How much do you weigh? 20 - 40kg ?
41 - 60 ?
61 - 80 ?
81 - 100 ?
4. Approximately, how many hours of TV do you watch in a week?
0 - 10 hrs ?
1 - 20 ?
21 - 30 ?
31 - 40 ?
41 - 50 ?
51 - 60 ?
Sample
Year Group
Surname
Forename 1
Average number of hours TV watched per week
Height (m)
Weight (kg)
Gender
BMI
7
Anderson
Kylie
4
.42
41
Female
20.33326721
7
Brown
Nealey
21
.63
50
Female
8.81892431
7
Coleman
Jenifer
8
.42
34
Female
6.86173378
7
Dean
Elizabeth
7
.55
50
Female
20.81165453
7
Hartnett
Sarah-Jane
22
.41
39
Female
9.61671948
7
Jackson
Julie
0
.41
40
Female
20.11971229
7
Kenny
Jennifer
4
.64
40
Female
4.87209994
7
Marton
Jan
26
.50
52
Female
23.11111111
7
Murphy
Kim
8
.36
44
Female
23.78892734
7
Platt
Sarah
4
.50
47
Female
20.88888889
7
Smith
Karan
38
.42
29
Female
4.38206705
7
Vickers
Holly
8
.60
57
Female
22.265625
7
Garvey
Francesca
8
.63
60
Female
22.58270917
7
Ahmoud
Asif
57
.42
26
Male
2.89426701
7
Billal
Hamza
9
.36
45
Male
24.32958478
7
Burrow
Daniel
20
.46
53
Male
24.86395196
7
Cohen
Neil
7
.55
38
Male
5.81685744
7
Dawson
James
20
.43
33
Male
6.13770845
7
Gwerm
Matthew
6
.62
50
Male
9.05197378
7
Hughes
Anthony
4.5
.44
42
Male
20.25462963
7
Khan
Jamal
3
.63
60
Male
22.58270917
7
Madden
Ben
0
.47
47
Male
21.75019668
7
McCally
Simon
25
.45
31
Male
4.74435196
7
Parker
Fred
0
.53
48
Male
20.504934
7
Sammy
Singh
30
.52
54
Male
23.37257618
7
Spencer
Joshua
22
.72
75
Male
25.35154137
7
Thorpe
Billy
7
.53
40
Male
7.087445
7
White
Dean
21
.55
45
Male
8.73048907
8
Bailey
Mellisa
4
.75
72
Female
23.51020408
8
Blackburn
Suzanne
26
.60
46
Female
7.96875
8
Castle
Natalie
4
.50
45
Female
20
8
Dixon
Ayeshia
7
.55
60
Female
24.97398543
8
Green
Claire
42
.62
53
Female
20.19509221
8
Healy
Emily
3
.67
42
Female
5.05970096
8
Indera
Emily
24
.52
45
Female
9.47714681
8
Kelly
Julie
4
.61
60
Female
23.14725512
8
MacIntosh
Halie
4
.74
49
Female
6.18443652
8
Moloney
Erin
24
.62
51
Female
9.43301326
8
Patel
Stephanie
25
.65
49
Female
7.99816345
8
Spencer
Kerry
9
.59
55
Female
21.75546853
8
Anderson
Paul
24
.67
52
Male
8.64534404
8
Borage
Frank
20
.74
45
Male
4.86325803
8
Casy
Matthew
4
.67
51
Male
8.28677973
8
Drago
William
7
.66
43
Male
5.60458702
8
Eagle
David
6
.53
45
Male
9.22337562
8
Hague
Anthony
3
.75
80
Male
26.12244898
8
Jarvel
Kenneth
4
.66
46
Male
6.69327914
8
Lall
Alex
3
.55
68
Male
28.30385016
8
Martin
Todd
30
.50
52
Male
23.11111111
8
Morris
James
7
.65
35
Male
2.85583104
8
Pritchard
Gareth
7
.74
61
Male
20.14797199
8
Shane
Christopher
56
.54
42
Male
7.70956316
8
Thomas
Jonathan
20
.60
74
Male
28.90625
8
Walker
John
7
.56
50
Male
20.54569362
9
Ali
Hannah
3
.62
52
Female
9.81405274
9
Bennett
Susan
20
.6
41
Female
6.015625
9
Brown
Caroline
37
.59
48
Female
8.98659072
9
Campbell
Nichole
.57
62
Female
25.15315023
9
Davies
Davina
7
.55
52
Female
21.64412071
9
Green
Sahara
21
.54
54
Female
22.76943835
9
Higgins
Jade
21
.57
48
Female
9.47340663
9
Jones
Carly
39
.51
48
Female
21.05170826
9
Langtle
Rebekah
7
.51
65
Female
28.5075216
9
McDonald
Louise
8
.59
46
Female
8.19548277
9
Packham
Amanda
24
.65
49
Female
7.99816345
9
Roberts
Sarah
24
.54
45
Female
8.97453196
9
Singh
Karam
2
.49
40
Female
8.01720643
9
Taylor
Bethany
8
.52
48
Female
20.77562327
9
Armarnio
Vintchenzo
21
.67
54
Male
9.36247266
9
Bravendere
Andrew
28
.62
40
Male
5.24157903
9
Dakir
Azhar
4
.55
47
Male
9.56295525
9
Glenn
Edward
20
.48
40
Male
8.26150475
9
Haugh
Jason
20
.80
48
Male
4.81481481
9
Itus
Arthur
0
.76
55
Male
7.75568182
9
Key
Ben
2.5
.58
51
Male
20.42941836
9
Malone
Kyle
30
.48
40
Male
8.26150475
9
Nevaps
Luap
20
.53
50
Male
21.35930625
9
Saturn
Perry
7
.72
62
Male
20.9572742
9
Theodopolopodus
Gustafina
30
.60
55
Male
21.484375
9
Abejuro
Herman
42
.60
60
Male
23.4375
0
Ali
Aisha
6
.52
45
Female
9.47714681
0
Bolton
Margarette
26
.62
48
Female
8.28989483
0
Chayse
Erica
2
.79
52
Female
6.22920633
0
Fisher
Emma
0
.53
51
Female
21.78649237
0
Hamilton
Jo
5
.73
65
Female
21.71806609
0
Kevill
Jaide
1
.57
48
Female
9.47340663
0
Mitha
Selina