Spearman Correlation Tool
One Tool Example
Spearman Correlation has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Use Spearman Correlation to assess how well an arbitrary monotonic function can describe the relationship between two variables, without making any other assumptions about the particular nature of the relationship between the variables. Correlation coefficient values range from –1.00 (a perfect negative correlation) to +1.00 (a perfect positive correlation). Zero indicates no correlation at all.
Configure the Tool
Field Selection Tab
Choose the 2 fields (columns) to determine the Correlation. The 2 fields must be numeric and the same field cannot be chosen twice. Columns that contain unique identifiers, like surrogate primary keys and natural primary keys, should not be used in statistical analyses. They have no predictive value and can cause runtime exceptions.
Group By (Optional) Tab
To determine the correlation for a group, select Enable Group By and select the appropriate grouping field (column).
The Description tab contains this description:
Spearman's rank correlation coefficient assesses how well an arbitrary monotonic function could describe the relationship between 2 variables, without making any other assumptions about the particular nature of the relationship between the variables.