# Mayfield High School Data Handling Project

Extracts from this document...

Introduction

Mayfield High School Data Handling Project

Aim:

I am going to collect and express evidence to explore my hypothesis that:

Males have a higher IQ than females, in years 10-11

Then I am going to expand my investigation to explore the hypothesis that:

IQ affects Key Stage 3 Math’s results

I am only going to use data from Year 10 and 11 because I feel it is more relevant to myself.

Collecting the data:

For this investigation I am going to need to collect data from 60 sample students from years 10-11. The data I need will need will be IQ, Gender, Year, and Key Stage 3 Math’s Results. I will obtain the all this data from the Mayfield High database, this is a fictitious school but the data been based on a real school, means the evidence will be reliable and will be accurate enough for me to draw conclusions.

The database held information on a total of 1183 students, to analyze all the students would be very hard because there is too much data and graphs and diagrams. So I have decided to take a stratified random sample of 60 of the students in years 10-11.

To do the Stratified Random sample I will have to calculate the right number data on the boys and girls from each year, so that I get an accurate picture of the data from each year. To do this I will have to use the equation Boys/Girls over the total number in year 10 and 11, times by 60 (number of students wanted for investigation).

Stratifying Data:

Middle

32

0.64

X

86

55

0.741

X

86

41

0.054

X

86

5

Here is my sample of 30 boys and 30 girls

## Boys Girls

IQ | Math’s KS3 Results | IQ | Math’s KS3 Results |

107 | 5 | 112 | 5 |

113 | 5 | 100 | 4 |

78 | 3 | 116 | 4 |

94 | 3 | 107 | 4 |

90 | 3 | 106 | 5 |

109 | 5 | 96 | 4 |

110 | 5 | 96 | 3 |

113 | 5 | 99 | 4 |

86 | 4 | 100 | 4 |

100 | 4 | 100 | 4 |

116 | 5 | 87 | 3 |

90 | 3 | 119 | 5 |

90 | 4 | 105 | 4 |

106 | 4 | 102 | 4 |

102 | 4 | 100 | 4 |

91 | 3 | 120 | 4 |

89 | 4 | 101 | 3 |

114 | 4 | 108 | 4 |

112 | 6 | 98 | 3 |

96 | 5 | 88 | 3 |

121 | 3 | 100 | 4 |

106 | 3 | 110 | 5 |

80 | 3 | 97 | 3 |

98 | 3 | 101 | 4 |

122 | 5 | 94 | 3 |

118 | 5 | 103 | 3 |

113 | 5 | 97 | 3 |

88 | 3 | 104 | 3 |

100 | 3 | 96 | 3 |

100 | 4 | 107 | 4 |

For a more useful representation of the data that I have collected I have drawn up a Frequency table for all the data, gender, IQ, and KSY 3 Math’s results.

## Boys

Key Stage 3 Maths Result | Tally | Frequency |

2 | 0 | 0 |

3 | 1111 1111 1 | 11 |

4 | 1111 111 | 8 |

5 | 1111 1111 | 10 |

6 | 1 | 1 |

IQ | Tally | Frequency |

70 - 80 | 11 | 2 |

81 - 90 | 1111 1 | 6 |

91 - 100 | 1111 11 | 7 |

101 - 110 | 1111 1 | 6 |

111 - 120 | 1111 11 | 7 |

121 - 130 | 11 | 2 |

Girls

Key Stage 3 Maths Result | Tally | Frequency |

2 | 0 | 0 |

3 | 1111 1111 1 | 11 |

4 | 1111 1111 1111 | 15 |

5 | 1111 | 4 |

6 | 0 | 0 |

IQ | Tally | Frequency |

70 - 80 | 0 | 0 |

81 - 90 | 11 | 2 |

91 - 100 | 1111 1111 111 | 13 |

101 - 110 | 1111 1111 1 | 11 |

111 - 120 | 1111 | 4 |

121 - 130 | 0 |

## Math’s Key Stage 3 Results

I am now ready to begin comparing, and analyzing the data I have recorded by using diagrams.

Firstly I am going to begin by analyzing the data about Math’s KS3. Using bar charts I am going to compare the Frequency results for Boys and Girls.

Mean KYS 3 Math’s Results

## Mean KYS 3 Math’s Results for Boys = 116 - 30 = 3.86

## Mean KYS 3 Math’s Results for Girls = 113 - 30 = 3.76

## Modal KYS 3 Math’s Results

Modal KYS 3 Math’s Results for Boys = 3

## Modal KYS 3 Math’s Results for Girls = 4

Conclusion

We can see that there is a positive correlation between IQ and the pupils Key Stage 3 Math’s results. Suggesting that the result a student obtains in Key Stage 3 Math’s does depend on his IQ.

So basically we have proven that my second Hypothesis is right, with very little exceptions, only one main one a pupil with an IQ of over 120 got a result 3. As the scatter graph showed the majority of the pupils followed my hypothesis with the high results being obtained by the pupils with the higher IQ’s. I believe I can make the prediction, using the line of best fit, that for a pupil to obtain a 2 as their result they would have to have an IQ of 69.

We have seen that there is in fact a better correlation between the results when the two gender are compared speratley, with less points been off the line of best fit. There are however still exceptions, and we need to remember that that the line of best fit is only a best estimation of a relationship, in this case IQ and Key Stage 3 Math’s Results, and some values do fall outside the general trend set by the line of best fit.

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