CORR
Learn how to use the CORR aggregate function in PlaidCloud Lakehouse. Returns the Pearson correlation coefficient between two expressions.
Returns the Pearson correlation coefficient between two expressions.
Analyze Syntax
func.corr(get_column(table, 'revenue'), get_column(table, 'ad_spend'))
Analyze Examples
func.corr(get_column(table, 'revenue'), get_column(table, 'ad_spend'))
┌───────┐
│ 0.872 │
└───────┘
SQL Syntax
CORR(<revenue>, <ad_spend>)
SQL Examples
SELECT CORR(revenue, ad_spend) FROM marketing;
┌───────┐
│ 0.872 │
└───────┘