What are Crosstabs?
Crosstabs, also known as cross tabulations or contingency tables, are two-dimensional (or more) tables that allow you to split data based on variables and determine if there is a relationship between them.
Crosstabs are commonly used to analyse survey response data, as they provide a more detailed comparison of how different groups of respondents answered specific questions. The results are presented in aggregate data tables that display the results of the entire group of respondents (total), as well as the results from defined subgroups.
How to create Crosstabs with Attest
With the new Crosstabs feature, it’s easier then ever to split your data and look for statistically significant differences across demographics, countries, waves, and questions.
Instructions
Instructions
Navigate to “Crosstabs”
On your results dashboard you will see Crosstabs as a new tab next to Overview, Trends and Analysis. When you click on crosstabs, you will see all your questions listed out in a table format, with a “Total” column, as you haven’t selected any other variables yet.
Select the data you want to analyse
If you’ve sent out your survey multiple times or to multiple countries, select the waves and/or countries for which you would like to build your Crosstab from the dropdown at the top of the page.
Add columns to your Crosstabs
To create a Crosstab, select the variables you want to include from the panel on the right-hand side. You can choose to add demographics, waves and answers to certain questions (single and multiple choice only). You can include all fields in a variable or select specific fields by clicking on the arrows and choosing the variables you need (e.g., certain age ranges). To remove a variable from your Crosstab, simply deselect it.
If you want to create a combination of various demographics, answers or other criteria you can create segments and add these to your crosstab. Learn more about segments here.
Look for statistically significant differences
Toggle on our Significance test to see where the results are significantly higher or lower. You can choose the confidence level you want to run the test at (95%, 90% or 80%) and the column you want to compare against (total, previous column or a specific column).
Choose how to display your data
To customize your crosstab, click on the options menu located at the top-right of your page. From there, you can choose what to display (values, percentages, or both) and the order of your answers (based on draft order or based on results order).
Export the data
You can download all your questions at once in an Excel file or copy the data of a single question to your clipboard by clicking "copy data". This will copy the data to your clipboard, allowing you to paste it into a spreadsheet for further analysis.
The benefits of Crosstabs
Analysing data can be overwhelming, but Crosstabs can help you manage large data sets by breaking them down into more manageable subgroups.
You can split your data based on various variables, such as:
Demographics – to see if there are any differences in peoples responses based on age, gender, income etc.
Questions – to find out if there are relationships between people’s responses to different questions
Geographic region - to discover differences across countries and regions
Dates – to check for granular changes over time, if you’ve sent out your survey multiple times (multiple waves)
Delving through this information and visualizing this through Crosstabs makes it easier to uncover granular insights, patterns, trends and opportunities. Without Crosstabs, these insights would likely go unnoticed or require a lot more work to reveal.
Let’s look at an example
We asked 1,000 respondents across the US and the UK which social media app they use the most. The results show that Facebook is by far the most popular app, with 46.9% of saying it’s their most-used app.
However, when we create a Crosstab and examine certain subgroups (in this case, age groups), we can see that TikTok is the most used social app for respondents aged 18-24, with 40.5%, followed by Instagram (24%) and Snapchat (19.5%).
This can be very helpful information when deciding on what the best way is to reach your target audience.
When should I use Crosstabs?
Crosstabs can be used for any type of data analysis, but they are particularly helpful when you’re looking for:
Informed decision-making: Use the insights gained from Crosstabs to guide decision-making in areas such as marketing strategies or new product development.
Hypothesis testing: Test hypotheses or assumptions by comparing the responses of different groups and validate or reject certain hypotheses.
Segment analysis: Break down your data into subgroups and see how different demographic or characteristic groups responded differently to survey questions. You can learn more about analysing different segments.
Exploratory analysis: Discover unexpected relationships and new areas to explore further.