COVAR_POP

COVAR_POP returns the population covariance of a set of number pairs.

Syntax

COVAR_POP(expr0, expr1)

Arguments

Arguments	Description
expression0	Any numerical expression
expression1	Any numerical expression

Return Type

float64

Examples

SELECT covar_pop(number, number) FROM (SELECT * FROM numbers_mt(2) ORDER BY number ASC);
+---------------------------+
| covar_pop(number, number) |
+---------------------------+
|                      0.25 |
+---------------------------+