These are generated using the Excel function RAND(). Column B consists of random numbers between 0 and 1. We accomplish this by creating a worksheet as in Figure 2.įigure 2 – Creating a random sample without replacementĬolumn A consists of the data elements in the population (as taken from Figure 1).
We now show how to create the Group 1 sample above without duplicates.Įxample 2: Recreate Group 1 from Example 1 without allowing any duplicates. As you can see from the example, the number 2 is chosen twice in the Group 1 sample.Īs a result, it often better to use other approaches to create a sample.
Excel draws samples from the first column, then the second column, and so on. Input Range – Specify the range of data that contains the population of values you want to sample. The tool works by defining the population as an array in an Excel worksheet and then using the following input parameters to determine how you would like to carry out the sampling. Excel provides a Sampling data analysis tool that can be used to create samples.