Executive Solution Overview
SEE ATTCHMENTS – ## WEEK2.docx – Forum2DataSetProblems.xls **## WEEK2.docx** 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 14 year old boys. The first column is the height in i…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
SEE ATTCHMENTS
– ## WEEK2.docx
– Forum2DataSetProblems.xls
**## WEEK2.docx**
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 14 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. 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 14 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?
**Forum2DataSetProblems.xls**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forum2datasetproblems-xls-10395115)
**Forum2DataSetProblems.xls**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forum2datasetproblems-xls-10395115)
**## WEEK2.docx**
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 14 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. 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 14 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?
**Forum2DataSetProblems.xls**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forum2datasetproblems-xls-10395115)
**## WEEK2.docx**
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 14 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. 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 14 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?
**Forum2DataSetProblems.xls**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forum2datasetproblems-xls-10395115)
– 1
– 2
Leave a Reply