This function calculates the population variance of a set of numbers after discarding NULL values from this set. It uses the following formula: (Sum(X ^2) - Sum(X)^2/Quantity(X))/(Quantity(X).
Syntax:
Var_Pop(Expression)
Parameter:
Expression. Type: Number.
Example:
X |
Y |
1 |
7 |
2 |
1 |
3 |
2 |
4 |
5 |
5 |
7 |
6 |
34 |
7 |
32 |
8 |
43 |
9 |
87 |
SELECT Var_Pop(Y, X) FROM Table
Result:
716.17284
Next page: Covar_Pop