• 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
12. 12
12
13. 13
13
14. 14
14
15. 15
15
16. 16
16
17. 17
17
• Level: GCSE
• Subject: Maths
• Word count: 2701

Mayfield High School Handling Data Coursework

Extracts from this document...

Introduction

Emma Duxbury

Introduction

I am currently undertaking handling data coursework for GCSE key stage 4 mathematics. This involves using and applying statistics. The aim of my investigation is too develop a range of hypothesises through the use of data presented to me. I then intend to collect a sample using a variety of statistical methods and will then go on to calculate, represent and analyse this data to see if my hypothesises can be supported.

The data I will be using is taken from a fictional school called Mayfield. Mayfield has a population of 1183 pupils, both males and females ranging from years 7 to 11. The number of pupils within each year group differs. This is probably due to the school extending as each year goes on. I will manipulate Microsoft excel in order to analyse the secondary data contained in the database. Information given to me includes unique pupil numbers; year; gender; height and weight. I chose to use secondary data as this was an all together simpler and less time consuming method however I should be aware that there are some disadvantages

Middle

50

quartile 1

1.62

50

quartile 2

1.68

54

quartile 2

1.7

57

quartile 3

1.76

60

quartile 3

1.77

62

highest

2

82

highest

1.9

80

mean

1.71

56.8

mean

1.698

57.8

co efficient

co efficient

0.506734

 yr 9 height weight yr 8 height weight lowest 1.35 36 lowest 1.2 32 quartile 1 1.525 45 quartile 1 1.52 44 quartile 2 1.58 51 quartile 2 1.6 49 quartile 3 1.62 60 quartile 3 1.7 53.5 highest 1.75 75 highest 2 110 Interquartile range 0.4 39 Interquartile Range 0.8 78 mean 1.565 53.4 mean 1.604 57.7 co efficient co efficient yr 9 females height weight yr 8 females height weight lowest 1.35 36 lowest 1.32 38 quartile 1 1.5275 44 quartile 1 1.52 46 quartile 2 1.58 49 quartile 2 1.59 50 quartile 3 1.62 52 quartile 3 1.62 57 highest 1.8 65 highest 1.75 72 mean 1.5755 49.2 mean 1.56 52.6 co efficient co efficient 0.126176 yr 9 males height weight yr 8 males height weight lowest 1.46 38 lowest 1.2 32 quartile 1 1.54 47.25 quartile 1 1.52 42 quartile 2 1.635 54 quartile 2 1.62 49 quartile 3 1.73 63.25 quartile 3 1.72 52 highest 1.8 75 highest 2 110 mean 1.633 55.5

Conclusion

This graph shows that the median height increases every time the year gets higher.

This graph shows that the median weight increases every time the year gets higher.

Therefore, I can see that again, I have proved my hypothesis to be correct.

Conclusion

Through looking at all the data collected I have been successful in proofing that all my hypotheses were correct. I did this through using a variety of methods. These included scatter and box and whisker diagrams as well as working out the means and correlation co-efficient. I proved all 3 hypothesis to be correct however, as I preceded my investigation there were some problems, these were that I found I had some errors that could have altered my results. If I were to do the investigation again I would eliminate the errors before including them in graphs and results tables, as this would make my results overall more reliable. I could have also increased the reliability through increasing the sample size. By increasing the sample size my results would be more varied and therefore more accurate. If I wanted to extend my investigation I could look at other schools and see how they compare to Mayfield High School. I could then establish whether or not my results can be applied to a wider population.

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. Edexcel GCSE Statistics Coursework

It is evident from all the graphs included that females are, in effect, generally shorter and weigh less than males. Whether this is attributable to, as studies show, the varied skeletons of the opposed sexes or the dissimilar hormones produced in both female and male bodies, it is known females are generally shorter and weigh less than males.

2. Conduct an investigation comparing height and weight from pupils in Mayfield School.

The average deviation from the mean is 8.6. 95% of the results lie within two standard deviations of the mean. So 2 � standard deviation = 8.6 � 2 = 17.2 Mean - (2 � standard deviation) = 154 - 17.2 = 136.8 Mean + (2 � standard deviation)

1. Maths Statistics Coursework - relationship between the weight and height

a much larger variety of ways without redundancy because this would help me to make a diversity of comparisons between the data. When I gathered the information on each of the year groups (boys and girls) and then constructing scatter graphs on each of the year groups, I noticed that

2. Math Coursework-Mayfield High Data Handling

Formulas/Statistical Skills Used Sampling Random Sampling: Random sampling is a method of sampling to get data in a totally unbiased way. There is a random number generator in calculator which will generate a number between 0.001-1.000. I will use the given number and multiply it by the total number of samples (population)

1. Maths Data Handling

For example if I am selecting Year 7 girls for my sample, I need 11 girls. I will press the random button on my calculator and then multiply it by 131, as that is how many Year 7 girls there are in the population.

2. Mayfield High Statistics Coursework

I will be calculating my stratified sampling by using the table below: males females year 7 151/603 x 50=12 131/578 x 50=11 year 8 145/603 x 50=12 125/578 x 50=11 year 9 118/603 x 50=10 143/578 x 50=12 year 10 106/603 x 50=9 94/578 x 50=8 year 11 84/603 x 50=7 86/578 x 50=8 Males Year Group Height (m)

1. Maths Coursework - Data Handling

for boys, and the interquartile range is slightly smaller than in boys indicating that the data is more consistent.

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

Hypothesis 2 'Boys are taller and heavier than girls. The difference between boys and girls will increase as the students get older.' To compare the difference between males and females I produced box and whisker diagrams (see appendix 18,21.24) to directly compare each year group I also produced these tables

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