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. |