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 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.

sampling in Excel

 

Step 1: On the top right corner of the data tab click data analysis.

sampling in Excel 2

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

sampling-in-excel-2

 

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

sampling in Excel 4

So the output will be a simple random sample which is shown below

sampling in Excel 5

 

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

sampling in Excel 6

In our case period is 3 which means data from 3rd row, 6th row, 9th row, etc …  are extracted. So the result will be

sampling in Excel 7

previous small sampling in excel                                                                                                                next sampling in excel