skewness()

Since 1.3.0

Calculate the skewness from the values in a statistical aggregate. The skewness is the third statistical moment. It is a measure of asymmetry in a data distribution.

Samples

Calculate the skewness of a sample containing the integers from 0 to 100:

SELECT skewness(stats_agg(data))
  FROM generate_series(0, 100) data;

skewness_x
----------
0

Arguments

The syntax is:

skewness(
  summary StatsSummary1D,
  [ method TEXT ]
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
summary	StatsSummary1D	-	✔	The statistical aggregate produced by a stats_agg call
method	TEXT	sample	-	The method used for calculating the skewness. The two options are population and sample, which can be abbreviated to pop or samp

Returns

Column	Type	Description
skewness	DOUBLE PRECISION	The skewness of the values in the statistical aggregate