Covar_Pop

This function calculates the covariance of a set of number pairs. It uses the following formula: (Sum(Y * X) - Sum(X) * Sum(Y)/n)/n, where n stands for the number of pairs (Y, X) where neither Y nor X is NULL.

Syntax:

Covar_Pop(Y, X)

Parameters:

• Y. Type: Number.
• X. Type: Number.

Example:

X	Y
1	7
2	1
3	2
4	5
5	7
6	34
7	32
8	43
9	87

SELECT Covar_Pop(Y, X) FROM Table

Result:

59.4444444

Next page: Covar_Samp