Articles in this section

How to Add Symbols to Significant Cells in Tables

  • Updated
Follow

This article describes how to go from a standard table with default significant arrows and font colors...

brand image with sig.png

...to a table where the significant cells have symbols added to denote the level of significance based on the Corrected p value:

brand image with sig symbol.png

Requirements

  • A built-in drag-and-drop table or R table based on a drag-and-drop table.

Method

  1. Select your table.
  2. Go to Data > Rules in the object inspector 26UI_ObjectInspector.png.
  3. Select Plus (+) > Cell Content > Add Symbols to Significant Cells.
  4. Enter the Corrected p value, e.g., 0.1, 0.05, 0.01.
  5. Enter the Symbol, e.g., an asterisk or a series of characters.
  6. Repeat steps 4 and 5 for each threshold you wish to differentiate, e.g., 0.1, 0.05, 0.01.
  7. OPTIONAL: Tick Show as confidence to show the confidence levels in the footer instead of the p-value thresholds.
  8. Go to Appearance > Significance > No to remove the significant arrows and colors.
  9. Press OK.

Note, it is not possible to align the numbers when this rule is applied (i.e., the numbers will move to the left to accommodate the symbols).

Also, when exported, values with a symbol will be rounded in Excel tables. If exporting an Excel chart, the symbol will be removed, but the footer will remain.

Technical Information

See Cell Content - Add Symbols to Significant Cells 

Next

How to Use Rules in Displayr

Related articles