Crosstabulation Tables Results - Advanced Tab

Crosstabulation and Stub-and-Banner Tables

Select the Advanced tab of the Crosstabulation Tables Results dialog box to access the options described here. These options provide a greater variety of results (spreadsheets and graphs) than the Quick tab.

Summary: Review summary tables. Click the Summary: Review summary tables button to produce summary tables for multi-way crosstabulation tables. If more than one table was specified, the Select the tables you want to review dialog box will be displayed, where you can select the table(s) to be displayed. The summary crosstabulation table will report the frequencies for the entire respective table; the last variable (factor) that makes up the table will be tabulated in the columns of the spreadsheet and all remaining variables (factors) will be tabulated in the rows. If there are more than two variables (factors) in a table, the structure of the table will be as if several two-way tables (for the last two factors) were "glued" together one-after-another for the different levels of the remaining factors. In this manner even 6-way tables can be reviewed in a single spreadsheet. The detail of results that are reported depends on the selections of options in the Compute tables group box (Options tab). Note that, if Expected frequencies or Residual frequencies are requested, then they will be computed simultaneously for the entire multi-way table, via iterative proportional fitting (e.g., see Haberman, 1972, 1974; see also the Log-Linear Analysis module). Specifically, expected frequencies are computed contingent upon the single-factor marginal tables; that is, it is assumed that there are no interactions between factors in the table. For three- or higher-way tables these values will be different from those that are displayed when Detailed two-way tables are requested, where the expected frequencies are computed based on the respective two-way tables alone.

Detailed two-way tables. Click the Detailed two-way tables button to produce spreadsheets with two-way tables. If more than one table was specified, the Select the tables you want to review dialog box will be displayed, where you can select the table(s) to be displayed. For tables with more than two variables (factors), a cascade of spreadsheets will be produced for the last two factors in the table, within the levels of the other factors. The detail of reported results depends on the choices of options in the Statistics for two-way tables group box as well as the Compute tables group box (see the Options tab). If any Statistics for two-way tables are selected, a spreadsheet with requested statistics will be computed for each two-way table.

Display long text labels. Select the Display long text labels check box to display the long text labels (entered in the Description field in the Text Labels Editor) in the first column of the results spreadsheets that are displayed when the Detailed two-way tables button is clicked. If the respective variable (factor) tabulated in the rows of a spreadsheet does not have any long text labels (none were specified in the Text Labels Editor), the setting of this check box will be ignored.

Include missing data. Select the Include missing data check box to add an extra category (level) for missing data to each variable (factor) in the table. Thus the table will show the number of missing cases crosstabulated with the other variables (factors), and all marginal frequencies and percentages will be adjusted accordingly.

Display selected %'s in sep. tables. Select the Display selected %'s in sep. tables check box to display the percentage tables in separate spreadsheets (this is desirable when you want to produce graphs of percentages from the spreadsheets). Note that this check box is only available (active) if one of the Percentages... options is selected in the Compute tables group box (see the Options tab). By default, this check box is not selected and if percentages are specified, they will be displayed in the same table together with the frequencies; thus, each cell in such results spreadsheets will consist of more than one line.

Categorized histograms. Click the Categorized histograms button to produce categorized histograms for selected tables. If more than one table was specified, the Select the tables you want to review dialog box will be displayed, which is used to select the table(s) for the plot(s). Note that each plot can summarize up to three variables (factors); that is, one categorized histogram can summarize a three-way table: The last (fastest changing) factor will be represented by the columns in the graph; the next-to-last factor will be represented by the different histograms "tabulated" horizontally; the third factor will be represented by the different histograms "tabulated" vertically. Cascades of categorized histograms are produced for tables with more than three factors.

Interaction plot of frequencies. Click the Interaction plot of frequencies button to produce interaction plot(s) for the selected table(s). If more than one table was specified, the Select the tables you want to review dialog box will be displayed, where you can select the table(s) for the plot(s). A line graph (interaction plot) is another way of summarizing the distribution of frequencies across up to three variables (factors). (If there are more than three factors in the respective table, a cascade of interaction plots will be produced for each combination of levels of the remaining factors.) In each graph, the last (fastest changing) factor will be represented by different line patterns and colors; the next-to-last factor will be represented by "upper-x" labels; the last factor will be represented by "lower-x" labels.

3D histograms. Click the 3D histograms button to produce 3D histograms for selected tables. If more than one table was specified, the Select the tables you want to review dialog box will be displayed, where you can select the table(s) for the plot(s). Each 3D histogram will summarize the joint frequency distribution for two variables (factors); it is in a sense the graphical equivalent to the Detailed two-way tables option (see above).