12.3 Generating Random Samples
You will simulate the sampling distribution by generating only 10 random samples of Close Prices with a sample size equal to 20.
- Go to an empty column and type the label Sample 1.
- Below Sample 1, click
Data > Data Analysis > Sampling
. - Click
OK
. - In the window that appears, enter the following:
- Input Range: Select cells
F2:F389
. - Sample method: Check
Random
.- Number of Samples:
20
.
- Number of Samples:
- Output Options: Click
Output Range
.- Select below Sample 1 to paste the sample created..
- Input Range: Select cells
- Click
OK
. - Repeat the process for Sample 2 through Sample 10.