How to Use Binning


  1. Select Insert > Binned Column....

  2. If you have more than one data table in the document, select the Data table to work on.

  3. Select a Column to bin.

  4. Select a Bin method:

    Specific Limits

    Allows you to explicitly enter values, separated by semicolons, of the limits to use for each bin.

    Even Intervals

    Allows you to specify the desired number of bins and divides the value range into equal intervals.

    Even Distribution of Unique Values

    Allows you to specify the desired number of bins and divides the bins so that each one contains an equal number of unique values.

    Based on Standard Deviation

    Allows you to divide the range into sections as described by the selected standard deviation multipliers.

    Substring

    Allows you to group the values by the first or last characters in the column to be binned.
    Values
    Allows you to group categorical values into bins.

  5. Type a New column name for the binned column.

  6. Click OK.

Tip: Right-click on a column selector and select Auto-bin Column to create a temporary, automatic binning on an axis. Binning functions can also be used in custom expressions.

See also:

What is Binning?

Details on Insert Binned Column