What is a Contingency Table in Survey Analysis?

What is a Contingency Table - Survey Analysis Guide - Examples Steps Tools Benefits Use Cases

Example of a Contingency Table

What is a Contingency Table?

A contingency table is a table that lets you compare two or more types of data to see how often they overlap. It’s commonly used in surveys to see how often two different answers appear in the same respondent profiles.

Consider a scenario where you’ve just surveyed a bunch of kids about their favorite ice cream flavor and now you want to see whether there was a big difference in answers for boys versus girls. Rather than counting each answer up manually, you can create a contingency table that shows a breakdown of exactly that.

By calculating the percentage for each cell, we can instantly see that boys like chocolate ice cream most and girls prefer strawberry ice cream. If we had relied only on the overall results, we would’ve assumed strawberry was the best choice overall, not realizing that 80% of boys had not selected that option.

This is a pretty basic example, but it shows us how easily contingency table analysis surfaces differences in survey results depending on the subgroup of participants you focus on, helping you identify relationships that exist in your data that are often not obviously apparent when looking at your aggregated results.

Contingency tables are a form of “crosstab analysis”, both of which mean putting two things across from each other on a table to see how they overlap. Whenever you want to compare how variables in a dataset influence one another, contingency tables are a great analysis method to consider.

While contingency tables are usually used for “categorical” data (like in the ice cream example), you can also use them as a comparison matrix to see how quantitative data differs across segments of people. The example below uses ranked data in a contingency table to compare the favorite desserts of four different countries:

Using Crosstab Analysis on Ranked Data Average Ranking Crosstabulation.png

How To Create a Contingency Table (Basic Version)

How do Contingency Tables work for survey analysis - example

In this section, I’ll share a step-by-step approach you can use to build your own contingency tables. The first example will follow a more traditional contingency table approach in a Google Sheets spreadsheet. The second version is a more advanced matrix table for analyzing quantitative data.

Contingency Tables Follow Four Steps:

1. Pick Your Questions → Pick the two survey questions you wish to compare and add the variables from each question to your matrix table as the row and column headers. It does not really matter which question goes where, but best practice is to put your identifying variables as columns and opinionated variables as rows.

2. Count Overlapping Variables → You can either do this manually, using a formula combo like COUNTIFS and VLOOKUP, eg. =COUNTIFS(A:A, "Chocolate", B:B, "Boy"), or using the spreadsheet’s built-in contingency table feature.

3. Calculate Frequency Percentage → Focusing just on the column, calculate the percentage of entries that each row variable accounts for. The columns should add up to 100%. For example, in the contingency table screenshot above, 5 of 25 boys picked strawberry as their favorite flavor, which accounts for 20% of boys.

4. Heatmap / Color Scale → Add conditional formatting to the percentage columns, with the lowest value set to white and the highest value showing as a solid color (in this case I chose blue). This allows you to spot outliers or strong correlations instantly at a glance.

Advantages of Contingency Tables (With Real Examples!)

The easiest way to explain the benefits of contingency tables is to use some real examples. For the most part, the examples I’ll be using are taken from real user research surveys and the screenshots are from the automated contingency tables included in all OpinionX surveys.

Using Crosstab Analysis Table To Check How Representative Your Participant Pool Sample Stratified

1. Representative Samples

A contingency table can help you quickly see whether your survey participants are well-balanced or if you’ve got one demographic group overrepresented in your results. For example, in the screenshot above, we have a contingency table with three “gender” columns and six “age bracket” rows. This table helps us quickly see that (i) we have a solid balance of male and female respondents across age categories, but (ii) young adults aged 25-44 are overrepresented in our participants so far compared to other age brackets (almost 70% are in the 25-44 range).

Example of Image Crosstab Analysis with Pictures Ranking

2. Flexible Format

A contingency table is not restricted to just categorical data. You can easily create a contingency table using other data types, like average scores for ranking questions. In the example above, a set of participants have ranked a list of concept candles, which each consist of an image and a caption. The contingency table shows a matrix comparison between the pairwise votes (ie. the percentage of pairs each candle was picked as the winner) and two segments — people who use decorative candles vs those that don’t. The results show that Lavender Dream is the highest-ranked option for both segments.

Using Crosstab Analysis to Find Outliers Compare Segments Groups of People Survey Respondents

3. Identifying Outliers

Using heatmap-style color formatting on a contingency table helps us quickly see outliers in our results. For example, in the example above, we can see a list of “challenges” that have been ranked using Pairwise Comparison voting (a series of head-to-head votes where the score is the percentage of pair votes each option “won”). That dark-blue cell tells us that participants in the “other” gender group clearly picked the statement about “low confidence in social settings” way more often than male/female participants — and that this is an interesting outlier to dig deeper into!

Compare Groups of People Using Cross Tabulation Contingency Table Survey Analysis - Example

4. Compare Groups

Some survey tools have filters for looking at how one specific group of people completed your survey — a great feature if you already know what participant groups matter most to you! Using a contingency table, you can directly compare many groups in a single table so that differences jump right now, rather than trying to spot changes by looking at one filtered group at a time. In the contingency table example above, customers were asked to rank a list of reasons why they signed up for a product. We can see that there’s actually a statement that is WAY more interesting because it ranks highest for happy customers and lowest for unhappy users. This statement is much more interesting than the two that ranked higher overall — without our contingency table, we might have missed this interesting insight!

Configure Custom Segments Variables for Cross Tabulation Crosstab Contingency Table Boolean Logic ANDOR

5. Stackable Variables

You can also create custom segments by combining variables using Boolean logical operators like AND/OR to stack multiple data points together. The example above is from a real customer research project I ran at OpinionX in late 2023 (full case study here). Looking at the four custom segments side by side, you can see that the score for the top-ranked option overall (“Comparing/filtering results by segment”) decreases in importance for each subsequent group. This insight was really important for us and helped us to clarify our unique value, sharpen our target customer profile, and inform our entire 2024 company strategy — that’s the power of a good contingency table!

Configure Advanced Crosstab Segment Criteria ANDOR Logic Example

Those groups were each custom-configured using data from multiple questions using OpinionX’s Saved Segments feature, as pictured below. Each row below forms an AND statement, with each answer in a row tied together by OR logic. This could be explained as only picking participants that had selected “Company AND (Design OR Marketing OR Sales OR Strategy…)”. These stacked variables are great for creating contingency tables with customer data, where you want to consider things like pricing plan, account size, usage frequency, and other common data points.

Contingency tables don’t have to be a scary advanced analysis format. They are flexible (whether doing a simple demographic breakdown, stacking multiple variables together, or using quantitative datasets like ranked scores), intuitive (percentages and heatmap color formatting make insights jump out), and automated (if you use a survey tool like OpinionX which creates contingency tables automatically for you!).

Use Cases: When To Use Contingency Tables

A contingency table is a useful analysis method whenever you’ve got two or more categories of data you want to compare against one another. Here are some example scenarios where contingency tables are particularly valuable…

  • Market Segmentation → A contingency table is one of the most powerful analysis tools you can use during customer or market segmentation research. It allows you to quickly map all possible segments in a simple table and visually compare them, helping you spot outlier segments of customers that think differently from the rest of your market.

  • Feature Usage → Create a contingency table with customer firmographics (eg. industry, title, pricing plan) as the columns and feature usage as the rows. This will show you which features are most used why specific types of users, helping you better understand the “jobs” that customers are hiring your product to accomplish or areas of functionality that are not being used by your key customers.

  • Roadmap Prioritization → Whether you’re asking users to vote on problem statements in pairs or rank feature ideas, it’s essential to use contingency tables to see how different customer segments prioritize needs. Every quarterly roadmap survey we run ends up in a contingency table so that I can see which opportunities are most aligned with specific customer segments.

  • Net Promoter Score → The real value in NPS surveys is always always always found in segmented results. Bringing your three NPS categories (Promoters, Passives, and Detractors) into a contingency table helps you better understand what is driving customer loyalty for Promoters while isolating the barriers to activation and adoption that are harming your ability to sustain continued growth.

  • Needs Assessment → After conducting a needs-based segmentation or psychographic segmentation study, bring your survey data into a contingency table to identify customer segments that care about specific needs/pains more than others, or compare the survey data against product usage data to identify the problems that your most engaged customers care most about solving.

  • Customer Satisfaction → Similar to NPS surveys, CSAT research is never complete without some form of segmentation analysis. Contingency tables are an ideal way to see how your survey results are different at each level of customer satisfaction so that your survey insights can be used to both extend what you’re already doing well while also understanding what you’re underperforming on.

  • Employee Engagement → Whether you’re running a simple employee pulse survey or a more advanced culture assessment, contingency tables are a great way to analyze the differences in perceived employee experience for different departments, levels of seniority, or years employed. Those granular insights, which can be obtained from a single contingency table, will allow you to generate targeted strategies for improving employee experience rather than chasing vague company-level objectives.

  • Customer Feedback → Analyzing how perceptions of service quality vary by the type of service received (AI chatbot -v- phone call -v- email thread -v- in-person support).

— — —

How To Create A Contingency Table From Survey Data Results (Reviewing 9 Different Tools/Methods)

I did a deep dive into the most popular survey tools to figure out:

  • Which tools offer contingency tables for survey analysis?

  • How expensive is it to access their contingency table functionality?

  • Are there any limitations or restrictions on their contingency tables?

OpinionX Crosstab Analysis Example - Segments Tab - Crosstabulation Contingency Table

1. OpinionX

OpinionX is a survey tool that specializes in ranking people’s preferences and priorities. It offers a range of ranking methods (like pairwise comparison, ranked choice voting, points-based ranking, and more) along with automated segmentation and contingency tables. OpinionX is used by tens of thousands of teams (including teams at Disney, LinkedIn, and GitHub) to better understand what their customers and employees care about most.

OpinionX Segments Tab Automated Crosstab for Beginners Configuration

i. Automated Analysis → Contingency tables on OpinionX are populated automatically. Now when some people say “automatically” they mean you still have to do loads of setup work, but I really mean automatically. On OpinionX’s results page, you’ll find a tab called “Segments” that comes preset with one contingency table for each question in your survey.

How To Filter Crosstab Results To Specific Respondent Segments Variables

ii. Easily Edit → Changing the variables on your contingency table is so easy on OpinionX. Just click the “Select Segments” button on the corner of any contingency table and you’ll get a simple popup menu where you can choose which data to include or exclude. There’s also a Saved Segments feature for creating custom groups of survey participants using AND/OR logic to combine answers from multiple survey questions.

^ This contingency table example shows the part-worth utility scores for a conjoint analysis survey about smartphone buyer preferences, where we can see a clear rivalry between iPhone and Android owners and a higher price sensitivity amongst Android users.

iii. Multiple Question Formats → Unlike all the other tools in this list, contingency tables on OpinionX are compatible with all question types. That includes not just Multiple Choice, but also Rating Scale, Pairwise Comparison, Image Voting, Points Ranking, MaxDiff Analysis, Ranked Choice Voting, Conjoint Analysis, and Consensus Ballots, and more. When you create a survey on OpinionX using one of these question types, you’ll have a contingency table automatically generated on your Segments Tab waiting for you!

iv. Readily Affordable → Not only does OpinionX have the easiest to use contingency table functionality and the broadest question-type compatibility, it also offers the lowest price for contingency tables of any survey tool — unlock contingency tables and other analysis methods like segmentation and persona clustering for just $20/month (4x less than any other survey tool).

OpinionX is the cheapest, easiest to use, and most widely compatible survey tool for creating contingency tables. Not convinced? Every account on OpinionX comes with a range of pre-populated sample surveys with all analysis features unlocked for you to test for yourself. Create a free account now and check out the OpinionX Sample Surveys Gallery.

— — —

2. Manual Spreadsheet

It’s pretty easy to create contingency tables in Google Sheets or Excel, if your data is categorical (eg. answers to a multiple choice question). Here are the steps I use to create a contingency table in Google Sheets (alternative tutorial for Excel here).

Google Sheets Crosstab CSV Import

Step 1: Add Your Data → I’ve exported data from a Product/Market Fit Survey on OpinionX and uploaded it to a new Google Sheets document.

Google Sheets How To Create Crosstab - Step 2 Pivot Table

Step 2: Insert Pivot Table → Highlight all your data, open the “Insert” dropdown menu, and choose Pivot Table (New Sheet).

Google Sheets Excel Crosstab Setup - Configure Pivot Table Values and Variables

Step 3: Configure Values → Drag and drop your two data points into the areas for the Rows and Columns variables, along with one of the two in the Values variable.

How to Create a Heatmap Matrix Crosstab Table on Google Sheets

Step 4: Heatmap Formatting → To apply heatmap color coding, highlight your number values (if your contingency table is count-based rather than percentages, make sure and exclude the “Total” rows from this), open the fill color menu, click “Conditional Formatting”, and switch it to the “Color Scale” option.

Done! That’s how you create a simple contingency table using categorical survey data in a spreadsheet tool like Google Sheets.

Creating a Crosstab Analysis Table in R

3. R

R is a programming language that statisticians use for analyzing data and creating graphics. You don’t need to be an advanced statistician to create a survey results contingency table in R, but you’ll need a basic understanding of R, its syntax, and access to a software product that supports it. If you’re starting from scratch, you should be able to get up and running with basic data structures, functions, and packages like Dplyr in under 1-2 weeks. It’s a great skill to learn as R is open-source, free to use, and can be used for a wide range of data types and complex analyses.

For more info on creating contingency tables in R, I’d recommend checking out a guide created by someone with more knowledge in this topic, such as this one → Crosstab calculation in R by DatScienceTut.com.

How To Create a Crosstab Analysis Report on Typeform - Survey Cross Tabulation Guide - Contingency Table

4. Typeform

There is no contingency table functionality on Typeform. According to Typeform’s community manager, you’ll have to export your data to an external spreadsheet and manually create your own contingency table there.

5. Displayr

Displayr is a data analysis tool — it allows you to take your survey results from a tool like Typeform, which doesn’t really include any analysis features at all, and create custom dashboards, charts, and reports. Contingency tables are part of Displayr’s $480/year “Data Stories” pricing module, which is separate from the core Displayr product. If you’re looking to bring your existing survey data into a purpose-built analysis tool, then Displayr’s Data Stories product is likely what you need — more info here.

How To Create a Crosstab Analysis Report on Qualtrics - QualtricsXM Cross Tabulation - StatsIQ Matrix Table Tutorial

6. Qualtrics

Contingency tables are not included in QualtricsXM subscriptions. As of early 2021, Qualtrics repackaged contingency tables so that it is included only with the purchase of StatsIQ, meaning that even some paid licenses for QualtricsXM may not include contingency table functionality. Additionally, contingency tables on Qualtrics do not work with MaxDiff or Conjoint Analysis questions.

7. SurveyMonkey

While SurveyMonkey does have a contingency table reporting format, it is only compatible with Multiple Choice questions — 85% of SurveyMonkey question formats are not able to be displayed in a contingency table (including rating scales, sliders, ranking questions, maxdiff “best/worst” scales, matrix questions, and others are not compatible). SurveyMonkey’s contingency tables are available on their “Premier” tier (its most expensive self-service pricing option). Premier Individual costs $1188/year and the Premier Team version starts at $2700/year plus $900 per additional user.

How To Create a Crosstab Analysis Report on Alchemer - Survey Cross Tabulation Matrix Table Example Free

8. Alchemer

Unfortunately, contingency tables are only available on enterprise plans for Alchemer, which must be custom-negotiated with Alchemer’s sales team. Alchemer does offer a couple of extra compatible question types for contingency tables compared to SurveyMonkey — as well as choice/selection-based questions, it lets you use rating scale questions and URL variables too. If you are willing to procure an enterprise contract, the good news is that Alchemer’s contingency tables come with some advanced features such as scoring for Pearson Chi-Square, degrees of Freedom, P-Value, and Fisher’s Exact Test.

9. QuestionPro

Contingency tables are available on QuestionPro’s paid survey plans — either the Advanced tier ($1188/year for one person) or Team tier (starts at $4980/year for a minimum of five seats). These paid tiers, however, only include a basic count-based contingency table (count, average, percentage). To use heatmap color formatting or statistical analysis, you must upgrade to their “Research Edition” enterprise plan (minimum starting price of $10,000/year).

— — —

Technical Jargon: The Contingency Table Dictionary

Contingency Table -v- Crosstab -v- Matrix

You’ll often see Contingency Tables referred to as either Cross Tabulation or Crosstab Analysis. That’s because they both mean the same thing. “Crosstab” tends to be used in commercial scenarios like like market research, user research, or political polling, whereas “Contingency Tables” is more commonly used in formal settings like academic research. Both are matrices — a table of numbers represented across an array of rows and columns.

Categorical vs Numerical Data

Almost every guide on the internet says that contingency tables only work with categorical data, but there is no reason to continue perpetuating this unnecessary restriction. As long as contingency tables are matrices where any given cell represents the overlap between the row variable and column variable, then it is a suitable analysis format. This means that you can use contingency tables to show average scores of rating scales or ranking exercises for each segment of survey respondents, for example.

^ Example of a contingency table that uses average scores from a pairwise comparison ranking survey (ie. non-categorical contingency tables!)

Basic Contingency Table Terminology

  • When describing a contingency table, rows are known as “stubs” and columns as “banners” or “cuts”.

  • A grouped set of variables are called a “category”, for example in a survey question where people picked their age from a set of ranges (eg. 18-24, 25-34, 35-44…), this collection of variables is called a “category”.

  • The value of each cell of a contingency table tends to be either a “count” (also known as “frequency”) in which you add up the number of times that your two variables appeared together in a participant profile, or a “percentage”.

  • You can use “filters” to focus your contingency table on a particular view of your data.

  • A “pivot table” is a format used to summarize and manipulate data in a spreadsheet. It is commonly used as the basis for a contingency table in tools like Excel.

  • A “CSV” (acronym for comma-separated values) is a text file format that uses commas to separate values, and newlines to separate records — it’s basically like a text-only version of a spreadsheet. It’s common to populate a contingency table using data that comes from a CSV file.

  • To figure out whether the results of our contingency table could’ve happened by chance or is the result of an underlying relationship between our variables, we would test our data to see if it is “statistically significant” (ie. an underlying relationship exists).

Advanced Contingency Table Terminology

  • The “Pearson Chi-Square Test” is a type of analysis used to determine whether two variables in a contingency table are independent or have a statistically significant relationship by measuring the actual data (eg. survey results) against the expected data (eg. population data).

  • Degrees of Freedom” (also known as “DF”) refers to the number of independent pieces of information used in the calculation of a statistical test such as the Pearson Chi-Square Test.

  • P-Value” is a common statistical measure that calculates the level of confidence that the two variables or categories in your contingency table are correlated.

Crosstab and Clustering Analysis Survey Example

— — —

Most survey tools charge thousands of dollars to access contingency tables that are burdened with format limitations and outdated interfaces. OpinionX automatically generates contingency tables for all surveys, requiring no technical configuration while also allowing more advanced designs where required. It’s the perfect blend of easy to use, available for deep analysis, and more affordable than any other tool.

Create a survey on OpinionX today and leverage the industry’s best survey contingency table functionality for your next research project.

— — —

Enjoyed this blog post? Thousands of founders and product teams subscribe to our newsletter, The Full-Stack Researcher, for actionable user research advice just like this:

About The Author:

Daniel Kyne is the Co-Founder of OpinionX, a free research tool for stack ranking people’s priorities — used by thousands of product teams to better understand what matters most to their customers. OpinionX comes with a bunch of research methods for measuring people’s preferences — including automated contingency tables for a range of survey methods. Try it now!

Previous
Previous

Competing Values Framework: Methods, Tools, Templates

Next
Next

Crosstab Analysis: Explanation, Examples, Methods, Advantages, Use Cases, Tools