Data Sampling in Excel – Create Random Sample in Excel

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 3^rd 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