Crosstab

The Crosstab function has some similarities to the Code Matrix Browser, except that documents are analyzed grouped by document variable. Social groups, such as men and women, or people with different personal background, etc. can be compared based on variable values. All of the variables that are in your project can be used to set up a group.

Crosstab is a visualization of the relationship between document variables and codes. The following example displays the number of times each code was assigned woman or men.

Crosstab example based on gender

The Crosstab function can be accessed from the Mixed methods menu or from the context menu of a code.

The Crosstab toolbar at the top of the window offers the following in addition to the usual export functions:

  Quote Matrix – Displays the coded segments as a matrix in Excel.

  Number of segments – Displays absolute frequencies, meaning the number of segments of the respective codes for the variable form of the respective column.

  Row percentage – The percentage share of the cell calculated across the row (horizontal percentage calculation).

  Column percentage based on the sum of coded segments (row “SUM”) – The percentage share of the cell calculated across the column (vertical percentage calculation).

  Column percentages based on the number of documents “N (documents)” – The column percentage in terms of the number of documents in the column (the option Count hits per document only once will be selected automatically).

  Count hits per document only once – The unit of analysis is set to Document. Each document is analyzed based only on whether the code has been assigned or not; the frequency with which a code occurs within a document is not taken into account.

  Refresh – recalculates the values in the table.

Crosstabs are well suited for the analysis of sub-categories and their distribution in sub-groups of the sample. Imagine you have asked how students prepare for examinations, and the different options (e.g. reading books, working together with colleagues, etc.) are defined as codes. With the Crosstab function, you can compare various groups with each other. Are female students participating more in training groups? Do male students read more text? The options to view the values as row or column percentages make the interpretation of the data even easier.

Selection of Codes and the definition of Columns in Crosstabs

As usual in MAXQDA, the selection of codes is done via activation. The selection should be completed before using the Crosstabs function, otherwise all codes will be displayed in the Crosstab.

The definition of the columns is done by defining appropriate variable conditions (formulas) in the dialog window, which is similar to the “Activate by document variables” dialog window.

After activating codes and selecting Crosstab, you will have the option to create logical conditions that will be used to assign documents to each column. The window is broken up into the following sections:

  • A list of all the document variables in the project.
  • A section for the definition of logical conditions (formulas).
  • Buttons for selecting operators and values.
  • Buttons for opening and saving logical conditions (formulas).
  • Further functions, for example starting Crosstabs calculation or cancelling the action.
The Crosstab dialog window

All logical formulas must have the following components:

variable name / operator / value

If you have created a variable called “Gender” and used the characters “Male” for male and “Female” for female, we would use the following formula in order to create one column of the Crosstabs to represent women:

Gender = Female

If you wish to record all occurrences of a variable in the table (e.g. gender) as a column in the crosstab, you would follow these steps:

  1. Select the option Insert all variable values as conditions.
  2. Double-click the desired variable in the left pane of the window.

MAXQDA then lists the formulas that you have set up in the middle pane of the window. In the example, it would look as follows:

[Gender] = Female

[Gender] = Male

The Crosstabs created in this way would look as follows:

Crosstabs comparing the number of coded segments for each code by women and men

If there are many different possible values for a certain variable, you can choose to delete those that you don’t want to include in the visualization. If, for example, you had a variable “level of organization” with possible values “very high,” “high,” “medium,” “low,” and “very low,” you might only want to compare the two extremes. To do so, click on the element you wish to remove from the list in the Formula row and click the Delete  symbol.

You can also compare groupings based only on specific variable values by not checking the box to Insert all variable values as conditions. Instead, you would simply create a formula and add single values by following these steps:

1.   Double-click on the desired variable in the list of variables to set it as a condition (formula).

2.   Insert the appropriate variable value in the field on the right side of the window or choose it from the drop-down list. The drop-down list will have all the values that were assigned to the chosen variable. Choosing the value from the list helps you avoid any typos that would cause you to get false results.

3.   Repeat the first three steps to set up each column of the Crosstabs.

When you click OK, the table will be displayed.

You can also save formulas, so that you can have quick access to them at a later time and don’t have to reenter them one by one. Just click on the Save button at the bottom of the dialog window. You can then give it a name and choose where you want to save it.

Files for saved formulas are saved by MAXQDA as .LOA files. To open a saved set of formulas, choose Open and navigate to the place you saved the .LOA file.

Was this article helpful?