Crosstabs

Drag to crosstab one or many elements

Updated at July 17th, 2023

Create crosstabs in Protobi by dragging the label of one element onto another:

Crosstab elements individually

Drag + drop

Drag one element (q1) to the heading of another (q2) to create a crosstab. The element you drag will define the columns (or "banner"), and the other will define the rows (or "stub"). 

To remove the banner, press the small red x on the banner pill.

Press on the + sign on any element to choose from a list of crosstab banners. The crosstab banners in the drop-down are based on the element you add to your "banners" tab.

Drag elements from the tree to crosstab

You can also drag from the element tree on the left. This is useful when crosstabbing variables that are not on the same tab.

Crosstab elements globally

Drag onto the the "Crosstab"  button in the toolbar to define a global banner.  Any elements and charts that can take a banner variable will be crosstabbed.

To remove, click on the crosstab button, and select "none"

Crosstab with two banner variables

Elements can take up to two crosstab banners. Once an element is crosstabbed by one banner, a second "+" button appears, and you can drop another banner. 

The columns are sorted by the first level banner, and then the second. 

If you double click on either banner, it will switch the order:

Global crosstab with two banner variables

You can apply two crosstab banners globally. Drag the first banner to the crosstab button, then start dragging the second banner over. Before you drop the second banner, hold down the shift key.

This should allow the crosstab button to take both banners:

When you create a global crosstab with two banner variables, an option to "swap" will appear. Below, the project is crosstabbed by specialty (S1) first, then practice start (S3). Press swap to crosstab by S3 first, then specialty.  

Hide crosstab banner columns

Globally

Open the format dialog and select the "Hide" option for the values you want to hide. 


On select questions

Right click on a banner column to optionally hide the category for a question. For instance in the table below, Q1 is crosstabbed by both S1 (Specialty) and S3 (Practice start year). 

If you right click on "Before 2000" you can hide that column for Q1 only. It will not affect other tables where S3 is used as a banner. 

Note you can not selectively hide the "Before 2000" under General Practitioner but not hide the same category under Practice Nurse. You can right click on "Practice nurse" and it will hide all banner columns nested under it. 


To remove suppressed values, open the context menu for the banner (S3) and select "Suppress For". Note: this menu item will only appear if the banner already has values suppressed for a specific question. 

This will take you to the Suppress For dialog where you can select/deselect the values hidden per Element. 

Note: if you select values on the banner's element row (S3), then the values will be hidden on every element where S3 is used as a crosstab. This is the same result as using the format dialog to hide values. 

Crosstab significance tests

Admins can change crosstab significance tests in Project properties. The default mode is Complement testing.

Complement

In Complement testing, each column is compared with the average of all other columns (excluding itself). Blue cells indicate the value is significantly higher in the specified column compared to all other columns, and grey indicates significantly lower. 

Pairwise

Pairwise testing compares each column with each other individual column. This mode shows detailed superscripts like a traditional crosstab. 

Below we see that the percentage of respondents who rated their health as "Excellent" is much higher in column A (Very happy) than columns B, C or D. 

Note: Protobi limits significance testing to N>=10 to avoid testing when the sample size is too small. 


Video Tutorial


Transcript

Create crosstabs by dragging on variable to another. Cell shading highlights significant differences. To uncross, we can drag S1 out of Q2. 

Crosstab every variable in the survey by dragging it to the crosstab button in the toolbar. Select clear to uncross. 





Was this article helpful?