• 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. ## Statistics Coursework

Female Mean Weight - 2566.64/47 = 54.61Kg (to 2 d.p.) * As you can see, the mean male height and male weight are higher than their respective female counterparts. This supports my second sub-hypothesis that males will on average, be taller and weigh more than females.

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

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. ## GCSE Physics Coursework

Evaluation: My method was safe, clear and fair as the experiment was carried out fairly accurately. However I did receive one anomalous result which was when the weight of the load was 2N. 2N was an anomalous result as it should have been approximately between 16mm and 18mm.

2. ## Statistics coursework Edexcell

16?X<18 17 4 6 18?X<20 19 2 8 20?X<22 21 1 9 22?X<24 23 2 11 24?X<26 25 0 11 26?X<28 27 3 14 28?X<30 29 1 15 30?X<32 31 1 16 Table 23 Year nine boys BMI Midpoint Frequency Cumulative Frequency 12?X<14 13 0 0 14?X<16 15 0 0

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

I did this separately for each category to obtain the numbers, and as the data was in an Excel spreadsheet it was easy to see which records the generator would be referring to. Investigating the Main Hypothesis: After obtaining my sample, I used Excel to create a scatter graph comparing

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