• 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

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.

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.

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.

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

# Related GCSE Height and Weight of Pupils and other Mayfield High School investigations essays

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

5 9 Female 3 3 9 Female 3 4 9 Female 3 3 9 Female 3 3 9 Female 4 4 9 Female 4 4 9 Female 4 9 Female 4 4 9 Female 4 4 9 Female 4 4 9 Female 4 4 9 Female 4 4 9 Female

2. ## Maths Data Handling

The histograms and frequency polygons that I used effectively allowed me to compare the heights and weights of girls and boys and see the trends within the relationship between height and weight, which included the formation of a new hypothesis, which is: 'In general, the taller a person the heavier that person is likely to be'.

1. ## Maths newspaper data collection project

The results are shown below. QUALITY TABLOID Sentence Tally Frequency 1 16 2 25 3 28 4 15 5 33 6 25 7 28 8 19 9 30 10 23 Mean = 24 Mode = 25 & 28 Median = 25 Range = 18 Local Paper Sentence Tally Frequency 1

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

Changes in a male's body are greater at this time than any other time in a male's life. Puberty usually occurs most often between the ages of 10 and 15, or occasionally earlier or a little later. I also found out that for a female, adolescence is also the time

1. ## Maths: Data Handling Coursework

The girl who came before her is the height of 179cm, which is very close to 190cm. The slight difference between the tallest girl and the tallest boy could show that girls in Year 9 can be only slightly taller than boys in Year 9; however, the shortest girl is 125cm, whereas the shortest boy is 130cm.

2. ## Data Handling Project

Table The table below is a two way table due to the fact there are two variables shown at the same time and helps view results and data conclusively. Year Group Number of Boys Number of Girls Total 7 151 131 282 8 145 125 270 9 118 143 261

1. ## Mayfield High School

English results are affected more by the IQ, than the Maths and Science results. The table also indicates through the R� value, that on average, around 70% of the Key Stage 2 results are affected by the IQ, which shows there is a median relationship between the average Key Stage 2 results and the IQ.

2. ## Mayfield data

had to do separate samples for boys and girls and vary the amount of samples taken from each year to keep the sample unbiased and insufficient. This was done as the different year groups had different numbers of pupils and it would be unfair to take the same number of samples from each year group i.e.

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