UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis This article describes how to go from a table showing Column Comparisons...
...to a table that highlights cells that have a significant relationship to a particular column based on the column letters. In this example, it highlights based on the Female column (B):
Requirements
A table with Column Comparisons.
Method
- Select your table.
- Go to Data > Rules in the object inspector
.
- Select Plus (+) > Other Colors > Color Comparisons for Specified Column.
- Enter the name of the Column to compare with.
- Select the appropriate colors from the Higher and Lower results color pickers.
- Press OK.
Please note the following:
- The rule will replace the column letters with colors when comparing against the target column, but will maintain the letters for other comparisons.
- This rule works within the spans of the table, so if you wish to highlight comparisons with the NET or other column within each of the spans on your table, then this is done automatically.
- The Column Comparisons do not test with the NET column(s) by default, and in order to include the NET in the testing, you must change the settings according to How to Include the Main NET Column in Column Comparisons.
- This rule will not show the appropriate high and low results if Show Redundant Tests is enabled in Statistical Assumptions for your table.