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.