• 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: 2764

Statistics Coursework

Extracts from this document...


Laura Clark        Page         8/3/2008

Statistics Coursework


We have been given data about the different aspects of life of students from Mayfield High School. The data includes information such as the height and weights of the students, and educational stats such as KS2 results.

        My aim is to investigate the relationship between two or more of these pieces of information.


My main hypothesis is that:

“As IQ increases, the total KS2result also increases”.

I chose this as my main hypothesis because I think that as IQ is natural intelligence, having a higher IQ would mean that a student could easily obtain higher KS2 results.

Related Hypotheses:

        I have chosen to investigate two related hypothesis, these being:

        1.        “Year 7’s have higher total KS2 results than Year11’s”

  1. “Girls obtain higher percentage of results of a 4 or above in each KS2 test than boys”

I have chosen these as my related hypotheses as they allow me to look more closely at my main

hypothesis. I have chosen the first one specifically because I have heard that exams were getting easier, and I wanted to investigate this to see what I heard was correct. I have chosen the second one because I believe it to be true; in general boys spend a greater amount of time outdoors and so less time studying than girls do.

Preliminary Studies:

        I have carried out a small scale preliminary study for my main hypothesis, to check if there is any basic correlation, and therefore ensuring I can see if it is worth investigating.

...read more.



Year 9 Female


Year 9 Male


Year 10 Female


Year 10 Male


Year 11 Female


Year 11 Male




After finding out the number of records required from each category of student, I used a Random Number Generator on a calculator to obtain the student numbers that I needed for the sample.

This involved finding out the total number of student in each category and inputting this number into the calculator, then using the Ran# key.   I did this separately for each category to obtain the numbers, and as the data was in an Excel spreadsheet it was easy to see which records the generator would be referring to.

Investigating the Main Hypothesis:

After obtaining my sample, I used Excel to create a scatter graph comparing the two sets of information: IQ and total KS2 results obtained. To find the total KS2 result for each student I used the SUM “=Sum(number1,number2,number3)” formula in Excel which calculates the total if the numbers are inputted or the cells with the information in are clicked on.

This is the scatter graph I obtained from my results:


From looking at this graph I can see that the correlation between the two sets of data is positive and strong. This supports my hypothesis that “As IQ increases, the total KS2 result also increases”. However, to calculate the correlation more accurately I used the Correl formula in Excel “=correl(array1,array2)”. This gives a value for the correlation of the data. The correlation for this graph was 0.900607, which is extremely strong and shows that IQ has a direct effect on the KS2 results obtained.

Investigating the Related Hypotheses:

        To investigate my first related hypothesis, I found the median, range, lower quartile and upper quartile values from both sets of data.  To calculate this data, I used various formulas in Excel. To calculate the median for the data, I used the MEDIAN formula “=MEDIAN(array)”. This calculates the median of a highlighted selection of data, which is the “array” part of the formula. To calculate the upper and lower quartiles of the data, I used the QUARTILE formula, “=QUARTILE(array, quart)”. This calculates the value of the chosen quartile for the data highlighted, and the “quart” part of the formula is where the chosen quartile is inputted. For the lower quartile, the value is 1 and for the upper quartile the value is 3.  I also calculated the range of the data. Once I had finished these calculations for both year groups, I put the data into a table so it could be displayed.

Year Group


Lower Quartile

Upper Quartile






10 - 16





10 - 15

...read more.


        With regards to the findings from my investigation, although they are relevant to my investigation, they would not necessarily be relevant and accurate for our whole school population, or the population of the country. However it would probably be quite relevant to the school as the basic principles would be the same, however because Kendrick is a grammar school all results and IQs should be relatively high, making it hard to distinguish between different results.  In terms of the whole country the investigation is not overly relevant as it was a small scale investigation looking at only one school, one type of school in one town.  This means that to make it relevant and accurate for the whole population, samples would have had to be taken from all over the country at different types of school to get an accurate representation to generalise the study.  Another factor that makes it less relevant is that I did not compare the KS2 results to all ages throughout the school, just the two extremes of year group in the school, Year 7 and Year 11.  Therefore, any conclusions I obtained for my investigation are valid for this particular school, they cannot however be applied to any other school in any other area of the country, or the country as a whole.

...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

    This however notifies me that some of the students in my sample and tall for their age but weight are average in relationship to their height. Girls Heights Tally and Frequency charts are regularly used to process raw data making easier to spot irregularities and patterns.

  2. A hypothesis is the outline of the idea/ideas which I will be testing and ...

    Height Comparison: From the Sample I have taken I have come to find that boys grow rapidly at a later age whereas girls grows faster from an earlier age and stop at a particular age also. This is shown since I have found that 2 students are of a height

  1. Edexcel GCSE Statistics Coursework

    10 Female 1.65 54 10 Female 1.75 56 11 Female 1.03 45 11 Female 1.62 48 11 Female 1.63 38 11 Female 1.63 48 11 Female 1.68 50 11 Female 1.72 60 7 Male 1.41 31 7 Male 1.42 26 7 Male 1.44 42 7 Male 1.59 52 7 Male

  2. Mayfield School Mathematics Statistics Coursework

    confirm that, on average, both the male and female students showed greater ability in Science than in Maths. Flicking on through the A' Level Statistics book, I see that the line of best fit I would normally draw by inspection can actually be calculated.

  1. Mayfield High Statistics Coursework

    Year 11 females 86/1183 x 100 = 7 (R) Year Group Gender IQ Maths 7 female 89 3 7 female 98 4 7 female 100 4 7 female 100 3 7 female 100 4 7 female 101 4 7 female 102 4 7 female 102 4 7 female 103 4 7 female 106 5 7 female 107 4 7

  2. Maths Statistics Coursework - relationship between the weight and height

    I have noticed after the calculations involved above, that there are no outliers for the girls, however, there were outliers for the boys. This indicates to me that there is a wider spread of different heights, both low and high.

  1. Maths Statistics Coursework

    Female 10 1.72 56 Female 10 1.62 48 Female 10 1.75 57 Female 10 1.73 51 Female 10 1.62 48 Female 10 4.65 53 Female 10 1.70 48 Female 10 1.63 60 Male 10 1.75 45 Male 10 1.80 49 Male 10 1.66 70 Male 10 1.90 70 Male 10

  2. Mayfield Maths Coursework

    4 4 102 9 Female 4 4 4 4 103 9 Female 4 4 4 4 103 7 Female 4 4 4 4 104 11 Female 4 4 4 4 106 10 Female 3 4 5 4 106 8 Male 4 4 4 4 97 11 Male 4 4 4

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