Please help me respond to 2 classmates discussion post. Please read...

Please help me respond to 2 classmates discussion post. Please read everything thank you

This is what we had to write about.

Using the skills you learned in weeks 1 and 2 evaluate a set of statistics.  An Excel spreadsheet is attached including 30 data sets representing the height and weight of 10 year old boys.  The first column is the height in inches and the second the weight in pounds.  Choose one data set that has not already been selected (include the number of the data set in your title to make this easier to do).  Calculate the mean, median and mode of the weights in the data set.  You can either do this by hand or see the video below to show you how to do this using the tools in Excel.  Then, explain what these numbers mean.  Are they the same?  Why are they different?  

Then, construct a scatter plot.  

• From the insert menu select scatter or the chart that says scatter and then select the chart at the top left on the dropdown
• Click on one of the points
• Select Add Trendline (Note you may need to add Trendline and then click on the line to format Trendline)
• The default radio button is linear, keep it checked

What are your observations from the scatter plot?  Does it appear that there is a correlation between the height and weight of 10 yr old boys.  Note:  this data is made up, so do you think this is accurate?  Do you think given real data that there would be a greater amount of correlation or less?  

1. Hi class, I hope you all are doing well. For this weeks discussion, I chose to use Data Set #8. I found the Mean for height to be 67.85, the Median for height to be 68.14, and the Mode for height to be 65.18. When looking at weight, I had 126.58 for mean, 126.49 for median and there was no mode for this one. I found it interesting that the data found more overlaps in height rather than in weight. As a mother of a newly 11 year old boy, I think this data is really overreaching for average weight of a 10 year old. Perhaps I have not kept track of my sons weight but the 10 year olds that I know are not over 100 lbs. I think the height is right on though. This was an interesting assigntment, I have more difficulty with scatter plots as I love a pie chart, but I can appreciate the benefit of it. I hope you all are having a great week. Talk to you more in week 3. 

Best

Sarah

2. Good evening, class!

For this week's discussion, I chose to analyze data set #17. By looking at my scatter plot, there is some correlation between the height and weight for the 10-year-old boys - the taller the boy, the heavier the weight. I believe that is what you would typically expect, but I would also think in a real set of data that there would be a few outliers. For example, a shorter boy with a heavier weight or a taller boy with less weight. This data doesn't have any outliers. The weight scale ranges by 46 pounds, but the height only differs by roughly six inches and the positive trend continues throughout the set.

For the weight data:

Mean = 125.46

Mode = N/A

Median = 121.79

The mean is calculated using all the values in the data set; you add up all the values in the data set and divide the sum by the total number of values. The mode is the value that occurs the most frequently. In this set of data, the mode is N/A because there is not an exact weight that is repeated. The median is calculated by the middle number(s) in the data set once it is sorted from lowest to highest. If there is an odd number of values, the middle number is the median; if there is an even number of values, it is the average of the two middle values.

Thank you!

-Rachel