You use the Banding tab in the Edit Variable dialog box (see Edit Variable dialog box) and the New Variable dialog box (see New Variable dialog box) to create and edit bands for a numeric variable. The bands are created as new categories, and each one has an expression that defines the values in the numeric variable that are to be included in the category. You can also use the Banding tab in the Edit Axis dialog box (see Edit Axis dialog box); however, then the banding will apply to the current table only and will not be saved in the variable’s axis expression for future tables.

You can change the name of the bands, but they must conform to the rules for valid names and must be unique within the variable. See Naming conventions for more information.

This is the text that is shown on the table. You can change the label.

Defines the starting value for the band.

Defines whether the starting value is inclusive or exclusive. Inclusive means that the starting value is included in the band. Exclusive means that only values greater than the starting value are included.

Defines the end value for the band.

Defines whether the end value is inclusive or exclusive. Inclusive means that the end value is included in the band. Exclusive means that only values less than the end value are included.

You can specify the number of decimal places for statistical variables such as mean or standard deviation, and for other items such as totals and unweighted bases. The number of decimals you enter here overrides the value you enter for cell contents in the Preferences tab.

This shows the band's expression.

Add one or more bands above the selected item. See Insert Bands dialog box for more information.

Delete the selected band or bands.