Calculates for each pair of selected columns a correlation coefficient, i.e. a measure of the correlation of the two variables.
All measures are based on the rank of the cells. Where the rank of a cell value refers
to its position in a sorted list of all entries. All correlation can be calculated on any kind of DataColumn.
However please note that we use the default ordering of the values. If there is no ordering defined in the
column, a string representation will be used.
Spearman's rank correlation coefficient is a statistical measure of the strength of a monotonic relationship between paired data. Where the monotonic relationship is characterised by a relationship between ordered sets that preserves the given order, i.e., either never increases or never decreases as its independent variable increases.
The value of this measure ranges from -1 (strong negative correlation) to 1 (strong positive correlation). A perfect Spearman correlation of +1 or −1 occurs when each of the variables is a perfect monotone function of the other.
Goodman and Kruskal's gamma as well as Kendall's tau rank correlation coefficient is used to measure the strength of association between two measured quantities. Both are based on the number of concordant and discordant pairs. Kendall's Tau A and Tau B coefficients can be considered as standardized forms of Gamma. The difference between Tau A and Tau B is that Tau A statistic does not consider tied values, while Tau B makes adjustments for them. By tied observations we consider two or more observations having the same value. Both Kruskal's gamma and Kendall's Tau A are mostly suitable for square tables, whereas Tau B is most appropriately used for rectangular tables. The coefficients must be in the range from −1 (100% negative association, or perfect inversion) to +1 (100% positive association, or perfect agreement). A value of zero indicates the absence of association.
Rows containing Missing Values will be ignored, not used for the calculations. For other behaviors please resolve them before.
Options
Manual Selection
Wildcard/Regex Selection
Type Selection
Popular Predecessors
Linear Correlation13 %- Column Filter11 %
- Missing Value9 %
Excel Reader (XLS)8 %Row Filter (deprecated)6 %Scorer3 %String To Number3 %- Correlation Filter2 %
- GroupBy2 %
- Rank2 %
- Color Manager2 %
- Category to Number2 %
- ARFF Reader1 %
Number To String1 %- Partitioning1 %
- Rule Engine1 %
Excel Reader (XLS)1 %- k-Means< 1 %
- Linear Regression Learner< 1 %
- Sorter< 1 %
- Decision Tree Predictor< 1 %
- Low Variance Filter< 1 %
- Cronbach Alpha< 1 %
- Value Counter< 1 %
- Standardized Cronbach Alpha< 1 %
- Numeric Outliers< 1 %
- Hierarchical Clustering< 1 %
- One to Many< 1 %
- Row Sampling< 1 %
- Pivot< 1 %
- Conditional Box Plot (legacy)< 1 %
XLS Reader< 1 %Database Reader< 1 %- Rule-based Row Splitter< 1 %
Numeric Scorer< 1 %- Concatenate< 1 %
- Auto-Binner< 1 %
- Line Plot (JavaScript)< 1 %
- Missing Value (Apply)< 1 %
- Java Snippet< 1 %
- Group Loop Start< 1 %
PCA< 1 %- Column Splitter< 1 %
- Outlier Removal< 1 %
- Table Creator< 1 %
- Column List Loop Start< 1 %
Cell Replacer< 1 %- Lag Column< 1 %
Column Rename< 1 %- One-way ANOVA< 1 %
- Scatter Plot (JavaScript)< 1 %
Table Reader< 1 %- Logistic Regression Learner< 1 %
Column Appender< 1 %- Domain Calculator< 1 %
- Date Field Extractor (legacy)< 1 %
Database Connection Table Reader< 1 %- Fuzzy Rule Predictor< 1 %
- Regression Predictor< 1 %
- Numeric Binner< 1 %
- Math Formula< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Random Forest Predictor< 1 %
- Column Combiner< 1 %
Database Update< 1 %PCA Compute< 1 %- Random Forest Learner (Regression)< 1 %
- Nominal Value Row Filter< 1 %
- Polynomial Regression Learner< 1 %
- Double to Integer< 1 %
- String Manipulation< 1 %
Loop End< 1 %- Bootstrap Sampling< 1 %
- Reference Row Filter< 1 %
- Numeric Row Splitter< 1 %
- Crosstab< 1 %
- Weka Predictor (3.7)< 1 %
- Column Filter (legacy)< 1 %
- R Snippet< 1 %
- 2D/3D Scatterplot< 1 %
- Logistic Regression Predictor< 1 %
- Numeric Scorer< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Nominal Value Row Splitter< 1 %
- IF Switch< 1 %
Read Excel Sheet Names (XLS)< 1 %- String to Date&Time< 1 %
Naive Bayes Predictor< 1 %- SOTA Predictor< 1 %
Random Forest Predictor< 1 %- Create Bit Vector< 1 %
- Column Auto Type Cast< 1 %
- Column Aggregator< 1 %
- Equal Size Sampling< 1 %
- Statistics< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
- X-Partitioner< 1 %
K Nearest Neighbor< 1 %- String to Number< 1 %
- Cross Joiner< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- One to Many (PMML)< 1 %
- RowID< 1 %
- Independent groups t-test< 1 %
- Molecule Type Cast< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Document Data Extractor< 1 %
- XGBoost Predictor (Regression)< 1 %
CSV Reader< 1 %File Reader< 1 %Counting Loop Start< 1 %- DBSCAN< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA Inversion< 1 %- Tree Ensemble Predictor (Regression)< 1 %
- Random Forest Predictor (Regression)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Denormalizer< 1 %
- Normalizer< 1 %
- Denormalizer (PMML)< 1 %
Number To String (PMML)< 1 %- Shuffle< 1 %
String Replace (Dictionary)< 1 %- Table Transposer< 1 %
- Rule-based Row Filter< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Data Generator< 1 %
- Box Plot (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- LIBSVMPredictor< 1 %
- Java Snippet Row Filter< 1 %
- Spark Line Appender< 1 %
- Frequency Filter< 1 %
- JSON to Table< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒1)< 1 %- R to Table< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- Fingerprint MIN< 1 %
- Normalize Plates (Z-Score)< 1 %
- Pareto Ranking< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
Table Column to Variable< 1 %SQL Extract< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Naive Bayes Predictor< 1 %
- Fuzzy Rule Learner< 1 %
- PNN Learner (DDA)< 1 %
- Cluster Assigner< 1 %
PCA Apply< 1 %Regression Predictor< 1 %- SMOTE< 1 %
- Association Rule Learner< 1 %
- PCA< 1 %
Random Forest Predictor (Regression)< 1 %- Tree Ensemble Learner (Regression)< 1 %
Random Forest Learner< 1 %Random Forest Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Tree Ensemble Statistics< 1 %
Concatenate (Optional in)< 1 %- Case Converter< 1 %
- Cell Splitter< 1 %
- Category to Number (Apply)< 1 %
- Number to String< 1 %
- Many to One< 1 %
- Table Validator< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- HiLite Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Number Rounder< 1 %
- String Replacer< 1 %
- Ruleset Editor< 1 %
- Single sample t-test< 1 %
Color Appender< 1 %- ROC Curve (legacy)< 1 %
- Time Series Generator< 1 %
- Similarity Search< 1 %
- 2D Density Plot (Plotly)< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- H2O to Table< 1 %
- Math Formula (Multi Column)< 1 %
- Term Document Entropy< 1 %
- Document Vector< 1 %
- Google Sheets Reader< 1 %
- Boolean Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
Python Script (2⇒1)< 1 %- Duration to Number< 1 %
- Create Date&Time Range< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Time< 1 %
- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Aggregator< 1 %
- Twitter Post Tweet (legacy)< 1 %
- Twitter Users (legacy)< 1 %
Views
- Correlation Matrix
- Squared table view showing the pair-wise correlation values of all columns. The color range varies from dark red (strong negative correlation), over white (no correlation) to dark blue (strong positive correlation). If a correlation value for a pair of column is not available, the corresponding cell contains a missing value (shown as cross in the color view).
Workflows
05_Calculating_Rank_CorrelationsKNIME Hub- 05-k-means-wine-solutionKNIME Hub
- 05-k-means-wine-templateKNIME Hub
- 1.ReadData - solutionKNIME Hub
- OKKNIME Hub
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.