Cross Tabulation and Chi-square

The Cross Tabulation command displays the joint distribution of two or more variables in a matrix format and allows to compare the relationship between the variables. Cross tabulation table (also known as contingency or crosstab table) is generated for each distinct value of a layer variable and contains counts and percentages. Chi-square test is conducted to check if the results of a cross tabulation are statistically significant.

How To

ü  For unstacked data layout run the Statistics → Basic Statistics → Cross Tabulation and Chi-square command.

o   Select row variable (containing the categories that define the rows of the table) and column variable (containing the categories that define the columns of the table).

o   Optionally, select a frequency variable. Frequency variable specifies the number of observations that each row represents. When omitted, each row represents a single observation.

o   Optionally, select a layer variable. Layer variable distinct levels (values) cause separate tables generated. Layer variable is often called break variable, control variable or filter variable.

ü  Casewise deletion is used for missing values removal.

Results

Each table contains counts and percentages for all level combinations of both variables.

Observed– the total number of observations with a combination of row and column variables values.
Row Percent – the percentage each cell represents of the total observations in the row.
Column Percent - the percentage each cell represents of the total observations in the column.
Total Percent- the percentage each cell represents of the total observations in the table