Exercise #1 Construct Sampling Distributions from a known Probability Distributions Construct a sampling distribution of the sample means from a Uniform distribution from (0, 1) by taking 500 samples of size n = 30. For each sample find the mean ??̅ and then make a histogram of these 1000 values. Procedure - Uniform 1. Activate cell A1 2. Choose the Data tab, then select Data Analysis>Random Number Generation. 3. Complete the dialog box. Number of Variables: 30 Number of Random Numbers: 500 Distribution: Uniform Parameters: Between: 0 and 1 Then click OK. 4. Enter the formula = AVERAGE(A1:AD1) in cell AE1 to compute the average of the first sample of size 30. 5. Activate cell AE1, click the fill handle + in the lower right hand corner and drag to cell AE500 to fill the column sample means from the 500 samples. 6. Create a histogram of the means: Using Excel. Make sure to select the column containing the sample means and check the box for Chart Output – leave the Bin Range box blank.
Exercise #1
Construct Sampling Distributions from a known Probability Distributions
Construct a sampling distribution of the sample means from a
Uniform distribution from (0, 1) by taking 500 samples of size n = 30. For each sample find the mean ??̅
and then make a histogram of these 1000 values.
Procedure - Uniform
1. Activate cell A1
2. Choose the Data tab, then select Data Analysis>Random Number Generation.
3. Complete the dialog box.
Number of Variables: 30
Number of Random Numbers: 500
Distribution: Uniform
Parameters:
Between: 0 and 1
Then click OK.
4. Enter the formula = AVERAGE(A1:AD1) in cell AE1 to compute the average of the first sample of
size 30.
5. Activate cell AE1, click the fill handle + in the lower right hand corner and drag to cell AE500 to
fill the column sample means from the 500 samples.
6. Create a histogram of the means: Using Excel. Make sure to select the column containing the
sample means and check the box for Chart Output – leave the Bin
Step by step
Solved in 3 steps with 6 images