Cross-Tabulation Analysis

Cross-Tabulation is used to show relationships between answers made for two survey questions. The responses (variable) from two questions are displayed in a table. The choices for the first question are displayed to the left (the row labels) of the table data. The second question choices are displayed across the top of the table (the column headings). The counts indicate the number of survey responses that matched both the column heading choice and the row label choice. Cross tabulations are also know as pivot tables.


Select the two survey question numbers by selecting the question options, then click on the Create button. The results are displayed on the View Analysis page. For each choice for the first question, the totals for all choices of the second question are found. Topics entered with the survey questions are also used with the column headings.

The survey question type and number of question choices determines the number of options for the selected question. The top 9 text responses for an Open-Text question are used for the cross-tabulation analysis.

Report options common to the different report screens are explained in the Introduction to Survey Analysis section of the help file. Settings unique to this screen are described on this help page.

If the Automatic Calculation check box is marked, and the question types are valid, the calculation can be performed before this window is displayed.

Use Letter Column Headings
If checked, each of the question choices would be represented by a letter. If unchecked the choice text is displayed in the column heading.

Use All Single Select Text Choices
If a Single select question is used in an analysis, either the top 25 or all choices can be included if the question is the first question.

Include Cross-Tabulation Counts, Row Percents, and Column Percents
The analysis can show any combination of the counts of each cross-tabulation, the row percentages, and column percentages of each cell.

Include Question Summary Counts Below Table
Below the pivot table, each question, and the total responses to each choice are included in the report.

Percent Decimal Places
The number displayed next to the spinner determines the number of decimal places (up to 4) displayed for the column and row percentages.

Report Data Column Width Percentage
The width of the data columns can be varied. The left column is usually the question choice text. The remaining data columns occupy the rest of the report width.

Number of Data Columns per Table
Sometimes changing the number of columns displayed in a table, makes a better presentation. If checked the number of columns in each table will be changed. This is usually effective when a large number of choices requires multiple tables to display the analysis.

Pivot Tables
Clicking the Pivot Data button will switch the first and second questions. The tables and charts will also be changed.

cross-tabulation report

cross-tabulation HTML

View Chart (Professional Version Only)
The panel buttons at the top and left side of the charts let you have complete control over colors, titles, axes, ticks, legends, 3-D, chart type, fonts, marks, labels, tilting, order, zoom, and print preview. Charts can be saved as a Bitmap, JPEG, PCX, PNG, Metafile, and Enhanced MetaFile formatted files. A description for the use of each of the panel buttons is located in the Chart Editor section of this manual.

cross-tabulation chart

Page last updated: January 26, 2008