# 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. Step 1: On the top right corner of the data tab click data analysis. 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   