• 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. Mayfield School Mathematics Statistics Coursework

    ability in Maths and ability in Science, I have now fulfilled my aim and could conclude my project. However, having already separated my sample data into a male / female divide, I shall see whether the link between ability in Maths and ability in Science is in turn linked to gender.

  2. Mayfield High Statistics Coursework

    The first table show a representation of how many pupils make up a year. The second table samples each year to get a fair representation of the school by using the above formula. Cumulative Frequency and C.M graphs The cumulative frequency is obtained by adding up the frequencies as you go along, to give a 'running total'.

  1. Edexcel GCSE Statistics Coursework

    As I did not collect the statistics myself, I am left unaware as to whether or not they are reliable. I should be able to use all of the data, however, if there are any anomalous results I will discount them as they will disrupt and affect the pattern of the data.

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

    The inter-quartile range is the difference between the upper and lower quartiles which also tells me the spread of data. The upper and lower quartiles are almost the same which indicates to me that there is a similar spread of data.

  1. Maths Statistics Coursework

    Yr 8 girls I have rounded the number up to 16. I will take 16 samples of data from year 8 girls. Year 9 boys I have rounded the number up to 15. I will take 15 samples of data from year 9 boys.

  2. Mayfield Maths Coursework

    * The pupil's FAVOURITE SPORT: This again will not have a manipulative input on the child's IQ. * The pupil's FAVOURITE TV PROGRAM: This will only depend on the child's age and it will have very little correction. * The pupil's AVERAGE NO.

  1. GCSE Maths Coursework: Statistics Project

    In this piece of coursework, I want to find out whether this is correct. I will do this by completing a number of graphs. YEAR 10 GIRLS Height (cm) Weight (Kg) 1.40 35 1.41 40 1.52 45 1.53 45 1.53 45 1.53 45 1.55 46 1.56 48 1.57 48 1.62

  2. The aim of the statistics coursework is to compare and contrast 2 sets of ...

    no data in one of the fields and also I would probably pick a wider amount of data.

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