# Data Handling Coursework

Extracts from this document...

Introduction

Data Handling Coursework

Introduction

I have been given data about pupils from Mayfield (a fictitious high school). I have been given data about years 7, 8, 9, 10 and 11. The information included in the data sheet is eye colour, IQ, heights, etc. I have chosen 2 aspects, height and weight. I want to investigate the relationship between height and weight. I will look at the heights and weights of years 7 and 11 as they have the biggest gap in age.

## Hypothesis

My hypotheses are:

Hypothesis 1 – Taller you are then heavier you weigh.

Hypothesis 2 – Year 7 boys are lighter than year 11 girls because year 7 boys are smaller.

Hypothesis 3 – The spread of year 7 boy’s heights are larger than the spread of year 7 girl’s heights.

## Planning

I am going to use scatter diagrams to investigate taller you are then heavier you weigh. I am going use stem and leaf diagram and from them I am going to use box plots to investigate that if year 7 boys are lighter than year 11 girls. I am

Middle

42

1.84

76

1.72

60

1.62

52

1.60

45

1.75

60

1.68

48

1.86

80

1.62

54

Hypothesis 1

I am going to use a scatter diagram to see the relationship between height and weight. I will try to find out if taller you are then heavier you weigh.

My hypothesis was right. By using my scatter diagram I can see the tallest boy, which is in year 11, weighs the heaviest of all the year 7 and 11 pupils. The year 11 boy is 1.86m in height and weighs 80kg. Also if taller you are the more you weigh then smaller you are the less you weight and I can see this on my scatter graph as the year 7 girl is 1.41m in height and weighs 39kg.

## Hypothesis 2

I am going to use a stem and leaf diagram to organise the data and then using this I am going to use a box plot to try and find out if year 7 boys are lighter than year 11 girls.

## Stem and leaf

Year 7 boys weight (kg) | ||||||||||||||||||||||

Unordered | Ordered | |||||||||||||||||||||

3 | 8 | 3 | 8 | |||||||||||||||||||

4 | 3 | 0 | 1 | 0 | 5 | 9 | 3 | 0 | 3 | 4 | 0 | 0 | 0 | 2 | 3 | 3 | 3 | 5 | 9 | |||

5 | 0 | 6 | 2 | 0 | 5 | 0 | 0 | 2 | 6 | |||||||||||||

6 | 2 | 6 | 2 |

## Year 7 boys weights

LQ = 15 + 1

4

= 4th

= 40

UQ = 3(15 + 1)

4

= 12th

= 50

IQR = UQ – LQ

= 50 – 40

= 10

Median = 15 + 1

2

= 8th

= 43

Year 11 girls weight (kg) | ||||||||||||||||||

Unordered | Ordered | |||||||||||||||||

3 | 4 | 0 | 9 | 5 | 3 | 0 | 4 | 5 | 9 | |||||||||

4 | 9 | 2 | 0 | 0 | 5 | 1 | 5 | 4 | 0 | 0 | 1 | 2 | 5 | 5 | 9 | |||

5 | 0 | 3 | 0 | 0 | 5 | 0 | 0 | 0 | 3 |

Conclusion

Unordered

Ordered

14

9

5

2

7

14

2

5

7

9

15

5

0

0

0

15

0

0

0

5

16

0

8

1

0

1

5

16

0

0

1

1

5

8

17

1

17

1

## Year 7 boys heights

LQ = 15 + 1

4

= 4th

= 149

UQ = 3(15 + 1)

4

= 12th

= 161

IQR = UQ – LQ

= 101 – 149

= 12

Median = 15 + 1

2

= 8th

= 155

Year 7 girls heights (cm) | |||||||||||||||||

Unordered | Ordered | ||||||||||||||||

12 | 5 | 12 | 5 | ||||||||||||||

13 | 13 | ||||||||||||||||

14 | 2 | 1 | 2 | 14 | 1 | 2 | 2 | ||||||||||

15 | 8 | 6 | 0 | 1 | 4 | 15 | 0 | 1 | 4 | 6 | 8 | ||||||

16 | 2 | 2 | 2 | 3 | 3 | 5 | 16 | 2 | 2 | 2 | 3 | 3 | 5 |

## Year 7 girls heights

LQ = 15 + 1

4

= 4th

= 142

UQ = 3(15 + 1)

4

= 12th

= 162

IQR = UQ – LQ

= 101 – 149

= 20

Median = 15 + 1

2

= 8th

= 156

Now using these calculations I am going to use a box plot to try and see if my 3rd hypothesis was right or not.

My hypothesis was wrong. In fact the spread of year 7 boys heights was smaller than the spread of year 7 girls heights. I have found this out by using my box plot. The year 7 girls LQ is the same as the year 7 boys lowest height value. The year 7 boys highest value is a lot more than the year 11 girl’s highest value and the UQ of year 7 girls is a little more than the year 7 boys UQ. Year 7 boy’s median is a little less than the year 7 girl’s median. The year 7 boys IQR is less than the year 7 girls IQR.

My project could have been improved by using data on a real high school in this area. I could’ve used more samples to get more results. I could have picked my samples different ways such as picking it out of a hat.

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