The formula to determine the bin range is given below: Because you may get redundant intervals in that case.
You cannot just use a random value to create the bin range. To get a nice-looking histogram for any given dataset, it is necessary to calculate the bin range value. Step 1: Calculating Bin Range for the Dataset We will make a histogram with this dataset and organize the graph in a suitable way by applying a proper bin range. In the dataset, you can see some profit data for the first 10 months of the year. How to Change Bin Range in Excel Histogram: Step-by-Step Procedures You see that from 1 to 5, there are 7 data (1, 2, 2, 2, 3, 3, 3) and from 6 to 10 there are 2 data (6 and 10). So, if you want to divide this range of dataset into two intervals, each interval will be 5 (rounded value of (10-1)/2 or 4.5) units long. Here, the maximum and minimum numbers of the dataset are 10 and 1 respectively. Related Articles What Is Bin Range in Histogram?īin range in the histogram defines the series of intervals that divide the entire range of values of the dataset and then count how many values fall in those intervals.įor instance, you have this dataset: 1, 2, 2, 3, 3,6, 2, 10, 3.
