z. 'i'rns question w111 have you explore the enect or the sample Size on the sampling distri- bution 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: 0 Number of Variables: 6 0 Parameters: Between 1 and 10 0 Number of Random Numbers: 50 0 Output: New Worksheet Ply 0 Distribution: Uniform There will be 50 rows and 6 columns lled 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 50 samples of size 6. Skip the next column, and in the rst empty cell of the following empty column, enter a formula for the mean of the sample in the rst row, then drag this formula down to the last row. In this case, you should enter the formula =AVERAGE(A1:F1) into cell H1. Dragging the formula down from cell H1 to H50 nds the remaining sample means. b) Create a histogram for the sampling distribution of the mean using the upper class limits 1, 2, 3, . . . , 10. 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. You can refer to the document \"Excel Commands\" on Brightspace or refer to your Written Assignment #1 if you need a reminder on creating histograms. 0) Repeat a) and b) with Number of Variables as 20 instead of 6. d) How does the sampling distribution of the mean change as the sample size increases