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

    conclusion that females live longer than males I have also noticed from this that this is not the case for all the continents especially in Asia. This gave me a good reason to argue that in all the countries it is not always 'females live longer than males', and also

  2. Maths Data Handling

    Although there are a small number of boys with a lighter weight than some girls and a small number of girls with a heavier weight than some boys, the evidence suggests that in general, the weight for boys is greater than the weight for girls.

  1. Maths: Data Handling Coursework

    To test the three hypotheses, I would be looking at the Year groups 7, 9 and 11. I am ignoring the other year groups (Year 8 and Year 10) because I feel I would still be able to get the results I want by looking at just three groups.

  2. mayfield high school handling data coursework

    height, weight, IQ and names. I am using this data because it is already collected so there is less chance of me making a bias occurs. To prove my hypotheses I will need to know what my population is and what sample size I am going to take from it.

  1. Data Handling - GCSE Coursework

    64 1.83 26 F 50 1.73 27 F 47 1.33 28 F 50 1.72 29 F 54 1.48 30 F 85 2.03 I've taken 30 pupils data from a total of 170 pupils in Year 11. I picked them out at random to get a varied amount.

  2. Maths - Handling Data

    Therefore, the inter quartile range = 1.745 - 1.60 = 0.145 Maximum Value: 1.90 Therefore, Range = 1.90 - 1.41 = 0.49 Adam Warlow. Pg 10 Year 11 Mean = ?x = 46.08 = 1.65 n 28 There are 28 pieces of data so the median is halfway between the

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