How to Use Binning


To use the binning tool:

  1. On the menu bar, select Data > Add binned column.

  2. If you have more than one data table in the analysis, 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 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 Add Binned Column