Make Binning Formula

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Enter and Edit Data • Restructure Data • Make Binning Formula

•

Make Binning Formula

You can distribute your data into equal width bins using the Make Binning Formula option. Select the column or columns that you want to divide into bins, and select Cols > Utilities > Make Binning Formula. New formula columns are added to the data table.

The Make Binning Formula window contains the following options:

Select a format for displaying the range of values in the bin. You can see a preview by moving the cursor over the graph.

Bin Shape: Offset

Select an offset value for the lower edge of the bins.

Note: Bins are identified by their lower edge. The lower edge is in the bin. The upper edge is in the next bin because it is the next bin's lower edge.

Bin Shape: Width

Select the width of values for the bins.

Note: The colored bands reflect the offset and the width of the bins with respect to the data.

Specify whether value labels are shown instead of the data values.

–

Select Use Value Labels to show a label instead of the value.

–

Select Use Range Values to include the lower and upper values for each range in the label.

–

Select No Labels to use the lower edge value as the label.

For more information, see Value Labels in The Column Info Window.

Tip: Value Labels are recommended in most platforms, many of which do not support range labels. In the Categorical platform, you must use value labels. On some axes, you might find that range labels more clearly identify the values, or you can try adjusting the offset and width for the axis.

Make All Like X

(Appears only if multiple columns are selected) Applies the choices made for the first column (X) to the remaining columns.

Make Formula Columns

Creates the formula columns and closes the window.

Example of Making a Binning Formula

1.

Select Help > Sample Data Library and open Big Class.jmp.

2.

Select the height column.

3.

Select Cols > Utilities > Make Binning Formula.

You want the range of values to appear as X-X, so keep the range set to Low - High.

4.

Change the offset to -0.5.

Tip: For integer data, setting the offset to -0.5 helps disambiguate values on the edge. In this example, one of the bins covers 59.5 to 64.5, so it is clear that 59 and 65 are not included in this bin.

5.

Keep the width set to 5.

6.

For the labels, keep it set to Use Value Labels, so that you can see the range of values for the bin.

Figure 3.36 Completed Binning Window

7.

Click Make Formula Columns.

A column called height Binned is added to the Big Class.jmp data table.

8.

To see how the formula is calculated, right-click on the height Binned column and select Formula.

Figure 3.37 Formula

•

Help created on 7/12/2018