• 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. GCSE Maths Statistics Coursework

    100 15 21 100 < x ? 110 14 35 110 < x ? 120 3 38 120 < x ? 130 2 40 The cumulative frequency tables below show the spread of data (IQ) for the two different year groups in my sample (Year 10 and 11).A box plot will be plotted to show the inter-quartile

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

    Lastly, after I have all the conclusions for each graph, table or diagram, I now have to relate it back to the original hypotheses in my plan, which is what I am doing below (subheading: conclusions on hypotheses). Conclusions on Hypotheses: 1.

  2. Mayfield High Statistics Coursework

    Year 9 males 118/1183 x 100 = 10 (R) Year 9 females 143/1183 x 100 = 12 (R) Year 10 males 106/1183 x 100 = 9 (R) Year 10 females 4/1183 x 100 = 8 (R) Year 11 males 84/1183 x 100 = 7 (R) Year 11 females 86/1183 x 100 = 7 (R)

  1. Statistics coursework - hypotheses based on students statistics

    then dividing it by the size of the data set I was taking it from. For example if I wanted to find out my sample size for year 7 males I would do the following calculation: ~ (151 / 1183)

  2. The aim of the statistics coursework is to compare and contrast 2 sets of ...

    cumulative frequency curve so it shows that my third hypothesis is correct! Conclusion Whilst I have been writing my coursework I have noticed a few things which I think may be a factor in the project. First of all I noticed that on the questionnaire data analysis sheets for year

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