Aggregate. Computes the statistical variance of a population consisting of a numeric-expression, as a float.
Syntax
var_pop ( numeric-expression )
Parameters
| numeric-expression | A set of rows. expression is commonly a column name. |
Usage
This function converts its argument to float, performs the computation in double-precision floating point, and returns a float. The population-based variance (s2) of numeric-expression (x) is computed according to this formula:
This variance does not include rows where numeric-expression is NULL. The function returns NULL for a group containing no rows.
The variance of a population could be used as a measure of assessing risk.