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 |
+---------------------------+