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

Mayfield High School data handling Coursework

Extracts from this document...

Introduction

Introduction In this investigation, I have been given data from Mayfield High School. Although the name of the school is likely to be fictional the data itself has come from real students. The data I have been given is for year 7 to year 11 students. There is information on around 170 students for each year. The following are the types of information we got on each student, year group, surname, forename, age, gender, hair colour, eye colour, which handed they are, favourite colour, favourite music, favourite sport, favourite subject, favourite T.V programme, average hours of T.V watched, IQ, height (m), weight (kg), distance traveled to school, Means of transport to school, number of siblings, number of pets, key stage two results for, maths, English and science. There is too much data so I will use Excel to filter it. I will choose IQ and KS2 results. Since there are too much data I would not be able to examine it probably. Some of the data on the sheet is quantitative data, so I would need numerical data. This is good because I will be able to narrow it down using maths statistics. I will also use reference numbers, so it will help me when I am doing random sampling. ...read more.

Middle

To do this I am going to examine all the boys form the entire year groups and all the girls in the entire years as well. My Data All Boys All Girls Ref. No. IQ KS2 Score 2 104 4.7 8 100 4.3 9 103 4.7 14 100 4.0 16 93 3.3 34 109 5.0 29 89 3.3 50 92 3.3 70 108 4.7 131 124 5.0 1 116 5.0 23 100 4.0 48 100 4.0 63 102 4.3 64 103 4.3 70 102 4.0 92 110 5.0 108 106 4.7 116 102 4.0 122 118 5.0 7 122 4.7 17 103 4.3 23 88 3.0 49 107 4.3 56 112 4.3 62 94 3.0 78 72 2.0 88 98 3.7 111 100 4.3 112 93 3.3 124 105 4.7 Ref. No. IQ KS2 Score 1 101 3.7 6 101 4.0 7 112 5.0 8 100 4.0 14 100 4.7 21 92 3.7 26 103 4.7 33 106 4.7 50 92 3.7 66 96 3.3 10 100 4.0 20 104 4.0 44 105 4.3 50 107 4.7 62 116 5.0 83 99 4.3 94 90 3.0 101 105 4.7 108 94 3.7 118 127 5.7 131 92 3.0 4 101 3.7 17 100 4.0 37 104 4.3 41 112 5.0 61 102 4.3 91 98 4.3 102 96 4.0 118 89 3.0 56 69 2.0 Yr 7 Boys Yr 7 Girls Ref. ...read more.

Conclusion

9801 90 8100 105 11025 94 8836 127 16129 92 8464 101 10201 100 10000 104 10816 112 12544 107 11449 102 10404 98 9604 96 9216 89 7921 ?x ?x2 =3150 =321992 n=31 Mean = ?x n = 3150 31 = 101.613 (to 3 d.p) Standard Deviation = V?x2 _ (mean)2 n = V321992 - 101.6132 31 = V321992 - 10325.20177 31 = 7.85 (to 2 d.p) IQ Yr 7 Boys 09 10 11 2, 2, 6, 9 0, 0, 1, 1, 3, 6 2 Key: 09/2 = 92 08 09 10 11 12 9 2, 3 0, 0, 3, 4, 8, 9 4 IQ Yr 7 Girls Key: 10/0 = 100 IQ Yr 9 Boys 08 09 10 11 9 6, 8 0, 1, 2, 4, 7 2 Key: 11/2 = 112 07 08 09 10 11 12 2 8, 3, 4, 8 0, 3, 5, 7 2 2 IQ Yr 9 Girls Key: 12/2 = 122 The main advantage of a stem and leaf plot is that the data are grouped and all the original data are shown, too. A stem and leaf plot would show that information. Without a stem and leaf plot, the two values can only be found by searching through all the original data-a tedious task when you have lots of data! Boxplots show outliers Indicate skewness and symmetry ...read more.

The above preview is unformatted text

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

    I have produced a Composite Bar Chart which is attached to the upcoming page The Pie Chart shows the percentage of each year in the School and these help me form my sample and this form of representing data is efficient accurate and eye catching and help form divisions in my data.

  2. Edexcel GCSE Statistics Coursework

    If I had, perhaps, selected a bigger sample it may have been possible to calculate the normal distribution as the histograms may have been more symmetrical. After calculating the standard deviation, it is evident for both height and weight, that for the male data each value is closer to the

  1. Math Coursework-Mayfield High Data Handling

    Sub-Hypothesis 2 Normal distribution: I will present the data by drawing a frequency polygon. I used frequency polygon because it would be easy for me to analyze and see whether it is normally distributed (bell shaped curve). Normal distribution is determined by many different factors such as the mode, median

  2. Maths Data Handling

    girls, but the modal height was the same for both with a class interval of 160-170 cm. The sample for boys was more stretched, with a range of 70 cm compared to 60 cm for the girls. The evidence from the sample suggests that 18 out of 51, or 35%

  1. Mayfield High Statistics Coursework

    However I will still be using stratified sampling as I need a fair representation of boys and girls. Here is a table I have produced which contains the number of boys and girls in each year. The table below is a two way table due to the fact that there

  2. Maths data handling "girls are more intelligent than boys".

    in year 10= 106 x 50 = 28 Girls in year 10= 94 x 50 = 26 190 180 Boys in year 11= 84 x 50 = 22 Girls in year 11= 86 x 50 = 24 190 180 Boys= 28 +22 = 50 Girls= 26 + 24 = 50

  1. Statistics GCSE Coursework. Height and weight of pupils. The sampling method I am ...

    is very close to the 68% you would expect for a normal distribution, then 93.3% of the data lies within 2 standard deviations of the mean again fairly close to the expected 95% and all of the data lies within 3 standard deviations above and below the mean, very close to the 98.8% for the normal.

  2. During this coursework unit I will be using statistical knowledge to analyse my data ...

    To get a range you just have to get the highest value from the group and minus the lowest value from it, which is also in the same group. For standard deviation there is a formula: ? x 2 - (?x/n)

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