• 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. 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. During this coursework unit I will be using statistical knowledge to analyse my data ...

    These represent the first digit in a number. For every value in the data set you place the number's second digit in its corresponding first number of the diagram (e.g. the number 24 will be placed in the 2 bar and will put a 4 in it's bar to represent its number).

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

    From that I will hope to make a conclusion. From this graph I can see that most pupils in year 7 and year 9 have blue eyes with brown eyes following closely behind.

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

    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. Maths Data Handling

    1, 2, 2, 5, 5, 6, 6, 7, 7, 8, 9 0, 1, 1, 2, 2, 2, 2, 2, 2, 4, 4, 5, 7, 8, 9 50 0, 0, 0, 0, 2, 2, 2, 2, 2, 4, 5, 7, 7, 9 0, 0, 0, 1, 3, 4, 5, 6 60

  2. Maths newspaper data collection project

    3 6 25 7 5 6 10 26 9 5 5 27 3 4 28 5 6 29 2 1 5 30 10 1 5 31 7 32 33 8 1 34 6 3 35 10 36 5 37 2 1 38 39 40 41 42 43 44 45 5

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