
Histogram is used to inspect the data for its underlying distribution, outliers, skewness, etc. The rectangles are colored or shaded.Ī Histogram will be as shown below. Thus, the horizontal axis represents the bins whereas the vertical axis represents the frequency. A rectangle over a bin with height proportional to the frequency of the bin depicts the number of cases in that bin. The bins must be adjacent and are of equal size. The bins are usually specified as consecutive, non-overlapping intervals of the variable. The numerical intervals are called bins and the number of occurrences is called frequency. What is a Histogram?Ī Histogram is represented by rectangles with lengths corresponding to the number of occurrences of a variable in successive numerical intervals.

In this case, when the source data is updated the chart also gets refreshed. In this chapter, you will learn how to create a Histogram from a Column chart.

However, in such a case, when the data is updated, Histogram will not reflect the changed data unless it is modified through Analysis ToolPak again. In Excel, you can create a Histogram from the Analysis ToolPak that comes as an add-in with Excel. It is widely used in Statistical Analysis. A Histogram is a graphical representation of the distribution of numerical data.
