Question

4. This question explores the effect of the sample size on the sampling distribution of the mean. a) Open Excel. Select Data Analysis, then select "Random Number Generation" from the available options. Use the following values when prompted to enter them: Click OK. Rename the new worksheet to Q4_a There will be 80 rows and 7 columns filled with numbers in a new Sheet on Excel. Consider each row as a random sample drawn uniformly from the numbers 1 to 10. In this case, you have 80 samples of size 7. In the first empty cell of the following empty column, enter a formula for the mean of the sample in the first row, then drag this formula down to the last row. In this case, you should enter the formula =AVERAGE(A1:G1) into cell H1. Dragging the formula down from cell H1 to H80 to find the remaining sample means. b) Create a histogram for the sampling distribution of the mean using the upper class limits 1, 2, 3, ..., 10. See picture below. Rename the worksheet to Q4_b. Edit the chart so that it reads "Created by (Your Name)" as the title. Rename the "Bin" column so that it includes lower and upper class limits (make the entries 0 to 1, 1.001 to 2, 2.001 to 3, 3.001 to 4, and so on). Set the gap width to 0%. Submit a screenshot of the histogram with its frequency distribution table. c) Repeat a) and b) with Number of Variables as 20 instead of 7. Select Chart Output. Rename the new worksheet to Q4_c1: Rename the worksheet containing the histogram to Q4_c2. d) How does the sampling distribution of the mean change as the sample size increases?

          4. This question explores the effect of the sample size on the sampling distribution of the mean.
a) Open Excel. Select Data Analysis, then select "Random Number Generation" from the available options. Use the following values when prompted to enter them:
Click OK. Rename the new worksheet to Q4_a
There will be 80 rows and 7 columns filled with numbers in a new Sheet on Excel. Consider each row as a random sample drawn uniformly from the numbers 1 to 10. In this case, you have 80 samples of size 7.
In the first empty cell of the following empty column, enter a formula for the mean of the sample in the first row, then drag this formula down to the last row. In this case, you should enter the formula
=AVERAGE(A1:G1)
into cell H1. Dragging the formula down from cell H1 to H80 to find the remaining sample means.
b) Create a histogram for the sampling distribution of the mean using the upper class limits 1, 2, 3, ..., 10. See picture below. Rename the worksheet to Q4_b. Edit the chart so that it reads "Created by (Your Name)" as the title. Rename the "Bin" column so that it includes lower and upper class limits (make the entries 0 to 1, 1.001 to 2, 2.001 to 3, 3.001 to 4, and so on). Set the gap width to 0%. Submit a screenshot of the histogram with its frequency distribution table.
c) Repeat a) and b) with Number of Variables as 20 instead of 7. Select Chart Output. Rename the new worksheet to Q4_c1:
Rename the worksheet containing the histogram to Q4_c2.
d) How does the sampling distribution of the mean change as the sample size increases?

4. This question explores the effect of the sample size on the sampling distribution of the mean.
a) Open Excel. Select Data Analysis, then select "Random Number Generation" from the available options. Use the following values when prompted to enter them:
Click OK. Rename the new worksheet to Q4a
There will be 80 rows and 7 columns filled with numbers in a new Sheet on Excel. Consider each row as a random sample drawn uniformly from the numbers 1 to 10. In this case, you have 80 samples of size 7.
In the first empty cell of the following empty column, enter a formula for the mean of the sample in the first row, then drag this formula down to the last row. In this case, you should enter the formula
=AVERAGE(A1:G1)
into cell H1. Dragging the formula down from cell H1 to H80 to find the remaining sample means.
b) Create a histogram for the sampling distribution of the mean using the upper class limits 1, 2, 3, ..., 10. See picture below. Rename the worksheet to Q4b. Edit the chart so that it reads "Created by (Your Name)" as the title. Rename the "Bin" column so that it includes lower and upper class limits (make the entries 0 to 1, 1.001 to 2, 2.001 to 3, 3.001 to 4, and so on). Set the gap width to 0%. Submit a screenshot of the histogram with its frequency distribution table.
c) Repeat a) and b) with Number of Variables as 20 instead of 7. Select Chart Output. Rename the new worksheet to Q4c1:
Rename the worksheet containing the histogram to Q4c2.
d) How does the sampling distribution of the mean change as the sample size increases?

Added by Yasmin E.

Question

Please give Ace some feedback