How To Make A Histogram In Excel – 2 methods

3.6 min read|Last Updated: September 4th, 2023|Categories: excel|

A Histogram Chart is a precise plot to indicate the frequency dispensation of numerical data. Karl Pearson presented a histogram for use in Statistical Analysis.

Learn more about the concept of histogram in Wikipedia.

Excel Histogram Bin Range

Disarticulating the data into intervals (which is called BINs), and the number of incidences (which is called frequency), creates a histogram. Bins are generally determined as successive, and they must be adjoining too. Meanwhile, they’re defined as the non-overlapping distance of the variables.

The data must be measured on an extendable criterion, for example, volume, time, temperature, etc.

Histogram demonstrates the optical deputation of data dispensation, to figure out the usage of a histogram, we’ll bring up a plain example.

Assume some information is collected about the air pollution level in City A for 20 days.

Picture 1- The air pollution level in City A 

The difference between a histogram chart and a bar chart is, a histogram relates only one variable, but a bar chart is pertinent to two. So there is no gap in the data in a histogram chart. Also, histogram charts are based on area.

The Main Prerequisite (For Excel 2007, 2010 & 2013)

For statistical applications, Excel has an add-in program that provides data analysis tools, which is called ANALYSIS TOOLPACK. To run this data analysis tool, follow these steps, please (because it’s disabled in default setting):

1. Click on the File Tab.

2. Select Options.

3. Click on the Add-Ins menu from the sidebar.

4. Select “Excel Add-ins” and then click “Go” from the Manage dropdown menu. 

5. Check the “Analysis ToolPak” box and then click “OK.”

video 1- how to enable Analysis ToolPak