‹ Tutorials

How to read cross breaks in excel data tables

Thank you again so much for all of your tremendously hard and FAST work to secure us the research data in time, and to even get us your analysis deck earlier than we even anticipated! During that crazy sprint before the Christmas break being able to get extra thinking time to leverage the data was really appreciated.

With your help, we were able to successfully translate the findings to a finalised narrative and whitepaper outline pre-holidays, enabling the team to focus on finalising the whitepaper and supplementing it with case studies and quotes post holidays.

Sophia Brockman
International planning Director, APAC & EMEA
We communications

In need of insights?

Success story


Subtitles an unexpected hit, in so raising the visibility of Captioning Awareness Week.

Read more

Cross breaks, also known as cross tabs, allow you to compare the results of a survey between two or more groups of people. For example, you may wish to compare how men have answered a survey question compared to women. These types of breaks can be found running horizontally across data tables.

Our video guide below runs through how to read the data within these groups and how to determine whether the differences are significant. We suggest expanding the video to ‘full screen’ to make the most of it!

Use our significance calculator to help determine whether the differences you have found are significant!

To make robust comparisons between groups we recommend having a minimum base of 40 responses within each group. The higher the base number, the more confidence you can have in the data or differences.

For advice on how to read data tables at an overall level, check out our first video guide.

Get topical tips, insights and more delivered to your inbox

Be the first to know about the latest international business sentiments, behaviors and plans so you can stay one step ahead of your competition.