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.
Pivot by 2 numeric columns - in this example we are pivoting by Age and Salary.
AddMaple will run the correlation test, and display the overview in the legend. Click "see more" to go to the stats tab where you can see further details on the results of the test.
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.
AddMaple displays both a text overview of the results and the numbers themselves.
Other Articles