Statistical

Correlation

Returns the Pearson coefficient of correlation of a set of number pairs –> learn more

CORR(@expression, @expression_2)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any float	true	-
@expression_2	variable or literal	any float	true	-

Covariance

Returns the covariance of a set of number pairs –> learn more

COVAR_@sample_type(@expression, @expression_2)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@sample_type	enum	any of: SAMP, POP	false	(Sample (default))
@expression	variable or literal	any float	true	-
@expression_2	variable or literal	any float	true	-

Standard deviation

Returns the standard deviation of all values –> learn more

STDDEV_@sample_type(@expression)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@sample_type	enum	any of: SAMP, POP	false	(Sample (default))
@expression	variable or literal	any float	true	-

Variance

Returns the variance of all values –> learn more

var_@sample_type(@expression)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@sample_type	enum	any of: SAMP, POP	false	(Sample (default))
@expression	variable or literal	any float	true	-