Spearman Correlation Tool
Spearman Correlation Tool
User Role Requirements
User Role* | Tool/Feature Access |
|---|---|
Full User | ✓ |
Basic User | X |
*Applies to Alteryx One Professional and Enterprise Edition customers on Designer versions 2025.1+.
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.
One Tool Example
Spearman Correlation has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Configure the Tool
Field Selection Tab
Choose the 2 fields (columns) to determine the Correlation. The 2 fields must be numeric, and you can't choose the same field 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).
Description Tab
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.