VARP

Returns the statistical variance for the population for all values in the specified expression.

Syntax

VARP ( [ DISTINCT ] expression  )  

Arguments

expression
An expression of numeric data type category.

DISTINCT Specifies that each unique value is considered.

Return Type

Returns a FLOAT64.

Examples

This example returns the variance for the population of all prices in the pricing blockchain.

SELECT VARP(price) FROM pricing;

Response:

VARP(PRICE) [FLOAT64]   
2372.5755150198906