Handling Data Mayfield High Research Paper Example | Topics and Well Written Essays - 3500 words

handling Data Mayfield High - Research Paper ExampleTo test the hypothesis that there is a supportive correlation between the height and the angle and the taller a person the more they weigh, I apply scatter plots and cumulative frequency diagrams. The trends and positive slope of the best fit line support the hypothesis. For verification, I have used two additional sets of data, maven for people in the 7th grade and one for the 11th grade. Although more cluttered, the data for these two additional sets also supports the hypothesis.I could use the entire table, save it is so large that I could very quickly nettle mistakes. So, in order to begin, I chose to slang a random sample of data. I decided to collect samples of size of 30 for boys and girls because it is large exuberant to ensure that the sample is representative of the population. At the same time, sample size of 30 is easy to spirt with and would allow me to avoid mistakes in calculations.To assure randomness of th e sample, I used Excel function RAN ( ) to pin down each entry row a random number from 0 to 1. Then I choose the rows according to their random numbers and chose the first 30 entries. The obtained samples are in the table belowsolely this is not enough. I dont see any trends or anything in this list. So I need to frame it in a chart that will tell me how many people fall into each group. Ill make each group cover 1/10 of a metre, or 10 kg. Boys - height flush / mTally frequence1.30 - 1.3921.40 - 1.4931.50 - 1.5951.60 - 1.6951.70 - 1.7951.80 - 1.89 71.90 - 2.003Boys - weightWeight / kgTallyFrequency35 - 44 645 - 54 655 - 64 765 - 74 875 - 84285 - 941Girls - heightHeight / mTallyFrequency1.30 - 1.3921.40 - 1.4921.50 - 1.59 81.60 - 1.69 81.70 - 1.79 61.80 - 1.8941.90 - 2.000Girls - weightWeight / kgTallyFrequency35 - 44 845 - 54 1355 - 64 765 - 74275 - 84085 - 940Now I stinker see that there are no girls who weigh more than 75 kg or who are taller than 1.9 m. I can also see that boys tend to be taller than girls. But if I can turn this into a picture, I can then compare the boys data with the girls data.Heights of Boys and GirlsAnd to compare boys and girls, I can put them both on the same graph.It looks like more boys are taller than girls, which I deliberate is normal. I can do the same for weight. Weight of Boys and GirlsAnd to compare the weights of boys and girlsFrom the graph above it seem that boys weight is more spread out. Girls seem to be closer together, and dont seem to