How to Perform Data Binning in Excel

In this tutorial, you will learn how to perform data binning in Excel.

In order to organise a large number of more-or-less continuous values into a smaller number of “bins,” statistical data binning is used. For instance, you could want to divide a group of people’s ages into fewer age intervals if you have statistics on them (for example, grouping every five years together).

Once you are ready, we can get started by using real-life scenarios to help you understand how to perform data binning in Excel.

Perform Data Binning

Before we begin we will need a group of data to be used to perform data binning in Excel.

Step 1

Make sure your group of data is displayed in a clean and tidy manner in the first sheet.

Step 2

Click the ‘Data’ tab in the top ribbon, then select ‘Data Analysis’, to determine the number of data values that fit into each bin. Once a pop-up box came up, select ‘Histogram’.

Step 3

We will then select the entire data group as your ‘Input Range’, select the Bin Range then press ‘OK’.

Step 4

Once we press ‘OK’, the data binning is complete.