Bin numeric values

Editing "Round by..." attribute

38d87d9852a66eea29da00ae16511664

Updated at October 16th, 2019

Protobi can bin numeric values into ranges for concise display and analysis.  

When a project is first opened, Protobi automatically bins numeric variables into ranges and you can change these to reflect your analysis goals.


"Round by..." dialogue

To edit rounding/binning, click the circle icon select "Round by..." from the context menu.

And you will get to the rounding dialogue

Protobi makes it easy to group data into the following options:

  • Auto — Auto-rounds based on the standard deviation
  • Log — Uses logarithmic ranges
  • Custom
    • Linear bins — Specify your desired equal bin size, e.g. [25]
    • Custom bins — Enter an array of cut-points, e.g. [10,25,50]

Auto bins

The setting "Auto" chooses a linear range with bin sizes automatically selected to generate a reasonable number of ranges given the standard deviation, with boundaries that snap to nice multiples of 5 or 10.

Log bins

Logarithmic ranges choose bin sizes that neatly map to multiples of 10, 25, and 50, resulting in small ranges for small numbers and bigger ranges for bigger numbers.  

Log ranges generally make sense for unbounded numbers and absolute counts, such as income, number of customers, or patient volume.  

Linear bins

Here we set "Round by" to Custom: 10 

which generates ranges of equal width:

Linear ranges are inclusive of the upper bounds, and exclusive of lower bounds, and rounded to reasonable precision for display. So in above example, the range "21 to 30" really represents "20 < Q3 <= 30".

Custom bins

It's possible to choose arbitrary ranges by specifying a list of "cut points", separated by commas. Here we set "Round by" to 10,25,50:

which generates bands with the specified values as upper bounds:

Alternately, it's possible to specify custom ranges that are lower-inclusive by specifying them with as follows, with a square bracket on the left, and a round-parenthesis on the right, e.g. [0,10,25,50)


Was this article helpful?