skewSamp

Computes the sample skewness of a sequence.

skewSamp

Introduced in: v20.1.0

Computes the sample skewness of a sequence.

It represents an unbiased estimate of the skewness of a random variable if passed values form its sample.

Syntax

skewSamp(expr)

Arguments

• expr — An expression returning a number. Expression

Returned value

Returns the skewness of the given distribution. If n <= 1 (n is the size of the sample), then the function returns nan. Float64

Examples

Symmetric distribution

Query

SELECT skewSamp(number) FROM numbers(100);

Response

┌─skewSamp(number)─┐
│                0 │
└──────────────────┘

Right-skewed distribution

Query

SELECT skewSamp(x) FROM (SELECT pow(number, 2) AS x FROM numbers(10));

Response

┌────────skewSamp(x)─┐
│ 0.5751042382747413 │
└────────────────────┘