Return to site

Excel histogram bins

broken image
broken image

The decision clearly depends on the number of values.

broken image
broken image

If you want to create a frequency distribution with equally spaced bins, you need to decide how many bins (or the width of each). Either a dot plot, or a cumulative frequency distribution, which doesn't require any bins. One solution is to create a graph that shows every value. If you have too many bins, you get a broken comb look, which also doesn't give a sense of the distribution. If you use too few bins, the histogram doesn't really portray the data very well.

broken image