CORR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the correlation coefficient between two sets of values.

  • <Y>: A double precision expression representing the dependent variable.
  • <X>: A double precision expression representing the independent variable.

Returns a double precision value representing the correlation coefficient, ranging from -1 to 1. Returns NULL if the computation is meaningless (e.g., no valid input pairs).

  • Returns NULL if there are no rows where both X and Y are non-null.
  • A value of 1 indicates perfect positive correlation.
  • A value of -1 indicates perfect negative correlation.
  • A value of 0 indicates no linear correlation.

Find the correlation between two variables.

Calculate correlation for each category.