• 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
  • Level: GCSE
  • Subject: Maths
  • Word count: 1651

Student Data Project.

Extracts from this document...

Introduction

Maths Coursework 2

Ryan Tadd

My 2nd project in maths is to find the average student for years 7-11 in Mayfield High School, I have been given a spreadsheet with precisely 1183 students each with the following information about themselves written in on it:

Year Group

Surname

Forename

Age in months and Years

Gender

Hair Colour

Eye Colour

Left or Right handed

IQ

Height (m)

Weight (Kg)

Distance they live from school

Means of travel to school

Number of Siblings

Numbers of Pets

English SAT level

Math SAT level

Science SAT level

Favourite things

I plan to brake the project into 2 sections, the first part I will focus on finding the average for the quantitative data (numerical), this is likely to be the easier of the 2 sections and will take up little time. The second part will be trying to find the average for the qualitative data (Non-numerical)  this is the data with the no numbers just word, e.g. Forename or Left or Right handed. This will be hard to find averages for and I think I may not be able to find an average for some.

But I will see what I can do.

Before I start either section I must get a sample of the data because it will take forever to do a average of all 1183.

...read more.

Middle

Years Average: 14.702 = 15

Month Average: 5.174 = 5

Year 11:

Years Average: 15.507 = 16

Month Average: 5.858 = 6

The rest of the Numerical data can be done exactly the same as age. I need not to show how it is done because I have already shown your for the age part.

Year 7:

IQ: 101.92 = 102

Height (m): 1.599

Weight (kg): 46.732

Distance to get to school (Km): 3.678

No. of Siblings: 1.714

No. of Pets = 2.812

English SAT: 4.214

Math SAT: 4.107

Science SAT: 4.25

Year 8:

IQ: 99.962 = 100

Height (m): 1.566

Weight (kg): 47.148

Distance to get to school (Km): 3.537

No. of Siblings: 2.481

No. of Pets: 2.111

English SAT: 4.148

Math SAT: 4.222

Science SAT: 4.296

Year 9:

IQ: 105.294 = 105

Height (m): 1.617

Weight (kg): 49.079

Distance to get to school (Km): 3.316

No. of Siblings: 2.351

No. of Pets: 2.189

English SAT: 4.191

Math SAT: 4.379

Science SAT: 4.381

Year 10:

IQ: 102.714 = 103

Height (m): 1.748

Weight (kg): 51.410

Distance to get to school (Km): 5.641

No. of Siblings: 2.680

No. of Pets: 2.118

English SAT: 4.155

Math SAT: 4.014

Science SAT: 4.236

Year 11:

IQ: 100.322 = 100

Height (m): 1.795

Weight (kg): 55.607

Distance to get to school (Km): 4.273

No. of Siblings: 2.988

No. of Pets: 2.782

English SAT: 3.932

Math SAT: 3.815

Science SAT: 3.972

Total average:

IQ = 102

Height (m) = 1.6912

Weight (kg) = 49.9952

Distance from school = 4.089

No. of Siblings = 2.4282

No. of Pets = 2.402

English SAT = 4.128

Math SAT = 4.069

Science SAT = 4.227

On much of the data I not given the rounded figure.

...read more.

Conclusion

English SAT level = 4.148

Math SAT level = 4.22

Science SAT level = 4.296

Favourite colour = Red

Year 9

Age in months and Years = 14 years 5 months

Gender = Female

Hair Colour = Brown

Eye Colour = Blue

Left or Right handed = Right handed

IQ = 105

Height (m) = 1.617

Weight (Kg) = 49.079

Distance they live from school = 3.316

Number of Siblings 2.351

Numbers of Pets = 2.189

English SAT level = 4.191

Math SAT level = 4.379

Science SAT level = 4.381

Favourite colour = Tied between blue and red

Year 10

Age in months and Years = 15 years 5 months

Gender = Female

Hair Colour = Black

Eye Colour = Brown

Left or Right handed = Right Handed

IQ = 103

Height (m) = 1.748

Weight (Kg) = 51.410

Distance they live from school = 5.641

Number of Siblings = 2.680

Numbers of Pets = 2.118

English SAT level = 4.155

Math SAT level = 4.014

Science SAT level = 4.236

Favourite colour = Blue

Year 11

Age in months and Years = 16 years 6 months

Gender = Female

Hair Colour = Brown

Eye Colour = Blue

Left or Right handed = Right handed

IQ = 100

Height (m) = 1.795

Weight (Kg) = 55.607

Distance they live from school = 4.273

Number of Siblings = 2.988

Numbers of Pets = 2.782

English SAT level = 3.932

Math SAT level = 3.815

Science SAT level = 3.972

Favourite colour = Blue

Now I am going to give you the data of the total average student at Mayfield High school:

Age in months and Years = 14 years 6 months

Gender = Female

Hair Colour = Brown

Eye Colour = Blue

Left or Right handed = Right handed

IQ = 102

Height (m) = 1.6912

Weight (Kg) = 4.9952

Distance they live from school (kilometres) = 4.089

Number of Siblings = 2.4282

Numbers of Pets = 2.402

English SAT level = 4.128

Math SAT level = 4.069

Science SAT level = 4.227

Favourite colour = Blue

The reason I produced year averages was to make it possible to see how students are improving and how they develop through the school.

...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. I am going to find out the year 10 male average student at Weavers ...

    have used stratified sampling which is fair and representative to each student in the year in different tutor groups. Also my data is only from one school so it is not very representative although this could be changed by taking data from different schools.

  2. Maths Data Handling

    Height (cm) Weight (kg) 143 33 143 41 148 40 152 37 154 40 160 42 160 50 162 51 165 40 165 40 167 53 144 50 150 39 153 45 155 60 159 44 159 55 162 53 164 44 168 56 168 59 173 59 180 57

  1. I will be testing the following hypothesis in my pilot study: ...

    I therefore will be using the Inter-quartile Range method. I will be removing the outliers because they may cause my hypothesis to be false and eliminating them could make my hypothesis true. When using the Inter-quartile Range method I will be aware of any outliers because it will be more

  2. Maths: Data Handling Coursework

    However, in years 9 and 11, girls have a lower median than boys. I have also noticed that the inter quartiles, upper quartiles and lower quartiles for girls are lower than the boys. I have noticed a pattern that the mode of the weight between the girls and boys increases as the years increase.

  1. Data Handling Project

    x 20 = 2.7 rounded to 3 I then applied the same methods in calculating the number of Girls for my stratified sampling and here is a table of results that I will be using for my data sampling for this particular hypothesis.

  2. Maths newspaper data collection project

    I counted the amount of words in a sentence. I counted the amount of words in ten sentences. I started with the first sentence on the first page and counted every fifth sentence. When I counted the amount of words in each sentence, I counted hyphenated words as one word and I included numbers.

  1. Mayfield High School

    - 0.3612 0.3378 IQ/Science Y=0.0603x - 2.0051 0.4572 IQ/Average KS2 Results Y=0.0627x - 2.2285 0.8256 By observing the gathered data in the table above, I noticed that the scatter graph showing the Key Stage 2 English results are affected more by the IQ, than the Maths and Science results.

  2. Mayfield data

    20 = 2.7 rounded of to 3 Note * I then applied the same methods in calculating the number of Girls for my stratified sampling and here is a table of results that I will be using for my data sampling for this particular hypothesis.

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