Search
Contents
Correlation Tests (Pearson and Spearman)
These are run automatically when pivoting by 2 numeric columns. Pearson’s correlation is applied if the data is normally distributed, while Spearman’s correlation is used if the data is not normally distributed. These tests measure the strength and direction of the relationship between the two numerical variables.
Pearson's vs Spearman's
In this example the Pearson Correlation Coefficient was used as both of the columns were normally distributed. If one of them wasn't normally distributed then Spearman's rank correlation would be run. This happens automatically in AddMaple.
Other Articles