Histogram Explained

A histogram is a visual representation of the distribution of quantitative data. The term was first introduced by Karl Pearson.[1] To construct a histogram, the first step is to "bin" (or "bucket") the range of values— divide the entire range of values into a series of intervals—and then count how many values fall into each interval. The bins are usually specified as consecutive, non-overlapping intervals of a variable. The bins (intervals) are adjacent and are typically (but not required to be) of equal size.[2]

Histograms give a rough sense of the density of the underlying distribution of the data, and often for density estimation: estimating the probability density function of the underlying variable. The total area of a histogram used for probability density is always normalized to 1. If the length of the intervals on the x-axis are all 1, then a histogram is identical to a relative frequency plot.

Histograms are sometimes confused with bar charts. In a histogram, each bin is for a different range of values, so altogether the histogram illustrates the distribution of values. But in a bar chart, each bar is for a different category of observations (e.g., each bar might be for a different population), so altogether the bar chart can be used to compare different categories. Some authors recommend that bar charts always have gaps between the bars to clarify that they are not histograms.[3] [4]

Examples

This is the data for the histogram to the right, using 500 items:

Bin/IntervalCount/Frequency
−3.5 to −2.51 9
−2.5 to −1.51 32
−1.5 to −0.51 109
−0.5 to 0.49 180
0.5 to 1.49 132
1.5 to 2.49 34
2.5 to 3.49 4

The words used to describe the patterns in a histogram are: "symmetric", "skewed left" or "right", "unimodal", "bimodal" or "multimodal".

It is a good idea to plot the data using several different bin widths to learn more about it. Here is an example on tips given in a restaurant.

The U.S. Census Bureau found that there were 124 million people who work outside of their homes.[5] Using their data on the time occupied by travel to work, the table below shows the absolute number of people who responded with travel times "at least 30 but less than 35 minutes" is higher than the numbers for the categories above and below it. This is likely due to people rounding their reported journey time. The problem of reporting values as somewhat arbitrarily rounded numbers is a common phenomenon when collecting data from people.

Data by absolute numbers
Interval Width Quantity Quantity/width
0 5 4180 836
5 5 13687 2737
10 5 18618 3723
15 5 19634 3926
20 5 17981 3596
25 5 7190 1438
30 5 16369 3273
35 5 3212 642
40 5 4122 824
45 15 9200 613
60 30 6461 215
90 60 3435 57

This histogram shows the number of cases per unit interval as the height of each block, so that the area of each block is equal to the number of people in the survey who fall into its category. The area under the curve represents the total number of cases (124 million). This type of histogram shows absolute numbers, with Q in thousands.

Data by proportion
Interval Width Quantity (Q) Q/total/width
0 5 4180 0.0067
5 5 13687 0.0221
10 5 18618 0.0300
15 5 19634 0.0316
20 5 17981 0.0290
25 5 7190 0.0116
30 5 16369 0.0264
35 5 3212 0.0052
40 5 4122 0.0066
45 15 9200 0.0049
60 30 6461 0.0017
90 60 3435 0.0005

This histogram differs from the first only in the vertical scale. The area of each block is the fraction of the total that each category represents, and the total area of all the bars is equal to 1 (the fraction meaning "all"). The curve displayed is a simple density estimate. This version shows proportions, and is also known as a unit area histogram.

In other words, a histogram represents a frequency distribution by means of rectangles whose widths represent class intervals and whose areas are proportional to the corresponding frequencies: the height of each is the average frequency density for the interval. The intervals are placed together in order to show that the data represented by the histogram, while exclusive, is also contiguous. (E.g., in a histogram it is possible to have two connecting intervals of 10.5–20.5 and 20.5–33.5, but not two connecting intervals of 10.5–20.5 and 22.5–32.5. Empty intervals are represented as empty and not skipped.)[6]

Mathematical definitions

The data used to construct a histogram are generated via a function mi that counts the number of observations that fall into each of the disjoint categories (known as bins). Thus, if we let n be the total number of observations and k be the total number of bins, the histogram data mi meet the following conditions:

n=

k{m
\sum
i}.
A histogram can be thought of as a simplistic kernel density estimation, which uses a kernel to smooth frequencies over the bins. This yields a smoother probability density function, which will in general more accurately reflect distribution of the underlying variable. The density estimate could be plotted as an alternative to the histogram, and is usually drawn as a curve rather than a set of boxes. Histograms are nevertheless preferred in applications, when their statistical properties need to be modeled. The correlated variation of a kernel density estimate is very difficult to describe mathematically, while it is simple for a histogram where each bin varies independently.

An alternative to kernel density estimation is the average shifted histogram,[7] which is fast to compute and gives a smooth curve estimate of the density without using kernels.

Cumulative histogram

A cumulative histogram is a mapping that counts the cumulative number of observations in all of the bins up to the specified bin. That is, the cumulative histogram Mi of a histogram mj is defined as:

Mi=

i{m
\sum
j}.

Number of bins and width

There is no "best" number of bins, and different bin sizes can reveal different features of the data. Grouping data is at least as old as Graunt's work in the 17th century, but no systematic guidelines were given until Sturges's work in 1926.

Using wider bins where the density of the underlying data points is low reduces noise due to sampling randomness; using narrower bins where the density is high (so the signal drowns the noise) gives greater precision to the density estimation. Thus varying the bin-width within a histogram can be beneficial. Nonetheless, equal-width bins are widely used.

Some theoreticians have attempted to determine an optimal number of bins, but these methods generally make strong assumptions about the shape of the distribution. Depending on the actual data distribution and the goals of the analysis, different bin widths may be appropriate, so experimentation is usually needed to determine an appropriate width. There are, however, various useful guidelines and rules of thumb.[8]

The number of bins k can be assigned directly or can be calculated from a suggested bin width h as:

k=\left\lceil

maxx-minx
h

\right\rceil.

The braces indicate the ceiling function.

Square-root choice

k=\lceil\sqrt{n}\rceil

which takes the square root of the number of data points in the sample and rounds to the next integer. This rule is suggested by a number of elementary statistics textbooks [9] and widely implemented in many software packages.[10]

Sturges's formula

Sturges's rule[11] is derived from a binomial distribution and implicitly assumes an approximately normal distribution.

k=\lceillog2n\rceil+1,

Sturges's formula implicitly bases bin sizes on the range of the data, and can perform poorly if, because the number of bins will be small—less than seven—and unlikely to show trends in the data well. On the other extreme, Sturges's formula may overestimate bin width for very large datasets, resulting in oversmoothed histograms.[12] It may also perform poorly if the data are not normally distributed.

When compared to Scott's rule and the Terrell-Scott rule, two other widely accepted formulas for histogram bins, the output of Sturges's formula is closest when .[12]

Rice rule

k=\lceil2\sqrt[3]{n}\rceil

The Rice rule[13] is presented as a simple alternative to Sturges's rule.

Doane's formula

Doane's formula[14] is a modification of Sturges's formula which attempts to improve its performance with non-normal data.

k=1+log2(n)+log2\left(1+

|g1|
\sigma
g1

\right)

where

g1

is the estimated 3rd-moment-skewness of the distribution and
\sigma
g1

=\sqrt{

6(n-2)
(n+1)(n+3)

}

Scott's normal reference rule

Bin width

h

is given by

h=

3.49\hat\sigma
\sqrt[3]{n
},

where

\hat\sigma

is the sample standard deviation. Scott's normal reference rule[15] is optimal for random samples of normally distributed data, in the sense that it minimizes the integrated mean squared error of the density estimate.[16] This is the default rule used in Microsoft Excel.[17]

Terrell–Scott rule

k=\sqrt[3]{2n}

The Terrell–Scott rule[12] [18] is not a normal reference rule. It gives the minimum number of bins required for an asymptotically optimal histogram, where optimality is measured by the integrated mean squared error. The bound is derived by finding the 'smoothest' possible density, which turns out to be

3
4

(1-x2)

. Any other density will require more bins, hence the above estimate is also referred to as the 'oversmoothed' rule. The similarity of the formulas and the fact that Terrell and Scott were at Rice University when the proposed it suggests that this is also the origin of the Rice rule.

Freedman–Diaconis rule

The Freedman–Diaconis rule gives bin width

h

as:[19] [16]

h=2

\operatorname{IQR
(x)}{\sqrt[3]{n}},

which is based on the interquartile range, denoted by IQR. It replaces 3.5σ of Scott's rule with 2 IQR, which is less sensitive than the standard deviation to outliers in data.

Minimizing cross-validation estimated squared error

This approach of minimizing integrated mean squared error from Scott's rule can be generalized beyond normal distributions, by using leave-one out cross validation:[20] [21]

\underset{h}{\operatorname{argmin}}\hat{J}(h)=\underset{h}{\operatorname{argmin}}\left(

2
(n-1)h

-

n+1
n2(n-1)h

\sumk

2
N
k

\right)

Here,

Nk

is the number of datapoints in the kth bin, and choosing the value of h that minimizes J will minimize integrated mean squared error.

Shimazaki and Shinomoto's choice

The choice is based on minimization of an estimated L2 risk function[22]

\underset{h}{\operatorname{argmin}}

2\bar{m
-

v}{h2}

where

style\bar{m}

and

stylev

are mean and biased variance of a histogram with bin-width

styleh

,
style\bar{m}=1
k
k
\sum
i=1

mi

and

stylev=

1
k
k
\sum
i=1

(mi-\bar{m})2

.

Variable bin widths

Rather than choosing evenly spaced bins, for some applications it is preferable to vary the bin width. This avoids bins with low counts. A common case is to choose equiprobable bins, where the number of samples in each bin is expected to be approximately equal. The bins may be chosen according to some known distribution or may be chosen based on the data so that each bin has

n/k

samples. When plotting the histogram, the frequency density is used for the dependent axis. While all bins have approximately equal area, the heights of the histogram approximate the density distribution.

For equiprobable bins, the following rule for the number of bins is suggested:[23]

k=2n2/5

This choice of bins is motivated by maximizing the power of a Pearson chi-squared test testing whether the bins do contain equal numbers of samples. More specifically, for a given confidence interval

\alpha

it is recommended to choose between 1/2 and 1 times the following equation:[24]

k=4\left(

2n2
\Phi-1(\alpha)
1
5
\right)

Where

\Phi-1

is the probit function. Following this rule for

\alpha=0.05

would give between

1.88n2/5

and

3.77n2/5

; the coefficient of 2 is chosen as an easy-to-remember value from this broad optimum.

Remark

A good reason why the number of bins should be proportional to

\sqrt[3]{n}

is the following: suppose that the data are obtained as

n

independent realizations of a bounded probability distribution with smooth density. Then the histogram remains equally "rugged" as

n

tends to infinity. If

s

is the "width" of the distribution (e. g., the standard deviation or the inter-quartile range), then the number of units in a bin (the frequency) is of order

nh/s

and the relative standard error is of order

\sqrt{s/(nh)}

. Compared to the next bin, the relative change of the frequency is of order

h/s

provided that the derivative of the density is non-zero. These two are of the same order if

h

is of order

s/\sqrt[3]{n}

, so that

k

is of order

\sqrt[3]{n}

. This simple cubic root choice can also be applied to bins with non-constant widths.

Applications

See also

Further reading

External links

  1. Pearson . K. . Karl Pearson. Contributions to the Mathematical Theory of Evolution. II. Skew Variation in Homogeneous Material. Philosophical Transactions of the Royal Society A: Mathematical, Physical and Engineering Sciences. 186. 343–414. 1895. 10.1098/rsta.1895.0010. 1895RSPTA.186..343P . free.
  2. Book: Howitt . D. . Cramer . D. . 2008 . Introduction to Statistics in Psychology . Prentice Hall . Fourth . 978-0-13-205161-3 .
  3. Web site: Naomi . Robbins . A Histogram is NOT a Bar Chart . Forbes . 31 July 2018.
  4. M. Eileen Magnello. December 2006. Karl Pearson and the Origins of Modern Statistics: An Elastician becomes a Statistician. The New Zealand Journal for the History and Philosophy of Science and Technology. 1 volume. 682200824.
  5. https://www.census.gov/prod/2004pubs/c2kbr-33.pdf US 2000 census
  6. Dean, S., & Illowsky, B. (2009, February 19). Descriptive Statistics: Histogram. Retrieved from the Connexions Web site: http://cnx.org/content/m16298/1.11/
  7. David W. Scott . December 2009 . Averaged shifted histogram . Wiley Interdisciplinary Reviews: Computational Statistics . 2 . 2 . 160–164 . 10.1002/wics.54. 122986682 .
  8. e.g. § 5.6 "Density Estimation", W. N. Venables and B. D. Ripley, Modern Applied Statistics with S (2002), Springer, 4th edition. .
  9. Web site: Lohaka . H.O. . 2007 . Making a grouped-data frequency table: development and examination of the iteration algorithm . Doctoral dissertation, Ohio University . 87.
  10. Web site: MathWorks: Histogram.
  11. Sturges . H. A. . 1926 . The choice of a class interval . Journal of the American Statistical Association . 21 . 153 . 65–66 . 2965501 . 10.1080/01621459.1926.10502161 .
  12. Scott. David W.. Sturges' rule. WIREs Computational Statistics. 1. 3. 2009. 303–306 . 10.1002/wics.35. 197483064 .
  13. Online Statistics Education: A Multimedia Course of Study (http://onlinestatbook.com/). Project Leader: David M. Lane, Rice University (chapter 2 "Graphing Distributions", section "Histograms")
  14. Doane DP (1976) Aesthetic frequency classification. American Statistician, 30: 181–183
  15. Scott . David W. . 1979 . On optimal and data-based histograms . Biometrika . 66 . 3. 605–610 . 10.1093/biomet/66.3.605.
  16. Book: Scott, David W.. Multivariate Density Estimation: Theory, Practice, and Visualization. John Wiley. New York. 1992.
  17. Web site: Excel:Create a histogram.
  18. Terrell, G.R. and Scott, D.W., 1985. Oversmoothed nonparametric density estimates. Journal of the American Statistical Association, 80(389), pp.209-214.
  19. Freedman . David . Diaconis, P. . 1981 . On the histogram as a density estimator: L2 theory . Zeitschrift für Wahrscheinlichkeitstheorie und Verwandte Gebiete . 57 . 4 . 453–476 . 10.1007/BF01025868. 10.1.1.650.2473 . 14437088 .
  20. Book: Wasserman, Larry. All of Statistics. Springer. 2004. 978-1-4419-2322-6. New York. 310.
  21. An asymptotically optimal histogram selection rule . Charles J. . Stone . 1984 . Proceedings of the Berkeley conference in honor of Jerzy Neyman and Jack Kiefer .
  22. Shimazaki . H. . Shinomoto, S. . A method for selecting the bin size of a time histogram . Neural Computation . 19 . 6 . 1503–1527 . 2007 . 17444758 . 10.1162/neco.2007.19.6.1503. 10.1.1.304.6404. 7781236 .
  23. Web site: Jack Prins . Don McCormack . Di Michelson . Karen Horrell . Chi-square goodness-of-fit test . NIST/SEMATECH e-Handbook of Statistical Methods . NIST/SEMATECH . 29 March 2019 . 7.2.1.1.
  24. Book: Moore . David . D'Agostino . Ralph . Stephens . Michael . Goodness-of-Fit Techniques . 1986 . Marcel Dekker Inc. . New York, NY, US . 0-8247-7487-6 . 70 . 3.
  25. https://www.waterlog.info/density.htm An illustration of histograms and probability density functions