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

Handling Data Mayfield High - Research Paper Example To test the hypothesis that there is a positive correlation between the height and the weight and "the taller a person the more they weigh", I used 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, one 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, but it is so large that I could very quickly make mistakes. So, in order to begin, I chose to collect a random sample of data. I decided to collect samples of size of 30 for boys and girls because it is large enough to ensure that the sample is representative of the population. At the same time, sample size of 30 is easy to work with and would allow me to avoid mistakes in calculations. To assure randomness of the sample, I used Excel function RAN ( ) to assign each entry row a random number from 0 to 1. Then I sorted the rows according to their random numbers and chose the first 30 entries. The obtained samples are in the table below: But this is not enough. I don't see any trends or anything in this list. So I need to put it in a chart that will tell me how many people fall into each group. I'll make each group cover 1/10 of a metre, or 10 kg. Boys - height Height / m Tally Frequency 1.30 - 1.39 || 2 1.40 - 1.49 ||| 3 1.50 - 1.59 ||||| 5 1.60 - 1.69 ||||| 5 1.70 - 1.79 ||||| 5 1.80 - 1.89 ||||| || 7 1.90 - 2.00 ||| 3 Boys - weight Weight / kg Tally Frequency 35 - 44 ||||| | 6 45 - 54 ||||| | 6 55 - 64 ||||| || 7 65 - 74 ||||| ||| 8 75 - 84 || 2 85 - 94 | 1 Girls - height Height / m Tally Frequency 1.30 - 1.39 || 2 1.40 - 1.49 || 2 1.50 - 1.59 ||||| ||| 8 1.60 - 1.69 ||||| ||| 8 1.70 - 1.79 ||||| | 6 1.80 - 1.89 |||| 4 1.90 - 2.00 0 Girls - weight Weight / kg Tally Frequency 35 - 44 ||||| ||| 8 45 - 54 ||||| ||||| ||| 13 55 - 64 ||||| || 7 65 - 74 || 2 75 - 84 0 85 - 94 0 Now I can 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 Girls And 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 think is normal. I can do the same for weight. Weight of Boys and Girls And to compare the weights of boys and girls: From the graph above it seem that boys' weight is more spread out. Girls seem to be closer together, and don't seem to