![\"bar_xtab_items_age\"](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/01\/bar_xtab_items_age.png\")
<\/a><\/p>\nIt also shows how to create crosstabs for all relevant questions in your survey with a single instruction.<\/p>\n
<\/a><\/p>\n A crosstab is a table where the analysis field gives the rows and the break field gives the columns (this can be reversed by selecting the Transpose <\/b>option).<\/p>\n The data in each cell show the figure for the respondents who fit into both the column and the row. The type and order of data displayed is given by the Show <\/b>options.<\/p>\n You can order the rows by:<\/p>\n See more \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n This example shows how to break down responses by gender. (It uses data in the crocodile survey supplied with Snap.)<\/p>\n Show example \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n This example shows how to set out data so it’s easy to see which choices were most popular. The analysis shows which items were ordered (with a breakdown by age), and sorts them according to popularity.<\/p>\n The default row order is the order that the items were listed in the questionnaire. To make it easy to see which choice was the most popular, you can order the rows by the analysis value<\/p>\n You can easily display your data in chart form. Open the Analysis Definition<\/span> dialog and change the Type <\/b>to Chart<\/b>. The example below shows it with a style of Horizontal Bar Counts<\/b>. You can see that the items ordered have been sorted by the Analysis base<\/b>, with the most popular at the top.<\/p>\n Show example \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n You can create a report of separate crosstabs using the same break (for example, break all the responses down by age or gender or both) with a single instruction in a report. The example below breaks down the questions in the crocodile report by age.<\/p>\n Analysis<\/span>: Q2,Q4,Q6a TO Q6e<\/span><\/p>\n Break<\/span>: Q9<\/span><\/p>\n Set the Order by<\/b> dropdown to Default<\/b>. Ordering is not appropriate for rating scales.<\/p>\n The instruction will generate one crosstab for each question that you put in the analysis field. Literal, date and quantity questions have been excluded.<\/p>\n<\/li>\n Show example \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n You can also break down the data in your tables by using filters. This example shows how to produce a set of age tables for males and a set of age tables for females.<\/p>\n You can convert all the tables to charts by changing the instruction type and style.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n Show example \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n <\/a><\/p>\n You can see more about analysis in the section Analyzing your case data<\/a>.<\/p>\n Learn more about analyzing results in Snap on our Analysing Results course (https:\/\/www.snapsurveys.com\/training\/course-outline-analysing-survey-results\/<\/a>)<\/p>\n You can find out about styling your tables in the help section: Table appearance<\/a><\/p>\n If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":"Background<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n\n
Creating a simple crosstab<\/h3>\n
\n
<\/a>\u00a0to display the Analysis Definition<\/span> dialog.<\/li>\n<\/a><\/p>\n<\/li>\n<\/a>\u00a0on the top left of the table window toolbar to display the Analysis Definition<\/span> dialog.<\/li>\n<\/a><\/p>\n<\/li>\n<\/a><\/p>\n<\/li>\n<\/a><\/p>\n<\/li>\n<\/a>\u00a0to save the table.<\/li>\n<\/ol>\n<\/div>\nCreating an ordered crosstab<\/h3>\n
\n
<\/a>\u00a0to display the Analysis Definition<\/span> dialog.<\/li>\n<\/a><\/p>\n<\/li>\n<\/ol>\n\n
<\/a>\u00a0on the table toolbar to open the Analysis Definition<\/span> dialog again.\n<\/a><\/p>\n<\/li>\n<\/a><\/p>\n<\/li>\n<\/a>.<\/li>\n<\/ol>\n<\/a><\/p>\n<\/div>\nQuickly building multiple crosstabs in a report<\/h3>\n
\n
<\/a>\u00a0to display the Reports<\/span> window.<\/li>\n<\/a>\u00a0to create a new report. Set the labels to a description of your report and select Skip Empty <\/b>to omit any empty analyses.<\/span>\n<\/a><\/p>\n<\/li>\n<\/a>\u00a0to create a new instruction and select Table<\/b> in the Instruction List<\/span> to display a Report instruction dialog.<\/li>\n<\/a>\u00a0on the Report window toolbar to open the Report execution dialog. (You will be asked if you want to save the report. Click [Yes]<\/b>.)<\/li>\nProducing crosstabs filtered by demographic<\/h3>\n
\n
<\/a><\/p>\n<\/li>\n<\/a>\u00a0to open the Report execution dialog. (You will be asked if you want to save the report. Click [Yes]<\/b>.)<\/li>\nFurther reading<\/h3>\n