Mayfield High school

Authors Avatar


Mayfield High School Coursework

In this investigation I have compared IQ and KS2 results of Mayfield high school to see if there is any relationship between these two factors. I have also planned to show how I have carried out my investigation.

I have been given a dataset of 1200 students of Mayfield High School as held in our school computers and home computers, from which I have chosen a random sample of 30 students. To help me in my coursework I have used Microsoft Excel as it is the most appropriate software to use. I have generated a random sample using Microsoft Excel and I have used this software to generate all my graphs, tables, and box and whisker diagrams.

I have used the data from the computer because it is easy to collect the data from there to avoid logistical problems and time consuming problems.

My hypothesis / prediction:

‘My prediction is that the higher the IQ the higher the KS2 results will be.’

How I will prove my prediction

To be able to prove my prediction I have worked out Mean, Median, Mode and Range using Steam and Leaf table. I have also worked out Cumulative Frequency and drawn Cumulative Frequency graphs to find out Median, Lower Quartile (Q1), Upper Quartile (Q3) and Inter Quartile range, and drawn box and whisker diagrams. Then I have compared these to comment on how these differ and spread of data. For example, box and whisker diagrams show the spread between Q1 and Q3.

I have compared IQ and KS2 results for Level 2, Level 3, Level 4 and Level 5 in Mathematics test and all these Levels in English as well.

I have drawn a conclusion which does prove my prediction that the higher the IQ the better the KS2 results are.

Samples

Level 2           Level 3     Level 4    Level 5      Level 6

Join now!

IQ Averages

Level 2

Level 3

Level 4

Level 5

Level 6

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 ...

This is a preview of the whole essay