• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4
5. 5
5
6. 6
6
7. 7
7
8. 8
8
9. 9
9
10. 10
10
11. 11
11
12. 12
12
13. 13
13
14. 14
14
15. 15
15
16. 16
16
17. 17
17
18. 18
18
19. 19
19
20. 20
20
21. 21
21
22. 22
22
23. 23
23
24. 24
24
25. 25
25
26. 26
26
27. 27
27
28. 28
28
29. 29
29
30. 30
30
31. 31
31
32. 32
32
33. 33
33
34. 34
34
35. 35
35
36. 36
36
37. 37
37
38. 38
38
39. 39
39
40. 40
40
41. 41
41
42. 42
42
43. 43
43
44. 44
44
45. 45
45
• Level: GCSE
• Subject: Maths
• Word count: 9664

# Mayfield High School

Extracts from this document...

Introduction

Introduction

I have chosen to compare the relationship between IQ and Key Stage 2 Results and my hypothesis is that the greater the person’s IQ, the better their Key Stage 2 will be. I will use scatter graphs to represent my data and to find out if my hypothesis is true. For the scatter graphs I will be drawing the lines of best fit, finding the equations of these lines and using this to compare. I will also be using cumulative frequencies and box and whisker diagrams to look at the interquartile range and the median. If my hypothesis is true, I expect to see a positive correlation.

Sampling the Database

For my whole database I will use stratified samples, where the samples reflect the proportions of the whole population. Therefore, the school is growing and there are more students in year 7 than year 11. This means, there are likely to be more year 7 students in the sample than year 11 students. To ensure that students from different age groups are equally represented my need to take this type of my sample. In a stratified sample my sample values from a particular group in proportion to that group's size within the whole population.

An example of a stratified sample in connection to Mayfield High School is shown below.

For example, I want to make a population of 60 from the population of 1183 shown below from Mayfield High School.

 Year Group Number Of Boys Number Of Girls Total 7 151 131 282 8 145 125 270 9 118 143 261 10 106 94 200 11 84 86 170

To get the proportion of any year you would have to do the following:

(Total for Chosen Proportion) ÷ (Overall Total) x (Sample Size)

The answer obtained tells you how many you would need to choose from your chosen proportion, and to choose this you would:

(Total for Chosen Proportion) ÷ Answer

Middle

This scatter graph shows female pupils’ IQ and Key Stage 2 Science results. It shows a median positive correlation which therefore means that the greater the IQ, the greater the average Key Stage 2 results are. The R² value relates to the how the average Key Stage 2 results are effected by the IQ. Here we see that the R² is 0.4374 which shows that 44% of the Key Stage 2 Science results are affected by the IQ.

All these scatter graphs for the female pupils support my hypothesis that the greater the IQ, the greater the Key Stage 2 results will be. Therefore, (as I predicted) you see a positive correlation.

I have now placed the equations of the line of best fit and the R² values of these scatter graphs into a table.

 Equation of line of best fit R² IQ/English Y=0.027x + 1.3621 0.1877 IQ/Maths Y=0.0499x – 0.9326 0.4017 IQ/Science Y=0.0521x – 1.1577 0.4374 IQ/Average KS2 Results Y=0.043x – 0.2428 0.55

By observing the gathered data in the table above, I noticed that the scatter graph showing the Key Stage 2 Science results are affected more by the IQ, than the Maths and English results.

The table also indicates through the R² value, that on average, around 55% of the Key Stage 2 results are affected by the IQ, which shows there is a median relationship between the average Key Stage 2 results and the IQ.

Now I will look at only the Year 7 subset.

 Year Group Years Gender IQ KS2 - English KS2 - Maths KS2 - Science AVERAGE 7 12 Male 106 5 5 4 4.67 7 12 Male 112 5 5 5 5.00 7 12 Male 103 4 5 4 4.33 7 12 Male 100 4 4 4 4.00 7 11 Male 97 3 4 4 3.67 7 12 Male 102 4 4 5 4.33 7 12 Male 103 4 5 5 4.67 7 11 Female 102 4 4 4 4.00 7 12 Female 116 4 4 4 4.00 7 12 Female 88 5 4 3 4.00 7 12 Female 103 4 4 5 4.33 7 12 Female 99 4 4 4 4.00 7 12 Female 106 4 5 5 4.67 AVERAGE 102.85 4.15 4.38 4.31

The following scatter graphs represent data from the Year 7 subset.

This is a scatter graph illustrating Year 7 pupils’ IQ and average Key Stage 2 results, with a weak positive correlation, which indicates that the greater the IQ, the greater the average Key Stage 2 results.  The R² value is 0.

Conclusion

Y = -0.0003x² + 0.1134x – 4.4287

If the IQ is 112, then the average Key Stage 2 result would be:

Y = -0.0003x² + 0.1134x – 4.4287

Y = (-0.0003 x 112²) + (0.1134 x 112) – 4.4287

Y = -3.7632 + 12.7008 – 4.4287

Y = 4.5089

However, when the IQ is 112 the actual average Key Stage 2 result is 5; the quadratic equation provided an answer which was 0.4911 less. Therefore, this shows the quadratic equation: Y = -0.0003x² + 0.1134x – 4.4287 is not as accurate as the linear equation.

Now I will investigate the reliability of these results by comparing another linear equation with a quadratic equation, but this time I will use the Key Stage 2 English results and IQ in the sample data from the population of 60.

Here the linear equation is: y = 0.0571x – 1.7348, with y representing the Key Stage 2 English results and x representing the IQ.

If the IQ is 112, then the average Key Stage 2 result would be:

Y = 0.0571x – 1.7348

Y = (0.0571 x 112) – 1.7348

Y = 6.3952 – 1.7348

Y = 4.6604

However, when the IQ is 112 the actual average Key Stage 2 result is 5; the linear equation provided an answer which was 0.3396 less. Therefore, this shows the linear equation: Y = 0.0571x – 1.7348 is quite accurate.

Now I will change the linear equation into a quadratic equation by changing the linear trend line to a polynomial trend line with an order of 2.

Y = 0.0015x² - 0.2564x + 14.533

If the IQ is 112, then the average Key Stage 2 result would be:

Y = 0.0015x² - 0.2564x + 14.533

Y = (0.0015 x 112²) - (0.2564 x 112) + 14.533

Y = 18.816 - 28.7168 + 14.533

Y = 4.6322

However, when the IQ is 112 the actual average Key Stage 2 result is 5; the quadratic equation provided an answer which was 0.3678 less. Therefore, this shows the quadratic equation: Y = 0.0015x² - 0.2564x + 14.533 is accurate but not as accurate as the linear equation.

Conclusion:

There is a positive correlation between the IQ and KS2 result both across the school as a whole and within each year group. This correlation appears to be stronger when individual year groups and separate genders are considered.

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. ## A hypothesis is the outline of the idea/ideas which I will be testing and ...

150?h<160 IIIIIIIII 9 155 1395 160?h<170 IIII 4 165 660 170?h<180 II 2 175 350 180?h<190 0 185 0 TOTAL 20 3130 Mean: 3130 Divided by 20 = 156.5 which is 157 cm = 1.57m Comparison of Mean of Girls & Boys (Height and Weight)

2. ## Mayfield. HYPOTHESIS 1: Boys at Mayfield School are Taller and Weigh more on ...

Weight Comparison: Most Boys and Girls weigh in the region of 40- 60 from my sample and I have found that not many girls are over the weight of 60 whereas in Males usually are borderline 60 or above when they come to the age of 16.

1. ## Conduct an investigation comparing height and weight from pupils in Mayfield School.

1 50 4 16 54 8 64 50 4 16 44 -2 4 38 -8 64 52 6 36 48 2 4 45 -1 1 50 4 16 44 -2 4 53 7 49 57 11 121 40 -6 36 40 -6 36 36 -10 100 45 -1 1 51

2. ## Liquid chromatography is a technique used to separate components of a mixture to isolate ...

overload at increasing concentration is the 100 � 4.6mm column of Genesis C18 300� 4�, with a surface area of 120m2/g and a pore volume of 1 cc/gm. Next to overload is the 100 � 4.6mm column of Kromasil C18 5�, with a surface area of 340m2/g and a pore volume of 0.9 cc/gm.

1. ## I would like to know whether there is a link between ability in Maths ...

Below is a table illustrating these values: Skewness Maths 0 Science 0.59 [Table 2: Coefficients Of Skewness] As previously suggested, this table does indeed confirm that in both cases there is little, if any, skewness in the data. I am pleased with this result because it therefore not only allows

2. ## Maths Data Handling

h < 160 3 155 24025 72075 160 ? h < 170 4 165 27225 108900 170 ? h < 180 5 175 30625 153125 180 ? h < 190 3 185 34225 102675 25 633225 Conclusion The heights of the boys in the sample representing the boys in the whole school appear to be far more spread out than the heights for boys in year 7 alone.

1. ## Mayfield maths courswork - is there a link between abilty in maths and abilty ...

I will now calculate the coefficient of skewness associated with each of these sets of results to confirm that there is indeed little skewness in the data. Below is a table illustrating these values: Skewness Maths 0 Science 0.59 [Table 2: Coefficients Of Skewness] As previously suggested, this table does

2. ## we can see if there is any correlation between a person's height and weight ...

= 1 - 6x18127 60� - 60 = 1 - 108762 215940 = 1 - 0.5036 = 0.4963 Round up = 0.5 By doing spearman's rank you see whether the you have a positive/negative correlation and if you have a strong/weak correlation between two pieces of information.

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