# 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.

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