Histogram maker

Generate the histogram chart, a graphical display of the count of observations that fall into each bin.
The data should be seperated by Enter or , (comma).
The tool ignores empty cells or non-numeric cells.


What is a histogram?

A histogram is a graphic representation of numerical data that shows the data distribution. When the number of observations is large, and the bin's size is small, the histogram will be similar to the distribution density chart.

How to create a histogram?

  1. Find the range of the numerical data Range = Max - Min.
  2. Choose the number of bins you prefer to present.
  3. Calculate the bin size: Bin size = Range/number of bins.
  4. For every bin count, the total number of observations falls in the bin.
  5. Present the data s a column chart, where each column represents the number of observations in a bin.

How to choose the number of bins?

When the number of observations is large you may use more bins. There are several ways to calculate the number of bins, for example: n- sample size. Number of bins = sqrt(n)
Number of bins = Range * n1/3 / 2 * IRQ
You may start with automatic calculation and adjust the bin size to your preferred histogram.

Should you exclude outliers?

Be careful before excluding outliers from any calculation, but excluding outliers from the histogram may improve the visualization significantly, even if the outliers are valid observations.
If you switch on the exclude outliers button, the histogram maker will generate the chart without the outliers, this method creates a more practical histogram.