• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

See related essaysSee related essays

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.

    For year 11 I again hypothesised that the taller you are the more you are likely to weigh, I thought if this was the case for student in year 7 then it definitely would be the case for year 11 student because there is going to be a more vaster

  2. An Investigation into the height to length ratio of Limpets on exposed and sheltered ...

    The height of a limpet depends of how deep into the rock it actually lives. However, a limpet's shell appearance is not quite standardised, it is dictated by the environmental conditions within which it lives. Though the same species may occupy different areas, they may have adapted to have the best features suiting its environment.

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

    Weight (kg) Body Mass Index (BMI) 120 9 14 3 Female 1.59 50 19.8 7 9 14 10 Male 1.65 45 16.5 19 9 14 7 Male 1.62 40 15.2 31 9 14 6 Male 1.70 85 29.4 93 9 14 4 Male 1.43 60 29.3 106 9 14 5 Male 1.62 42 16.0 108 9

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

    760 739 799 Girls: 656 584 674 689 669 659 676 658 601 684 786 810 Year 10: Boys: 915 977 1009 1013 936 952 959 1013 968 Girls: 815 885 854 908 886 846 821 877 Year 11: Boys: 1114 1039 1037 1111 1120 1182 1037 Girls: 1059 1093 1056 1061 1033 1034 1076 Student No.

  1. Mayfield High. I will set about carrying out various test in order to come ...

    4 4 5 4.333333333 101 4 4 4 4 104 4 5 4 4.333333333 81 2 3 3 2.666666667 104 4 4 5 4.333333333 106 5 5 5 5 104 5 4 4 4.333333333 131 6 6 5 5.666666667 96 4 3 4 3.666666667 90 3 3 3 3 106

  2. My hypothesis is that there will be a positive correlation between the height and ...

    However due to external interference, e.g. diet, the growth rate may not be consistent in both height and weight, which explains any outliers that may be found. I also hypothesise that girls will grow taller faster, as they grow at a faster rate initially, but then boys will "catch up"

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