Sorting by Column Significance

You can apply all of the following steps to a table in a single action, using the Sort by Column Significance option:

• add a column proportions and column means test to the table with the default significance level (5)

• add a minimum p value column to the table

• sort rows in ascending order by the minimum p value column

• hide rows where the minimum p value is greater than the significance level (greater than 0.05).

If required, you can change any of these settings individually (for example, if you want to remove the hide option or change the significance level) using the relevant tabs on the Table Properties dialog box.

To sort a table by column significance

In the Tables pane, select the table to which you want to apply the test.

From the menu, choose

or choose the Sort by Column Significance button:

The changes are applied to the table. Generate the table to see the results:

Note that if there are no significant results, an empty table will be displayed.

See the topic p Values for more information.

Also in this section: