# Histogram

Viewing 8 posts - 1 through 8 (of 8 total)
• Author
Posts
• #45824

Bonnie
Participant

Hi,
Could some body explain how to calculate the bin size (class interval) for constructing a histogram.
Thanks in advance for your kind help.
Warm Regards,
Bon

0
#150593

Participant

Bonnie, Hello!Thanks for your posting. This thread from a few years ago covers this material, I think — see what you think:https://www.isixsigma.com/library/forum/c031022_number_bins_histogram.aspBest regards,QualityColorado

0
#150595

Atkins
Participant

I usually take the range of the data and divide by 10 (cells).  The I take whatever the interval came up to be and round it off to something that will give me reasonable cell intervals (e.g., whole numbers in an ideal world).  The actual number of cells then is whatever that rounded number turns out to create.

0
#150596

Atkins
Participant

I usually take the range of the data and divide by 10 (cells).  The I take whatever the interval came up to be and round it off to something that will give me reasonable cell intervals (e.g., whole numbers in an ideal world).  The actual number of cells then is whatever that rounded number turns out to create.

0
#150602

Theo
Member

It is refreshing to see you are plotting manually.  You will learn more this way rather than blindly using software like most people.  Software can very much lead people astray, such as the idiotic normal distributions I see plotted over so many histograms.
Data Points   Bins
50-100          6-10
100-250        7-12
>250              10-20

0
#150604

Mikel
Member

Manually plotting histograms with an arbitrarily picked number of bins can very much lead people astray. You can create things that look like probelms with the data when no problem exists and you can visully hide things. Much worse than a little curve that is meant as a reference not a test.
Do you think that just because the guy wants to know how to do bins, he is plotting manually? He is trying to use Excel.  Go create a histogram with Excel and see how the labels do not correspond to the data. Pretty idiotic.to use such functionality when so much better help is out there.
By the way the advice on bins is =sqrt(n) and adjust slightly to make logical bins.

0
#150729

bstout
Participant

There is a very general rule called Sturgis’ or Sturges’ Rule with the following formula:
(Maximum value minus minimum value) divided by (1+3.322*log(n)) where n is the count of the number of observations.  If you round this number it represents a fair approximation of bin size.  This formula attempts to give as close to a normal distribution as the raw data will allow.  You can then use the frequency  function in Excel to create bins and categorize the data by bin.
Hope this helps.
Bill

0
#150759

Bonnie
Participant

Thanks Bill,
Something like this is what I was looking for. This really helped.
Cheers,
Bon

0
Viewing 8 posts - 1 through 8 (of 8 total)

The forum ‘General’ is closed to new topics and replies.