Purchase Solution

Central Limit Theorem/Sampling Distribution

Not what you're looking for?

Ask Custom Question

See Excel file to answer the following questions.

A. Generate a random frequency distribution of per capita personal income
B. From the frequency distribution, select two small samples (sample size of 4) and two large samples (sample size of 40), and compare the means and the standard deviations.
C. Construct histograms using a very small sampling distribution of sample means (sample size of 3) and a larger sampling distribution of sample means (sample size of 30).
As you touch the F9 key to give different charts, what do you notice between the charts of small sampling distributions and of larger sampling distributions?

Purchase this Solution

Solution Summary

The solution answers all questions using Excel. The attachment in the solution is an .xls file, not an .xlsx file.

Solution Preview

I couldn't open the file you sent, so I used the one from your original posting. I put my work in the second spreadsheet. See that spread sheet for the answers.

A. Generate a random frequency distribution of per capita personal income

Instead of creating random numbers, I think you're supposed to make a table describing the frequency distribution of the data that's given:

INTERVAL FREQUENCY
$20,000 - $24,999 1
$25,000 - ...

Purchase this Solution


Free BrainMass Quizzes
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.

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.