When presenting your data, you may want to highlight data with small sample sizes so viewers know the sample is small. This article describes how to go from a standard table...
...to a table where columns with a sample size under a specified threshold (e.g. 50) are highlighted:
Requirements
- A crosstab created from variables in a data source (using drag and drop).
Method
- Select your table.
- In the object inspector, click Data > Rules > Plus (+) > Modify Cell Content > Change Color of Cells with Small Sample Sizes.
- Select the appropriate threshold under Minimum Column n.
- Select the appropriate color from the color picker.
- Press OK.
Note:
- This rule uses the Column Sample Size for coloring the cells. A footnote is also added which specifies this condition.
- It will also deal with situations where missing data causes the sample size of each column to vary by row.