• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
• Level: GCSE
• Subject: Maths
• Word count: 2535

# 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.

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

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

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.

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.

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

# 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. ## 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.

1. ## 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'.

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

The mean for the whole sample was 1.61m; the boys are 2cm more and the girls are 2 cm less. This also concludes the fact that the boys' average height is more than the girls. The range for the whole sample is almost the same as the boys which indicates

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. ## Is there a difference between male and female conversational styles in today's society?

This is because at the beginning the participants were too conscious of the tape recorder. The point at which I started transcribing is where I felt the discourse was most natural and spontaneous. The disadvantages of having tape recorded my data was the fact that you are unable to view

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