Crosstabs

Drag to crosstab one or many elements

Updated at June 23rd, 2020

Create crosstabs in Protobi by dragging the name of one element on to another:

Crosstab elements individually

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

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 an element name to 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 cross tab button, and select "clear."


Crosstab with two banner variables

Drag one element (e.g., S1) to the heading of another (e.g., Q1). Then start to drag the second element (e.g., Region). Hold down the SHIFT key before dropping the second element. This will allow you to add two banner variables when cross-tabbing. 

Note: This will not work if you hold down SHIFT before you start dragging the element. 

You can apply this method globally as well. Instead of dropping into an element, drop into the "Crosstab" button. 


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 Region. Press swap to crosstab by Region first, then specialty.  

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>=20 to avoid testing when the sample size is too small. 


Video Tutorial


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?