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.

  1. Go to an empty column and type the label Sample 1.
  2. Below Sample 1, click Data > Data Analysis > Sampling.
  3. Click OK.
  4. In the window that appears, enter the following:
    • Input Range: Select cells F2:F389.
    • Sample method: Check Random.
      • Number of Samples: 20.
    • Output Options: Click Output Range.
      • Select below Sample 1 to paste the sample created..
  5. Click OK.
  6. Repeat the process for Sample 2 through Sample 10.
A screenshot of the sampling window in Data Analysis ribbon.

Figure 12.1: Sampling window in Data Analysis ribbon