Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Visualization
Analytics
Correlation
Distance
K-Means Clustering
Principal Component Analysis
Factor Analysis
Linear Regression Analysis
Logistic Regression Analysis
Generalized Linear Models
Survival Curve
Cox Regression
Random Survival Forest
Decision Tree
Random Forest
XGBoost
Time Series Forecasting (Prophet)
Time Series Forecasting (ARIMA)
Time Series Clustering
Anomaly Detection
Word Count
Text Clustering with Topic Model (LDA)
Market Basket Analysis
T Test
ANOVA
Wilcoxon Test
Kruskal-Wallis Test
Chi-Square Test
A/B Test
Normality Test
Prediction
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Correlation
Calculates Correlations among columns.

Input Data

Input data should contain numeric columns.
  • Variable Columns - Numeric columns among which correlations are calculated.
  • Group By - Categorical column to group by. If you specify this, the analytics runs for each group.

Properties

  • Analytics Properties
    • Method - Method to calculate correlations. The default is "Pearson". This can be:
      • Pearson
      • Spearman
  • Correlation - This section is about "Correlations" View.
    • Show Only Lower Triangle - Show only lower triangle of the matrix, avoiding showing correlations for same pairs twice.
    • Show Diagonal Values - Show values on diagonal of the matrix, which should always have correlation of 1.
  • Significance - This section is about "Significance" View.
    • P Value Threshold to be Significant
    • Show Only Lower Triangle
    • Show Diagonal Values
  • Data - This section is about "Data" View.
    • Show Data From
      • Positive Correlations
      • Negative Correlations

How to Use This Feature

  1. 1.
    Click Analytics View tab.
  2. 2.
    If necessary, click "+" button on the left of existing Analytics tabs, to create a new Analytics.
  3. 3.
    Select "Correlation by Columns" for Analytics Type.
  4. 4.
    Click Variable Columns and open Column Selector Dialog.
  5. 5.
    Select Numeric Columns that you want to calculate correlation.
  1. 1.
    Click Run button to run the analytics.
  2. 2.
    Select view type (explained below) by clicking view type link to see each type of generated visualization.

"Correlations" View

"Correlations" View displays correlations with Heatmap. Red color means it has positive correlation and Blue color means it has negative correlation. The darker the color, the stronger the correlation.

"Significance" View

"Significance" View displays correlations with Scatter Plot. Gray color means it is not statistically significant. Red color means it has positive significant correlation and Blue color means it has negative significant correlation. You can check the p-values of the correlations by hovering the mouse pointer over the circles.

"Scatter Matrix" View

"Scatter Matrix" View displays the actual data distributions for each variable combination.

"Data" View

"Data" View displays the correlations for all the pairs of the selected columns in a table. By default the table is sorted by the correlation values. You can click the Column Header to sort the table based on any of the other columns.
  • Column 1 / Column 2
  • Correlation
  • P Value - P value from the t-test to determine the significance of the correlation.
  • t Value - t value from the t-test to determine the significance of the correlation.

R Package

The Correlation by Column uses cor function from stats R Package under the hood.

Exploratory R Package

For details about stats usage in Exploratory R Package, please refer to the github repository​
Previous
Analytics
Next
Distance
Last modified 4mo ago
Copy link
Contents
Input Data
Properties
How to Use This Feature
"Correlations" View
"Significance" View
"Scatter Matrix" View
"Data" View
R Package
Exploratory R Package