variance()

Calculate the variance from a one-dimensional statistical aggregate

Since 1.3.0

Calculate the variance from the values in a statistical aggregate.

Samples

Calculate the variance of a sample containing the integers from 0 to 100:

SELECT variance(stats_agg(data))
  FROM generate_series(0, 100) data;

variance
----------
858.5

Arguments

The syntax is:

variance(
  summary StatsSummary1D,
  [ method TEXT ]
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
summary	StatsSummary1D	-	✔	The statistical aggregate produced by a stats_agg call
method	TEXT	sample	-	The method used for calculating the standard deviation. The two options are population and sample, which can be abbreviated to pop or samp

Returns

Column	Type	Description
variance	DOUBLE PRECISION	The variance of the values in the statistical aggregate