UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis This article describes how to add summary averages to tables that contain grouped spans, either in the rows or in the columns.
For example, you can go from a table with spans in the columns...
...to a table that includes an Average column per span:
Or from a table with spans in the rows...
...to a table that includes an Average row per span:
Requirements
A table that includes grouped spans in either its rows or its columns.
Method: Add Average Columns to Tables Containing Column Spans
Use this when the grouped spans are in the columns of your table.
1. Select your table.
2. In Properties , go to Data > Rules.
3. Click Plus (+) > Table Computations > Add Average Columns to Tables Containing Spans.
4. In the dialog, set the Position to place the new column to the left or right of each span.
5. Click OK.
OPTIONAL: Tick Include span label in new column labels to include the span label in the label of the new "Average" column:
This rule adds an Average column next to each span in a table. The average is computed as the average of the statistics of the other columns within that span. No significance tests are conducted on these averages.
Note: if you select Switch rows and columns on your table, the rule will no longer work due to the table dimensions changing. In this case, you will have to apply the Add Average Rows to Tables Containing Spans rule instead.
Method: Add Average Rows to Tables Containing Row Spans
Use this when the grouped spans are in the rows of your table.
1. Select your table.
2. In Properties , go to Data > Rules.
3. Click Plus (+) > Table Computations > Add Average Rows to Tables Containing Spans.
4. In the dialog, set the Position to place the new row above or below each span.
5. Click OK.
OPTIONAL: Tick Include span label in new row labels to include the span label in the label of the new "Average" row:
This rule adds an Average row for every span, which is computed as the average of the statistics of the other rows within that span. No significance tests are conducted on these averages.
Note: if you select Switch rows and columns on your table, the rule will no longer work due to the table dimensions changing. In this case, you will have to apply the Add Average Columns to Tables Containing Spans rule instead.