var_pop

Computes the statistical variance of a population consisting of a numeric expression, as a double. varp is an alias for var_pop, and uses the same syntax.

Syntax

var_pop ( [all | distinct] expression )

Parameters

Examples

Usage

Computes the population variance of the provided value expression evaluated for each row of the group (if distinct was specified, then each row that remains after duplicates have been eliminated), defined as the sum of squares of the difference of value expression, from the mean of value expression, divided by the number of rows in the group or partition.

Formula for Population-Related Statistical Aggregate Functions
The formula for population-related statistical aggregate functions.

For general information about aggregate functions, see Aggregate Functions in Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute var_pop.

Related reference
stddev_pop
stddev_samp
var_samp