The Tabulate Interactive Table
(Only appears if Show Chart is selected from the red triangle menu.) Enables you to specify a uniform custom scale.
(Only appears if Show Chart is selected from the red triangle menu.) Deselect this box for each column of bars to use the scale determined separately from the data in each displayed column.
If you prefer not to drag and drop and build the table interactively, you can create a simple table using the Dialog interface. After selecting Analyze > Tabulate, select Dialog from the menu, as shown in Using the Dialog. You can make changes to the table by selecting Show Control Panel from the red triangle menu, and then drag and drop new items into the table.
Using the Dialog
 • 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.
 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.
Changing Numeric Formats