• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
• Level: GCSE
• Subject: Maths
• Word count: 2930

# Study an excel spreadsheet which has various details about students and use this information in order to come up with a suitable hypothesis which will provide interesting results.

Extracts from this document...

Introduction

Sebastian Jacobs 11S Mayfield statistics coursework What we were asked: The task given to us is to study an excel spreadsheet which has various details about students and use this information in order to come up with a suitable hypothesis which will provide interesting results. In order to obtain our results we have to take a sample of the data provided (using a random sampling technique of our choice) because it's too big to use all of it. What were my first thoughts: My initial idea of what I could investigate was to study the comparison between the weight of a student and how many hours of television they watch per week. I would do this for a sample of each year group and then compare the results I found. I was going to take a random sample of 10 boys and 10 girls from each year making a total of 100 pieces of data to use. I did start this investigation but after analysing the data I realised that the results were not conclusive. I decided to abandon this idea because of my findings. I also looked at my own family and I for example watch a lot of television but also do a lot of active things which may help to keep me thin, so watching lots of television doesn't always have much relation to your weight since your weight is based on four main factors, diet, genes, metabolism and amount of exercise. My Chosen Investigation: I finally decided that I am going to investigate the comparison between the weight and height of girls in year 7. ...read more.

Middle

Year 7 girls have an average height of 1.55 m(2dp) Year 7 girls have an average weight of 45.26 kg(2dp) Year 7 girls have an average weight to height ratio of 28.33 kg per m(2dp) Year 7 boys have an average height of 1.55 m(2dp) Year 7 boys have an average weight of 44.51 kg(2dp) Year 7 boys have an average weight to height ratio of 27.93 kg per m(2dp) Year 7 have an average height of 1.55 + 1.55 � 2 = 1.55 m(2dp) Year 7 have an average weight of 44.51 + 45.26 � 2 = 44.89 kg(2dp) Year 7 have an average weight to height ratio of 27.93 + 28.33 � 2 = 28.13 kg per m(2dp) Year 11 girls have an average height of 1.59 m(2dp) Year 11 girls have an average weight of 43.31 kg(2dp) Year 11 girls have an average weight to height ratio of 26.78 kg per m(2dp) Year 11 boys have an average height of 1.72 m(2dp) Year 11 boys have an average weight of 60.49 kg(2dp) Year 11 boys have an average weight to height ratio of 33.74 kg per m(2dp) Year 11 have an average height of 1.72 + 1.59 � 2 = 1.66 m(2dp) Year 11 have an average weight of 43.31 + 60.49 � 2 = 51.90 kg(2dp) Year 11 have an average weight to height ratio of 33.74 + 26.78 � 2 = 30.26 kg per m(2dp) From these results my findings are that in year 7 the average height of the girls and the boys is exactly the same- 1.55m. ...read more.

Conclusion

Evaluation: If I was going to repeat this investigation I don't think I could have improved my results in any way with the given data. The only way I could have got more accurate results would be if I had more information on the sample I had taken at year 7 which I could follow through to year 11, then my findings would have been more successful because I would be more certain about the results because I would have been using the same pupils. To improve my sample I could have chosen the number of boys and girls I used in direct proportion to the number of girls and boys in the year, then my averages would be more likely to be accurate. I could also have changed the way I represented my findings because my graphs weren't very conclusive, for example I could have used histograms as well as scatter graphs because I think they would be easier to interpret. I could also have used a box plot diagram to represent my data for each sex and year because they're really easy to compare one another. Conclusion: The graphs and my data has given evidence that my hypothesis is true because I thought that in year 7 the boys would be smaller than the girls but by year 11 they would be larger than the girls and my results show that this is true. The one thing that I hadn't realised was that the girls' average weight to height ratio would have dropped by such a significant amount but I had expected the boys average weight to height ratio to have increased by such a large amount. Sebastian Jacobs 11S ...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

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

1. ## A hypothesis is the outline of the idea/ideas which I will be testing and ...

1.62 51 11 Little James 1.65 47 11 Vincent Nigel 1.8 62 2) Female Stratified Sample Results Year Group Surname Forename 1 Height (m) Weight (kg) 7 Butler Leanne 1.65 40 7 Earnshaw Catherine 1.45 41 7 Meager Becky 1.64 47 7 Miles Amanda 1.46 40 7 Richards Abbie 1.53

2. ## Mayfield. HYPOTHESIS 1: Boys at Mayfield School are Taller and Weigh more on ...

This however notifies me that some of the students in my sample and tall for their age but weight are average in relationship to their height. Girls Heights Tally and Frequency charts are regularly used to process raw data making easier to spot irregularities and patterns.

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

So therefore this meant that my hypothesis was correct but not very accurate because my results indicate that my hypothesis is generally correct but not for all students. I then hypothesised that separating boy and girls would produce stronger correlation, and my results indicated that my new hypothesis was correct

2. ## Liquid chromatography is a technique used to separate components of a mixture to isolate ...

is higher than 1.0 in the selected phase system. For HPLC separations, ? should be 1.05 or higher (�1.3). The resolution of two adjacent peaks is defined as: R = 2 tR2 - tR1 = 1.18 tR2 - tR1 W1 +W2 Wh1+Wh2 where Wh is the peak width at 1/2 height.

1. ## For my Statistics coursework I have decided that I will compare weight and height. ...

And you took every 10 students; to pick the first student you would random sample between 1 and 10. So if 6 is picked, the 6th, 12th, 18th, 24th, 30th etc. number would be picked. Cluster Sampling Putting the data in 'clusters' or groups are simply done by first choosing an amount of data that should be in each cluster.

2. ## If Tesco found that they needed to recruit an office supervisor externally, after finding ...

Female workforce change 1997 - 2010 Female workforce Change % 1997 2000 2010 97 - 00 00 - 10 16-24 25-34 35-44 45-59 60-64 65+ 15,300 23,500 25,400 31,700 3,300 1,300 15,400 21,900 27,000 32,900 3,700 1,200 16,500 19,500 23,200 34,600 4,900 1,300 +0.7 -6.8 +6.3 +3.8 +12.1 -7.7 +7.1 -11.0 -14.1 +5.2 +32.4 +8.3 Source: Cambridge Econometrics, 1997 3.

1. ## mayfield course work -boys are generally heavier than girl. This has to do with ...

48 20.2 85 7 11 11 Male 1.61 56 21.6 140 7 12 6 Male 1.52 42 18.2 147 7 12 4 Male 1.62 42 16.0 47 8 13 1 Female 1.62 53 20.2 48 8 13 7 Female 1.62 51 19.4 85 8 13 4 Female 1.56 47 19.3

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

24+23+22+17+14= 100 students I have chosen to include boys and girls in my sample. I calculated the number of students I will need from each year group. I then calculated how many girls and boys from that sample I will need.

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