Table diagonalization

From HandWiki
Revision as of 13:29, 3 August 2023 by WikiGary (talk | contribs) (simplify)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Diagonalization is the process of re-ordering the rows and columns of tables and charts so that the data forms an approximately diagonal line.[1] This makes it easier for people to see patterns in the data.

Examples of diagonalization
Columns and rows are moved around until a diagonal pattern appears, thereby making it easy to see patterns in the data.

Diagonalization typically involves either raw data, percentages, means or residuals.

Generally once tables are diagonalized one of two patterns appears: hierarchy or segmentation

References

  1. Jacques Bertin, Semiology of Graphics: Diagrams, Networks, Maps. ESRI Press, 2010, 168-169. ISBN:978-1-58948-261-6