ReferenceSQL ReferenceAggregate Functions

stddevPopStable

The result is equal to the square root of varPop.

This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See SQL interface scope.

The result is equal to the square root of varPop. Unlike stddevPop, this function uses a numerically stable algorithm. It works slower but provides a lower computational error.

Syntax

stddevPopStable(x)

Arguments

Returned value

Returns the square root of the variance of x. Float64

Examples

Basic usage

DROP TABLE IF EXISTS test_data;
CREATE TABLE test_data
(
    population Float64,
)
ENGINE = Log;

INSERT INTO test_data SELECT randUniform(5.5, 10) FROM numbers(1000000);

SELECT
    stddevPopStable(population) AS stddev
FROM test_data;
┌─────────────stddev─┐
│ 1.2999977786592576 │
└────────────────────┘

Introduced in version 1.1.0.