You may want to show a row with the average of each column alongside proportions in a table. The method for this depends on how you'd like to calculate the average.
- For the weighted average of the underlying data values, in the object inspector, select Data > Statistics > Below > Average.
- For a straight average across the values shown in your table, you can apply a rule via the object inspector Data > Rules > Plus (+) > Calculation > Add Average of Each Column.
This article describes the second method for using a rule to go from a standard crosstab or grid table...
...to a table that displays an Average of all the rows per column:
Requirements
A table with rows and columns.
Method
- Select your table.
- Go to Data > Rules in the object inspector.
- To apply the rule, select the Plus (+) > Calculation > Add Average of Each Column.
- Select the Statistic to use (if different from the default).
- Set the Position to place the new column on the top or bottom.
- Press OK.
This rule adds an extra row to the bottom of the table, which shows the Average of the statistics that are shown in the columns. Rows that are duplicates of other rows, for example, the NET row, are not included in the computation of the average. Note, this rule can only apply to a single statistic, and 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 of Each Row rule instead.
Next
How to Add an Average of Each Row to a Table