Selecting Columns to Test

For the column proportions and column means tests, by default columns are tested in groups that are determined by the structure of the table. For example, in a table with three categories in the column variable, columns would be labeled A, B, and C, and the test would be carried out on all combinations of columns A-C. In nested tables, the columns of the inner nest level are repeated (and given unique IDs), and the test is carried out for each set of columns within the nesting level.

You can select the columns you want to test against each other using the See the topic Column Test for more information. Column Test button in the Statistics tab of the Table Properties dialog box.

All combinations of the columns that you specify are tested. Separate the column IDs using a forward slash character, for example:

"A/B/C"

This tests all combinations of columns A, B, and C.

You can specify separate groupings of columns to test by separating groups of columns with a comma, for example:

"A/C/E, B/D/F"

This tests all combinations of columns A, C, and E, and all combinations of columns B, D, and F.

Columns that you do not include are omitted from the tests. If you do not specify columns to test, the default column groupings are used.

Note: If you specify columns to test, ensure that the column IDs you specify exist in the table, and that they correspond to valid combinations of columns to test. You can check this by running the test first using the same table specification but with the default column selection.

ColumnsID property

Starting with IBM® SPSS® Data Collection Base Professional 5.6 you can define column IDs as a string using the ColumnsID property. Each character in the string is used to allocate a column ID, with a period or space character used to indicate that an ID should not be allocated. A character needs to be added to the ID's string for each column, even if the column is hidden. When allocating column IDs a character should also be added for the base columns.

For the table below, the column IDs could be set as follows to test Yes-Male against No-Male, and Yes-Female against No-Female:

Table.Statistics.ColumnIDs = "....MF.NG"
Table.Statistics.TestColumns = "M/N, F/G"
Column Proportions Test with New Column IDs

Note: Column IDs are only applied to visible table elements. Hidden elements are not taken in consideration when defining a Column IDs as a string.