Main > Knowledge Base > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Var_Pop > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Var_Pop > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Var_Pop

Var_Pop

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




© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.