Skip to main content

STDEVP

Returns the statistical standard deviation for the population for all values in the specified expression.

Syntax

STDEVP ( [ 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 standard deviation for the population of all prices in the pricing blockchain.

SELECT STDEVP(price) FROM pricing;

Response:

STDEVP(PRICE) [FLOAT64] 
48.70909068151335