CORR

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 
└───────┘