skewPop

Computes the skewness of a sequence.

skewPop(expr)

Arguments

expr — Expression returning a number.

Returned value

The skewness of the given distribution. Type — Float64

Example

SELECT skewPop(value) FROM series_with_value_column;

skewPop

Introduced in: v20.1

Computes the skewness of a sequence.

Syntax

skewPop(expr)

Arguments

• expr — An expression returning a number. Expression

Returned value

Returns the skewness of the given distribution. Float64

Examples

Symmetric distribution

SELECT skewPop(number) FROM numbers(100);

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

Right-skewed distribution

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

┌─────────skewPop(x)─┐
│ 0.6735701055423582 │
└────────────────────┘