Special Values in Summary Table Functions

When you make a formula for a quantity to be included in a summary table (often by choosing Add Formula from the Summary menu or from the right-mouse popup), there are special variables you can use. Find them under Special in the function list. That part of the function list will look like this:

There are new special variables peculiar to summary tables, and are especially useful if your summary table has a categorical attribute on each "axis.". Here is what they mean:

columnProportion

the proportion of cases in this column that fall in this cell. Equivalent to count( )/columnTotal.

columnTotal

the total number of cases in this column.

expected

the expected number of cases if the two categorical attributes are independent (if there is only one categorical attribute, this is the same as count( ) ).

grandTotal

the total number of cases in the entire table.

rowProportion

the proportion of cases in this row that fall in this cell. Equivalent to count( )/rowTotal.

rowTotal

the total number of cases in this row.

 

Other special values in the formula editor