• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Statistics Maths Coursework - Mayfield High School

Extracts from this document...

Introduction

Statistics Coursework

Statistics Maths Coursework

Introduction:

Mayfield School is a secondary school of 1183 pupils aged 11-16 years of age. For my statistics coursework I am going to do an investigation about a sample of Mayfield High School which will include 1183 students.

Task One:

I will investigate the relationship between the IQ and the English and Maths KS2 Sats results. I have chosen the sample size 100 as it is an easy number and as it is a large number the results will be more accurate and reliable; also the number is easy to work with. As there 1183 students it will be hard for me to find the relationship between all of them therefore I will do stratified sampling to get a certain amount of people from each year and then will find the relationship between them. Also by using stratified sampling I will be able to get the same proportion of students as in the school and this would also reflect the school very well as the scale is lowered and not the proportion.

Aim:  Does IQ have a greater affect on the Maths or English KS2 Sats results?

Hypothesis: I predict that IQ will have a greater affect on KS2 SATs Maths results than English.

Stratified sampling

 To do my stratified sampling I used this method:

Number of students in whole year

x sample size=Number of students from                                            

Number of Students in Key Stage        (100)        Each year

Year Group

No of Boys

No of Girls

Total

7

151

131

282

8

145

125

270

9

118

143

261

10

106

94

200

11

84

86

170

Year 7 Boys

151

Total amount of students needed

1183           x 100 = 13

...read more.

Middle

10

Abejurouge

Henry

Male

89

3

3

10

Bolt

Jim

Male

106

4

5

10

Chung

Jason

Male

109

5

5

10

Fisher

Daniel

Male

90

3

3

10

Javidson

Carlos

Male

109

4

5

10

Leach

Peter

Male

106

3

4

10

O'Dogg

Robert

Male

97

4

4

10

Roley

Sam

Male

101

4

3

10

Smith

John

Male

103

4

4

11

Ableson

Anbigale

Female

98

3

3

11

Biddle

Vicky

Female

104

4

5

11

Dawson

Jane

Female

101

5

5

11

Hakins

Danielle

Female

100

4

4

11

Kelly

Freda

Female

97

3

4

11

McMorrison

Victoria

Female

102

3

4

11

Rees

Bryony

Female

88

4

3

11

Armstrong

Simon

Male

113

4

4

11

Burges

Edward

Male

98

4

4

11

Dunne

Donald

Male

104

4

5

11

Horney

Anthony

Male

96

3

3

11

Lee

Brett

Male

113

5

5

11

Nadeem

Ammad

Male

78

2

2

11

Simmons

Russell

Male

108

5

5

After I had worked out how many pupils I need for each year by using random stratified sampling I then took my samples from the Mayfield High School database and pasted into a new spreadsheet. As I got the data I firstly sorted it out using the sort option on Microsoft Excel e.g. I set the year group column as ascending this meant that the data would show Yr 7 first then Yr 8 etc. Next I sorted the gender column out this was so that in all the years male and females were separated this helped me as then I could easily take my samples. After I had sorted out my samples I then picked out the amount I needed from each year and gender and but them into a spreadsheet. I also deleted the columns with information that I did not need e.g. the height, weight eye colour etc.

Next I highlighted the data I wanted to make a graph with and then selected the chart wizard button I then selected the chart type I wanted (scatter graph), clicked next and then labelled the axis so it was easy to see what the chart was showing and then finally I clicked OK to create the graph.  

...read more.

Conclusion

Standard deviation for females

4950.5 / 49 = 101.03 > square rooted = 10.051

Standard deviation for males

13801 / 51 = 270.6 > square rooted = 16.445

Gender

Male

Female

Mean IQ

98.481

102.9

Mean Maths

4.078

4.265

Standard Deviation

16.445

10.051

Analysis

By looking at my results it is clearly visible that the girls had a higher mean IQ (102.9) compared to the boys (98.481) and a higher mean maths result (4.265) compared to the boys (4.078) this clearly shows that the girls are more intelligent. Also the standard deviation shows that the value is much lower for girls (10.051) compared to the boys (16.445) this shows that the girls are consistent and the boys are less consistent as they have a higher standard deviation.

I have proven my second hypothesis to be correct as I predicted the students with the highest IQ and the lowest spread (standard deviation) would have the highest maths Sats result. Clearly from the table above you can see that the girls had a higher IQ result and also a smaller spread and they did get a better Sats maths result compared to the boys.

Conclusion:

Overall, I have found out that having a higher IQ result does generally suggest that the pupil will achieve a higher KS2 Sats score. In addition, I have found out that IQ has a little more affect of 0.023 on Maths than English meaning that pupils who get a higher IQ score are more likely to get a higher level in their Maths Sats Test.

In addition, I have found out that overall girls have the highest IQ levels and also have a less spread (standard deviation) and therefore achieved a better score in their Maths Sats test than boys.

...read more.

This student written piece of work is one of many that can be found in our GCSE Height and Weight of Pupils and other Mayfield High School investigations section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Height and Weight of Pupils and other Mayfield High School investigations essays

  1. Edexcel GCSE Statistics Coursework

    I will know if a result is anomalous if it does not fit the pattern of the rest of the data, if I do come across an anomalous piece of data, I shall choose another piece of data using random sampling.

  2. Maths Statistics Coursework - relationship between the weight and height

    This brings to the conclusion of constructing a box and whisker to clarify that statement. This is a box and whisker plot showing the boxes for the boys, girls and both/mixed. If I compare the boxes for the girls' heights and the boys' heights I can see that the boys' box is much smaller than the girls' one.

  1. GCSE Physics Coursework

    This means that my second prediction did not come true which was (if you double the weight of the load so the amount of deflection also doubles). I can prove that this is did not come true. It is shown on my graph and the table below.

  2. GCSE Maths Statistics Coursework

    I will use cumulative frequency graphs to show the spread of data, box plots will be used to compare the results more easily. And cumulative frequency tables will be used to get the data to plot on the cumulative frequency graphs.

  1. Mayfield School Mathematics Statistics Coursework

    Therefore, since positive correlation is clearly indicated by the scatter diagram, I can conclude that there is a link between ability in Maths and ability in Science. For all intents and purposes, having now established, on the basis of my sample of 30 students, that there is a link between

  2. Statistics Coursework

    Weights * As you can see from the diagrams, the lowest weight of the males (39kg) is higher than that of the females (37kg). This supports my second sub-hypothesis, as I believed that trends such as this would be observed.

  1. Maths Coursework. Statistics

    My data that I used North America Countries Male Female Money Barbados 69.51 73.81 $15,700 Cayman Island 77.21 82.45 $35,000 Guatemala 64.30 66.13 $04,100 Haiti 50.52 53.12 $01,600 Honduras 64.99 67.37 $02,600 Nicaragua 67.99 72.16 $02,300 Saint Lucia 69.78 77.16 $05,400 United States 75.84 80.83 $37,800 Total 540.14 � 573.03

  2. Statistics coursework - hypotheses based on students statistics

    Standard deviation for year 9 = 0.09 Standard deviation for year 11 = 0.08 For this hypothesis I cannot use Spearman's Coefficient of Rank Correlation since I have not done a scatter graph. After studying my graphs it can be seen that my hypothesis of year 11 students being taller than year 9 students is correct.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work