Summary Statistics

This feature requires the Custom Tables option.

The Summary Statistics dialog box allows you to:

  • Add and remove summary statistics from a table.
  • Change the labels for the statistics.
  • Change the order of the statistics.
  • Change the format of the statistics, including the number of decimal positions.

The summary statistics (and other options) available here depend on the measurement level of the summary statistics source variable, as displayed at the top of the dialog box. The source of summary statistics (the variable on which the summary statistics are based) is determined by:

  • Measurement level. If a table (or a table section in a stacked table) contains a scale variable, summary statistics are based on the scale variable.
  • Variable selection order. The default statistics source dimension (row or column) for categorical variables is based on the order in which you drag and drop variables onto the canvas pane. For example, if you drag a variable to the rows area first, the row dimension is the default statistics source dimension.
  • Nesting. For categorical variables, summary statistics are based on the innermost variable in the statistics source dimension.

A stacked table may have multiple summary statistics source variables (both scale and categorical), but each table section has only one summary statistics source.

To Change the Summary Statistics Source Dimension

  1. Select the dimension (rows, columns, or layers) from the Source drop-down list in the Summary Statistics group of the Table tab.

To Control the Summary Statistics Displayed in a Table

  1. Select (click) the summary statistics source variable on the canvas pane of the Table tab.
  2. In the Define group of the Table tab, click Summary Statistics.

    or

  3. Right-click the summary statistics source variable on the canvas pane and select Summary Statistics from the pop-up menu.
  4. Select the summary statistics you want to include in the table. You can use the arrow to move selected statistics from the Statistics list to the Display list, or you can drag and drop selected statistics from the Statistics list into the Display list.
  5. Click the up or down arrows to change the display position of the currently selected summary statistic.
  6. Select a display format from the Format drop-down list for the selected summary statistic.
  7. Enter the number of decimals to display in the Decimals cell for the selected summary statistic.
  8. Click Apply to Selection to include the selected summary statistics for the currently selected variables on the canvas pane.
  9. Click Apply to All to include the selected summary statistics for all stacked variables of the same type on the canvas pane.

Note: Apply to All differs from Apply to Selection only for stacked variables of the same type already on the canvas pane. In both cases, the selected summary statistics are automatically included for any additional stacked variables of the same type that you add to the table.

For information on available summary statistics, see:

Summary Statistics for Categorical Variables

Summary Statistics for Scale Variables and Categorical Custom Totals