![\"QW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/4_quest.png\")
<\/p>\nThis worksheet explains how to set up cross-tabs (pivot tables, contingency tables) in Snap. It assumes that you have a questionnaire with four questions (shown below) and shows you how to create a single table combining the data from the four questions.<\/p>\n
<\/p>\n
This worksheet only covers category variables (variables with coded answers).<\/p>\n Snap allows you to create cross-tabs and charts from category variables where one variable’s codes provide the columns and another variable’s codes provide the rows. It is possible to combine category variables in your analysis.<\/p>\n There are three ways of combining category variables in a cross-tab in Snap.<\/p>\n All the codes are treated as if they belonged to a single variable, with one column per code<\/p>\n Every combination of codes available between the variables is given a column<\/p>\n The codes can be logically AND<\/b>ed together so you get a count if both codes have been selected<\/p>\n The codes can be logically OR<\/b>ed together so you get a count if either code has been selected<\/p>\n This is not dealt with in this worksheet<\/p>\n<\/div>\n See more \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n This shows you how to create four simple cross-tabs showing people’s liking for cheese and chocolate by age and gender and then shows how to combine them into a single table. It also discusses missing answers. If you add percent scores to your cross-tabs, you need to be clear if you are displaying a percentage of all those who took the survey or all those who answered the question. You can include or exclude respondents who have not answered a question.<\/p>\n The survey example had 100 respondents. None of the questions has been answered by all of them.<\/p>\n See more \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n See more \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n This worksheet has described how to combine several variables in a single analysis<\/p>\n You can see more about analysis in the section Analyzing your case data<\/a><\/p>\n There is a description of Operators in the Analysis and Break fields<\/a> in the help.<\/p>\n There is a reference list of all possible Axis Expressions<\/a> (expressions that you can use in the analyses axes) in the help.<\/p>\n If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Background<\/h3>\n
\n\n
\n
\n
Step 1: Creating a simple cross-tab and dealing with missing responses<\/h3>\n
\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/vl_4var.png\")
<\/p>\n\n
![\"Table](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/table.png\")
to open the Analysis Definition<\/span> dialog.<\/li>\n![\"RD:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/def_tabq1q3.png\")
<\/li>\n![\"Save](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/save.png\")
on the table toolbar to save the table.<\/li>\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/4_xtabs_hl.png\")
Note that the Base <\/b>used in the tables is different. This is because the analysis base consists of people who have answered both questions. This is because the analysis excludes no reply responses.<\/li>\n![\"Properties](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/var_prop.png\")
on a table toolbar for AN3<\/b> to open the Analysis Definition<\/span> dialog for that table (liking cheese by age).<\/li>\n
\n![\"RD:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/bas_co_show2.png\")
\nA new row and a new column are added to your analysis, showing the no replies, and the percentages are re-calculated as percentages of the new base. (You can change Exclude <\/b>to Hide <\/b>to re-calculate the percentages without including the row\/column for the missing responses.)
\n![\"Semantic](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/xtab_age_cheese.png\")
<\/li>\n<\/ol>\n<\/div>\nStep 2: Showing several variables in the same cross-tab<\/h3>\n
\n\n
![\"RD:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/with_per_base.png\")
<\/li>\n![\"Semantic](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/07\/with_per.png\")
<\/li>\n to save the table.<\/li>\n<\/ol>\n<\/div>\nConclusion<\/h3>\n