See attached file for problem and data.
Problem 1: Show the distribution of heights visually. Can you draw any conclusions? What does it meanto “show the distribution…visually?” What specific tool in Chapter 1 gives a picture of the data distribution?
Problem 2: Describe the distribution of weights with the Five Number Summary. Can you draw any conclusions? Hint: Use Excel functions for each part of the 5 number summary, not the Descriptive Statisticscommand under the Data Analysis Toolpak. Useful Excel functions: =Maximum, =Quartile, =Median, =Minimum
Problem 3: Find the mean, standard deviationand medianfor the age of our students. Represent the ages visually, using a stemplot, boxplot or histogram. Can you draw any conclusions? (25 points) Useful Excel functions: =Mean, =StandardDeviation,=Median
Problem 4: Ask one question about the data that we have not asked. Answer your question using the 4 step process : state; formulate; solve conclude. You must use numeric, visual and verbal analysis: calculate; show; and tell.
See the attached Excel file.
Note the first set of directions: “Examine the data before you use it. Sometimes a data set contains values that make no sense. What would you think if you found a height of 5? … If you change or delete values, include a list of the changes on the worksheet holding your data.” I didn’t change or delete any values, but I did say where I thought there might be a mistake in data entry.
*** In the Excel file, the labels for Males and Females are reversed in the solution to Question 4. There are more females than males. ***
Problem 1: Show the distribution of heights visually. Can you draw any conclusions? What does it mean to “show the distribution…visually?” What specific tool in Chapter 1 gives a picture of the data distribution?
The data for these questions are on Sheet2.
You can make a histogram to show the data visually. This is a graph that shows how many data points are in different intervals.
First, sort the height data from low to high.
Then, make a chart showing how many data points are in different intervals. You can decide for yourself how wide the intervals should be. I chose interval widths of …