In this tutorial we will learn how to create sampling in Excel. We will explain how to create a simple random sampling in excel and periodic sample in Excel.
Simple Random Sampling:
Selecting random number of data from the dataset with repetition.
Periodic sampling:
A periodic sampling method selects every nth item from the data set. For example, if you choose every 3rd item in the dataset, that’s periodic sampling
Note: For sampling in Excel, It accepts only the numerical values
Data:
We will be using the below data to explain Simple random sampling in Excel and Periodic Sampling in Excel.
Step 1: On the top right corner of the data tab click data analysis.
Note: if you can’t able to find the Data Analysis button? Click here to load the Analysis ToolPak add-in.
Step 2: Select sampling and click ok
Step 3: Create Simple Random Sampling.
- Select input data range
- Under sampling method click “Random” Radio button and specify the number of samples you need
- Select the output range and click ok as shown below
So the output will be a simple random sample which is shown below
Periodic Sampling
- Select input data range
- Under sampling method click “periodic” Radio button and specify the periods
- Select the output range and click ok as shown below
In our case period is 3 which means data from 3rd row, 6th row, 9th row, etc … are extracted. So the result will be