Mayfield High school
Extracts from this document...
Introduction
Adnan Sarayqum Statistic Coursework 
Adnan Sarayqum 
Statistic Coursework 
Mayfield High School 
Mr Bailey [Pick the date] 
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)
Middle
27
97101

29
102106

30
Level 4
IQ  Frequency  Cumulative Frequency 
8993    2 
9498    7 
99103    23 
104108    27 
109113    29 
114118    30 
Level 5
IQ  Frequency  Cumulative Frequency 
101105    7 
106110    16 
111115    21 
116120    29 
121125    30 
Level 6
IQ  Frequency  Cumulative Frequency 
108114    3 
115121    6 
122127    8 
128134    9 
The minimum value  74 
The lower quartile  74.5 
The median  77 
The upper quartile  81.75 
The maximum value  86 
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
The minimum value  78 
The lower quartile  88 
The median  90.5 
The upper quartile  94 
The maximum value  102 
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
The minimum value  90 
The lower quartile  100 
The median  102 
The upper quartile  103 
The maximum value  116 
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
The minimum value  101 
The lower quartile  106 
The median  110 
The upper quartile  116 
The maximum value  121 
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
The minimum value  111 
The lower quartile  115 
The median  117 
The upper quartile  126.5 
The maximum value  131 
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
Extension
To develop my investigation and understanding, I have decided to do some widespread research. In the following section I will look at the data which states what IQ a person required to attain a level 4 KS2 result.
Conclusion
Evaluation
In terms of my expectations, it showed that the higher the IQ the higher the KS2 results proved to be a success because it matched my hypothesis. I had accurate data and made them onto tables, graph and box plots to test my hypothesis. My results were all clear and it was easy to originate a conclusion.
However, I did perceive some complications involving the investigation. The first problem being is some of the abnormal curves on my cumulative frequency graph. Instead of having a smooth and consistent line, some graph show irregularity (graph 1 level 2). This could have been due to two reasons. The first reason could be mistakes in the data. There could have been false information given. The second reason could be due to the small sample size of level 2 and level 6.
Although I have some anomalous results I still consider my data is to a certain extent accurate as it has helped me to prove my prediction. Furthermore I think my conclusions are reliable as I believe if I done this investigation again I will have similar results. I think my results are valid because I have similar results to my class members who have done the same investigation.
If I had the chance to conduct this investigation in the future. I would choose a larger sample size; this may eliminate the inconsistency in graphs.
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