• The statistics associated with each cell are calculated on values of the analysis columns from all observations in that category, as defined by the grouping columns.
 • All of the requested statistics have to reside in the same dimension, either in the row table or in the column table.
 • If you drag a continuous column into a data area, it is treated as an analysis column.
 – Dropping one or more grouping columns from the table to the % of Total heading changes the denominator definition. For this, Tabulate uses the sum of these grouping columns for the denominator.
 – To get the percentage of the column total, drag all the grouping columns on the row table and drop them onto the % of Total heading (same as Column %). Similarly, to get the percentage of the row total, drag all grouping columns on the column table and drop them onto the % of Total heading (same as Row %).
Provides the sum of all values in the column. This is the default statistic for analysis columns when there are no other statistics for the table.
Provides the sum of all weight values in a column. Or, if no column is assigned the weight role, Sum Wgt is the total number of nonmissing values.
Provides the standard error of the mean. It is the standard deviation divided by the square root of N. If a column is assigned the role of weight, then the denominator is the square root of the sum of the weights.
The nth root of the product of the data. For example, geometric means are often used to calculate interest rates. The statistic is also helpful when the data contains a large value in a skewed distribution.
 1 Click the Change Format button at the bottom of the Tabulate window.
 2
 3
 4
 5 Click OK to implement the changes and close the Format section, or click Set Format to see the changes implemented without closing the Format section.
Figure 8.89 Changing Numeric Formats

Help created on 10/11/2018