This article describes how to go from having a numeric variable represented in aggregate:
To a state where you can assign a numeric variable into categories or bands (e.g., 0, 2-5, 6-10, 12+) for analysis purposes:
You will need to have a numeric variable. Numeric variables have a "2" next to them in the Data Sets tree:
A scaled nominal or ordinal variable if there is text involved with the value label (eg: 0 – Not at all likely and 10 – Extremely Likely are the endpoints of your scale). If using this type of variable, it is prudent to check the Values so that they align correctly with the labels. The Values button is just under the Structure dropdown in the object inspector as per the picture below. You don’t want a value of 1 ascribed to 0 - Not at all likely and so forth (it should be a value of 0). You should change it so that the correct value aligns with the label.
OPTIONAL: If your variable is numeric, select the variable in the Data Sets tree, and from the toolbar, click Duplicate to create a copy of the variable and then change the copied variable set structure to be nominal (or ordinal). As per the picture below, you change the structure in the object inspector > Inputs > Structure.
- Drag your nominal or ordinal variable onto the page to make a table.
- Select the categories you want to band together (using Ctrl or Shift) and drag the stacked brick icon () onto the last number in the band until you see the word Merge appear.
- From the toolbar, click Rename to give the banding a correct label.