Purchase Solution

Examining Data in Excel

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

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

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.