Central Limit Theorem/Sampling Distribution
Not what you're looking for?
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.