How to Add Average Columns to Tables Containing Column Spans

This article describes how to go from a table with column spans...

...to a table that includes an Average column per span:

Requirements

A table that includes grouped spans in its columns.

Method

1. Select your table.

2. In the object inspector , 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 row 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 may 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.  

Next

How to Use Rules in Displayr