Results Table

Results table for frequency

The frequency table displays how many times the individual variables occur. For the variable “Job Security Scale” the value “low” was assigned in 45 cases, and the value “high” in 27 cases. The lower section of the table shows system-defined missing values (blank cells) as well as defined missing values. In the example above, there are 99 missing values, which occurred in 3 cases.

Hint: If a value is defined in the individual missing values as well as in a range of missing values, it will be calculated only as an individual missing value. For example, if “99” is defined as missing and also “50 to 100”, “99” will be included in its own row and excluded from the range “50 to 100.“

Overview of Toolbar Functions

In the upper section of the results window two toolbars are located, which contain the following important functions:

  Table view / Chart view – switches between table and chart view.

  Previous/Next – using the blue arrow or the selection list, switch between the results table for previously selected variables or codes.

  Refresh – Calls up again the dialog for creation of frequency tables.

  Insert into output viewer – inserts the currently displayed table or chart in the Output Viewer.

  Insert all into output viewer – inserts all created tables or charts in the Output Viewer.

  Copy to clipboard – copies the current table, highlighted area in the table, or chart in the clipboard, for example for insertion into Word.

  Print – prints the currently displayed table or chart.

  Export – exports the currently displayed table in Excel format, website (HTML) format or RTF format for Word and other word processing programs; exports the currently displayed chart in PNG, SVG or EMF (only Windows) format.

  Show value labels – this option is selected by default and causes the defined value label of a variable to be displayed in the place of the value of the variable.

  Descriptive statistics – this option is available only for integer and floating point type variables as well as for codes and displays a window with descriptive statistics for the displayed frequency tables.

  Undo changes – step-by-step resetting of changes to a table (deletion of rows, merging and moving of rows).

  Redo – step-by-step restoring of changes to a table.

Sort Tables and Customize Columns

Tables can be sorted by clicking a column header, in ascending order with the first click and descending order with the second. Clicking again will restore the original order.

Tip: You can also move the rows of the results table. Click a row, then drag and drop with the mouse to the desired location. This function is also available for multiple highlighted rows. Lines containing totals or missing values cannot be moved.

Column widths can be adjusted with the mouse, and their position can be changed by clicking the column header then dragging them to the desired location with the mouse.

Delete Rows

The results table is interactive and one or more rows can be removed, for example to restrict the evaluation to selected variables. Right-click a row and select Delete. You can also select multiple rows to delete by holding down the Ctrl/cmd key.

In this way, you can also remove the missing values from the display:

Delete rows from the results table using the context menu

The table will be automatically updated.

Tip: A column can be hidden from the table by right-clicking within the column header and selecting Hide column. When the frequency function is called up the next time, the column will be automatically displayed again.

Merge Values

The interactive results table also allows you to merge multiple values:

  1. Highlight at least two rows by holding down the Ctrl/cmd key as you click on the desired rows with the mouse.
  2. Right-click the selection and select Merge values.

In the following example, the two lowest values for the variable “Job Security Scale” are merged:

Merge multiple values using the context menu

The table will be automatically updated.

Save Documents as Document Set

If MAXQDA Stats is launched with the data from a MAXQDA project, the frequency of individual variable values corresponds to the number of documents in which these variable values occurred. In this case, a compilation of documents is present behind each frequency count. This compilation of documents can be saved as a document set in MAXQDA: Right-click on a row and select Save as document set.

Store documents that are attached to a variable value as a document set in MAXQDA

Initially, MAXQDA stores such sets in the background. When you exit Stats, all document sets created during the analysis will be displayed, so you can select which document sets you wish to transfer to the MAXQDA project.

Select document sets upon exiting MAXQDA Stats

Was this article helpful?