Share
Explore BrainMass

Examining Data in Excel

See attached file for problem and data.

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?

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 Statistics command under the Data Analysis Toolpak. Useful Excel functions: =Maximum, =Quartile, =Median, =Minimum

Problem 3: Find the mean, standard deviation and median for 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.

Solution Preview

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 ...

\$2.19