For Group 2 you select the 10 cells in the Women column as Input Range and Periodic with Period 3.
For Group 1 you select all 20 population cells as the Input Range and Random as the Sampling Method with 6 for the Random Number of Samples. You need to run the sampling data analysis tool twice, once to create Group 1 and again to create Group 2. sampling is with replacement).Įxample 1: From a population of 10 women and 10 men as given in the table in Figure 1 on the left below, create a random sample of 6 people for Group 1 and a periodic sample consisting of every 3 rd woman for Group 2.įigure 1 – Creating random and periodic samples This number of values is drawn from random positions in the input range. Random – In this case, you specify the Random Number of Samples.
Sampling stops when the end of the input range is reached. The nth value in the input range and every nth value thereafter is copied to the output column.