Display Labels for Summary Statistics

This example uses the data file survey_sample.sav. See the topic Sample Files for more information.

In addition to the display formats for summary statistics, you can also control the descriptive labels for each summary statistic.

1. Open the table builder (Analyze menu, Tables, Custom Tables).
2. Click Reset to clear any previous settings in the table builder.
3. In the table builder, drag and drop Age category from the variable list into the Rows area on the canvas pane.
4. Drag and drop How get paid last week from the variable list into the Columns area on the canvas pane.
5. Right-click Age category in the table preview on the canvas pane and select Summary Statistics from the pop-up context menu.
6. Select Column N % in the Statistics list and click the arrow key to add it to the Display list.
7. Double-click anywhere in the word Column in the Label cell in the Display list to edit the contents of the cell. Delete the word Column from the label, changing the label to simply %.
8. Edit the Label cell for Count in the same way, changing the label to simply N.

   While we're here, let's change the format of the Column N % statistic to remove the unnecessary percentage sign (since the column label indicates that the column contains percentages).

9. Click the Format cell for Column N % and select nnnn.n from the drop-down list of formats.
10. Then click Apply to Selection.

    The table preview displays the modified display format and the modified labels.

11. Click OK to create the table.