VAR_POP

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the population variance of input values (square of the population standard deviation).

  • <expression>: An expression of any numerical type.
  • NUMERIC(38,6) for integer-type or numeric arguments.
  • double precision for floating-point arguments.

Returns NULL if the computation is meaningless.

  • Uses N in the denominator (no Bessel's correction).
  • Population variance is the square of STDDEV_POP.
  • Use VAR_SAMP or VARIANCE for sample variance.
  • Cast the input to double precision to get a double precision result.

Find the population variance of scores.

Calculate for each group.