Forum Discussion

gkratz's avatar
gkratz
Copper Contributor
Nov 20, 2019

Default number of bins in histogram

Hi. I have a question: Which rule is used to compute the number of bins by default in a histogram? k=sqrt(n)? Where can I find the documentation?

 

Thank you for help. Best, Gilles

excel

3 Replies

  • gkratz's avatar
    gkratz
    Copper Contributor
    Nov 21, 2019

    Is it because my question is obvious? Because, I am really interested in knowing which discretization rule is used by default.

     

    I search on the web and I cannot find how the default number of bins is computed.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 21, 2019

      gkratz 

      I never seen any documentation about this topic and don't think it ever been published. =SQRT(N) doesn't work, usually it's plus-minus one bin from it, if not more. 

Resources