What Is a Bin Range in Histogram?

By Staff WriterLast Updated Mar 29, 2020 1:16:32 PM ET
Anthia cumming/E+/Getty Images

In a histogram, a bin range is made up of data points that fall within many ranges. It is easy to create histograms, using bin ranges and other information, in Microsoft Excel.


A histogram is a chart that plots the frequency, or the rate or number of measurements, which fall within various intervals, or bins. Because these intervals collect data, they are called bins. In Excel, bin ranges help the user measure and compare test scores and other quantitative data. Also, when using Excel, the bin range needs to use quantitative numeric data, like test scores. For qualitative numeric data, such as student ID numbers, the Histogram tool will not work.

After all of the data is correctly placed on the worksheet, users can begin using the Histogram tool. Users should select the bin range, the input range, and the output location. Users can also choose to have an output chart displayed, so that users can visualize the data. Then, the Histogram tool analyzes all of the input information, calculates the output, and displays its findings in the next couple columns.

When using the Histogram tool, users can leave the bin range blank because evenly distributed bin intervals will be created using the minimum and maximum values in the input range. However, it is recommended that users create their own bins, especially for those who need an accurate analysis.