Aside from z-scores, you can also use something called an Index score to compare your column breaks. But unlike z-score, an Index doesn’t tell you about statistical significance. Rather, it offers a quick visual cue as to whether an individual cell is higher or lower than the corresponding value in the root column (i.e. Overall column).
To toggle on the Index score, click the Index button just above the table.
How is Index calculated?
An index score is calculated by taking a cell % value and dividing it by a reference cell %, multiplied by 100. It is reported as a whole number.
What does the score mean?
An index score of 100 means that both the primary cell and reference cell values are exactly the same. If the number is above 100, the primary cell is over-indexing compared to the reference cell. And if the score is below 100, the primary cell is under-indexing compared to the reference.
Index Score Range | What it means? |
Equal to 100 | Both cell values are identical. |
Greater than 100 | The primary cell over-indexes / is higher than the reference cell. |
Less than 100 | The primary cell under-indexes / is lower than the reference cell. |
The screenshot below shows where you can find the Index score value within the table once it is toggled.