variancep — aggregate function to return the population variance of a range of values.


variancep (expr)


This function computes a value for each record returned by the query predicate, or from the specified column of a base table, and returns the population variance of those values.

This variancep() function is similar to the variance() function, but is calculated using the biased (or n) method. The variancep() function is usually used when the incoming data represents the entire population of data. Use variance() instead when the incoming data represents a random sample.

Expression expr must include the name of a column in a LiveView table, where that column's data type is int, long, or double. The returned value is of type double.


This LiveView aggregate function is based on the variancep aggregate function in the StreamBase expression language.