• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Investigate the correlation between various sets of information from a database of pupils from Mayfield High School.

Extracts from this document...


Maths Statistics Coursework


In this project I will investigate the correlation between various sets of information from a database of pupils from Mayfield High School. I will try to spot correlation between two different sets of information. I will pick only sets of information that I predict to show good correlation, and therefor tell me something about the data. Example, I will be able to say that girls are more intelligent that boys or vice versa if the correlation shows that to be.


In this investigation I am going to look into the correlation between Key Stage 3 results and IQ test scores of years 10 and 11 pupils, for both boys and girls separately.

Because there is such a large selection of pupils it would be impossible to compare them all, so I took a random selection of 30 pupils. In truth, it isn't really a fully random decision as I have chosen 15 boys and 15 girls. I didn't use a stratified sample because you obviously cannot have 14.7 pupils, and it was so close to 15. To solve this I took a random selection of 50 boys and 50 girls and picked 15 of each from a hat.

...read more.


5 - 6



I encountered a problem whilst investigating into cumulative frequency charts and that was that Key Stage 3 results are a discrete form of data. To overcome this I made a mean of the 3 results, English, Science and mathematics. This should give my graphs a better verity of results. I could also try a second table and graph of results using totals of KS3 results instead of means, this would make my graphs easier to decipher.

IQ Scores

Cumulative frequency for boys

Cumulative frequency for girls

















From my cumulative frequency curves I can see positive correlation between KS3 results and IQ scores. As a general trend I can say that the higher the KS3 result the higher the IQ. There is always 'outliers' to the trend, for instance a boy with the mean of 3 at KS3 and an IQ of 103. As a trend I can say that boys have a higher IQ and girls have a higher mean of KS3 results.

...read more.


I know that a line of best fit has its limitations, but I can use them to predict a mean KS3 result from any boy with a given IQ. I know that the equation of every straight line is y = mx + c . I must use this to find the equations of my lines of best fit. To do this I must look at the point where they intercept the y axis and find the gradients. ( Y = IQ , X = KS3 )

Boys : Y = 10x + 56

Girls : Y = 8x +68

I will now use this equation to find the result for a boy with an IQ of 102. If Y = 102 then….

102 = 10x + 56


X = 102 - 56


X = 4.6

So a boy with the IQ of 102 should have the mean KS3 result of 4.6, this means that he probably got to 5s and a 4, as 14 ? 3 = 4.6 reoccurring. I can now estimate any IQ from the KS3 mean or vice versa.

Mayfield High School obviously needs to look at the concentration of educational focus between boys and girls, as girls are achieving higher KS3 marks on average. Perhaps if I used a sample of national data I could investigate into the performance of Mayfield High against national means.

...read more.

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

See related essaysSee related essays

Related GCSE Height and Weight of Pupils and other Mayfield High School investigations essays

  1. mayfield high statistics coursework

    BOYS WEIGHT BOYS Weight(kg) Cumulative Frequency Less than 40 4 Less than 50 11 Less than 60 17 Less than 70 20 Less than 80 20 From this particular Cumulative Frequency Diagram I have been able to find that the average weight from the sample that I have taken is 60kg which I my

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

    From doing scatter graphs for year 7 students I have learnt that separating boys and girls gives you much better correlation and so I will have clearer information on whether there is any relationship between height and weight. So this time for year 11 student I will not waste time

  1. Mayfield High Statistics Coursework

    x 25 = 3 Year 10 boys = 106/1183 x 25 = 2 Year 10 girls = 94/1183 x 25 = 2 Year 11 boys = 84/1183 x 25 = 2 Year 11 girls = 86 / 1183 x 25 = 2 Now I know how much of each year group and gender I will use.

  2. Mayfield High. I will set about carrying out various test in order to come ...

    99 3 3 3 3 100 4 4 4 4 93 3 3 4 3.333333333 110 4 4 4 4 90 3 3 3 3 103 4 4 5 4.333333333 105 5 5 4 4.666666667 97 3 3 3 3 92 3 3 3 3 104 4 4 4 4

  1. Statistics Mayfield High

    min 87 LQ 96.5 80.75 =LQ - (1.5*IQR) median 100 IQR 10.5 Outliers 15.75 UQ 107 122.75 =UQ + (1.5*IQR) max 114 The girl's box plot has minimum and maximum values of 88 and 124 respectively. The median is 102.5, the LQ is 100 and the UQ is 109.75: the IQR being 9.75.

  2. Handling Data - Mayfield High School

    3 3 50 31 104 4 4 4 4 Scatter graph to show relationship between Key Stage 2 results and IQ There is good evidence to support my hypothesis that there is a strong positive correlation between IQ and Key Stage 2 results.

  1. Maths Statistics Coursework: Mayfield High

    10 1.56 56 11 1.91 82 11 1.65 54 11 1.51 40 11 1.65 42 11 1.78 67 11 1.68 48 11 1.86 80 11 1.61 54 As I need a more useful representative of the data shown above, I have decided to sort my data out and put it into height and weight frequency tables.

  2. Mayfield School Mathematics Statistics Coursework

    any student granted a 0 in Maths and a 0 in Science would have been absent on the day and therefore these values will only distort my analysis. So, to start, I will initially calculate the measures of spread and location listed in the table below: Maths Science Mean 4

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