Using the data from Mayfield High School, I am going to be investigating the relationship between IQ level and Key Stage 2 results.

Using the data from Mayfield High School, I am going to be investigating the relationship between IQ level and Key Stage 2 results. I would expect to find that people with higher IQ will have higher KS2 results. I am going to take a random stratified sample of 60 students; this will enable me to take a proportional amount of pupils from each year group. To do this calculation I needed to find the number of people in each year group then divide it by the total number of people in the school, after you have done this you need to multiply it by the size of your stratified sample.

So my calculation for the number of students I need from year 7 would be: 282/1183*60=14.3… as this is a decimal answer I will have to round it off to the nearest whole number. As mine is 14.3 I will round it own to 14.

This table shows me how many pupils I need from each year group. To start off with I gave each student a number from 1 – 1183, I then sorted the data into year groups and then I generated a random number between 1 –1183 using my calculator.

In order to see if there is any relationship between Key Stage 2 results and IQ I am going to draw scatter diagrams. I will draw a scatter diagram for the entire school as well as one for each year group. I am doing this so that I can see if the correlation is the same across the year groups. I think that year 7 will have a stronger positive correlation than year 11, because I think that as the years go on people are getting smarter. So a new year 7 may have had better key stage results than a current year 11.

I will now find the averages for IQ and KS2 for each year then the entire school.

Averages… IQ…

To get the average IQ I added up all the IQ’s in the certain year and then divided the total by the number of students in my sample in that year.

Year 7 = 1416 / 14 = 101.1

Year 8 = 1416 / 14 = 101.1

Year 9 = 1291 / 13 = 99.3

Year 10 = 1004 / 10 = 100.4

Year 11 = 930 / 9 = 103.3

All years = 6057 / 60 ...