• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  • Level: GCSE
  • Subject: Maths
  • Word count: 3205

Mayfield data handling

Extracts from this document...



For this piece of coursework, I’m going to look at Mayfield High School. I was given data on Key stage 2 subject results. There were 19 spreadsheet pages of data which had the number, Year Group, gender, IQ and KS2 subject results of the students who attend Mayfield High School.

Statistical information shows that there are 1,183 students in total, of which there are:                                282 students in Year 7                                                                                                                                                                 270 students in Year 8                                                                                                                            261 students in Year 9                                                                                                                            200 students in Year 10                                                                                                                           170 students in Year 11.                                                                                                                            Also the statistics show that 4 students in Mayfield High School achieved KS2 level 0                                                                                                                            17 students achieved KS2 level 2                                                                                                                            246 students achieved KS2 level 3                                                                                                                            552 students achieved KS2 level 4                                                                                                                            345 students achieved KS2 level 5                                                                                                                            19 students achieved KS2 level 6.

My assignment was to look at correlation between the IQ and the KS2 results. In order to find out the relationship between the two variables, I will be looking at a random sample of students in Mayfield High School in terms of their IQ and their KS2 results in Math.


The key relationship I will be looking at is:

The relationship between the IQ and the KS2 results in Math.

I predict that:

  1. Students who have low IQ’s will have a lower KS2 result.
  2. While the IQ increases the KS2 results for maths will also increase.
  3. Students who have low IQ’s but work hard will have higher KS2 results than students who have high IQ’s.

Collecting the information

The variables linked with my hypotheses are the IQ’s and the KS2 Math results of students in Mayfield High School. This information will represent the whole school of Mayfield High School, taking account of all five year groups and all the results from level 0-6.

...read more.


A SELECTIVE sample is one which every nth term is chosen, where n is selected at random e.g. taking every 10th piece of data.

A STRATIFIED sample is one which the population is divided into groups called strata and each stratum is randomly selected.

A RANDOM sample is one in which each member of the population is equally likely to be selected.

I will use a RANDOM sample; this is because I want every student in Mayfield High School to have an equal chance to be selected.

The initial sample that I will use to look at is 15 students, regardless of gender, from each KS2 results. In order for me to do this, I used the random button on my scientific calculator to get random numbers of students. The calculation I used was: Total number of students to be sampled × SHIFT Ran# = Keep pressing the = button to get another random number.

Recording the Data

Below are the randomly selected students with their IQs:


Below shows the Frequency and the Cumulative Frequency table of the IQs:


I used a table to record the IQs of all the KS2 results, I then calculated and conducted a cumulative frequency table. Afterwards, I used my data to plot cumulative graphs to find out accurately the Lower-Quartile, Upper quartile, Inter-Quartile Range and the Median. In the end, I drew box and whisker plots on one scale so I could easily analyse the data.

The tables show the IQs for each KS2 results, the mean is the weighted average and is worked out by the sum of frequency multiplied by the mid points of each class. The formula is ?fx divided by the sum of all the frequencies.


Level 2

...read more.




Overall, girls had a lower lower-bound of 95, a lower lower-quartile of 102.5, a lower median of 106.25, a lower upper-quartile of 110, a lower upper-bound 0f 121 and a lower mean of 107.1. Basically, we can see that there is a consistent pattern of boys doing better at all the factors of data handling.


My hypothesis was correct; I predicted that boys will do better. One reason why my hypothesis is correct is because I used my knowledge of my first extension to influence my hypothesis. This extension suggests that boys are really doing better than girls and outpacing them. However, it doesn’t mean that all boys around the country are doing better than girls in secondary; we’re just looking at on e school so we can’t assume that my findings somehow portray the performance of genders in schools.


I think I found sufficient information from Mayfield High School to deduct that boys are doing better. One reason why this assignment was quite easy was because I did a similar project for my Sociology coursework, thus, I applied my previous knowledge to this assignment. However, one thing that confused me was how to calculate the stratified sample, in Sociology, when I studied types of samples, we had slightly different meanings - so I was a bit lost in this section.

If I had to do this project again, I would use histograms and present my findings much neater. Due to insufficient time and lack of knowledge on how to do graphs on Microsoft excel limited the creativity of my work.

On the whole, at first I was confused about this assignment but then as I started working on it, the project made sense and I began to get the hand of it.

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

    firstly find the mean and the average IQ Level of the Data that I have chosen and also the average number of hours of TV watched per student. Mean IQ of Student in my sample I will now find the Mean, Mode of the Frequency that I have found and

  2. Informal vs. formal speech.

    S has joined the group a few years later. Regarding these social bonds this conversation will now be analyzed under the characteristics by Tannen. Starting off with the different communicative strategies which make up the speaker's own style - distance, deference and camaraderie - the first conversation example will be analysed.

  1. Statistics coursework - hypotheses based on students statistics

    Height (m) Tally Frequency 140-144 I 1 145-149 II 2 150-154 IIII I 5 155-159 IIII III 7 160-164 IIII III 7 165-169 I 1 170-174 I 1 175-179 0 180-184 III 3 Height (m) Tally Frequency 140-144 0 145-149 0 150-154 0 155-159 III 3 160-164 IIII 4 165-169

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

    5 9 Female 5 5 7 Female 4 5 7 Male 3 3 9 Female 4 4 7 Female 4 4 7 Female 4 4 7 Male 3 4 9 Female 4 4 8 Female 5 4 9 Female 0 0 8 Male 4 5 8 Female 5 5 8

  1. Maths Data Handling

    The number that shows up on the calculator screen will be the pupil number (shown in Microsoft Excel), which will be selected to be in my sample. I will do this eleven times for Year 7 Girls. I will repeat this method for each Year Group and gender.

  2. Maths newspaper data collection project

    1 16 1 7 17 2 1 1 18 2 1 2 19 5 1 2 1 20 4 2 1 21 1 1 22 5 3 1 23 1 4 1 24 1 1 1 25 3 2 3 1 26 3 1 1 27 2 28 1 2

  1. Sport Research project - write a report for John Whittaker detailing different types of ...

    If the data set has an even number of entries, add the two middle values and divide by two. Mode Data: The mode is the value that occurs most frequently in the data set. To find the mode you have to count how many times each value appears and the value that appears most is the mode.

  2. This Investigation is to see if there is a correlational relationship between individuals G.C.S.E ...

    3.3 covariance 0.35074 SDx 0.68677 SDy 1.03233 PPMCC= 0.49472 Necessary Calculations SDx = Sdy = Covarience = P.P.M.C.C = Hypothesis Test Ho: =0 The null hypothesis is that there will be no relationship between academic achievement at G.C.S.E. level and at AS-Level H1: >0 The alternative hypothesis is that there will be a positive relationship between the two variables.

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