Skip to content

variance_y() | variance_x()

Calculate the variance from a two-dimensional statistical aggregate for the dimension specified

Since 1.3.0

Calculate the variance from a two-dimensional statistical aggregate for the given dimension. For example, variance_y() calculates the variance for all the values of the y variable, independent of values of the x variable.

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

SELECT variance_y(stats_agg(data, data))
FROM generate_series(0, 100) data;
variance_y
----------
858.5

The syntax is:

variance_y(
summary StatsSummary2D,
[ method TEXT ]
) RETURNS DOUBLE PRECISION
variance_x(
summary StatsSummary2D,
[ method TEXT ]
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
summaryStatsSummary2D-✔The statistical aggregate produced by a stats_agg call
methodTEXTsample-The method used for calculating the variance. The two options are population and sample, which can be abbreviated to pop or samp
ColumnTypeDescription
variance_y | variance_xDOUBLE PRECISIONThe variance of the values in the statistical aggregate