Versions:
kurtosis() / kurtosis_y() / kurtosis_x() ToolkitTimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.
Toolkit
TimescaleDB Toolkit functions are available under Timescale Community Edition. They are automatically included with Timescale Cloud. Click to learn more.
kurtosis(summary StatsSummary1D, method TEXT) RETURNS BIGINT
kurtosis_y(summary StatsSummary2D, method TEXT) RETURNS BIGINT
kurtosis_x(summary StatsSummary2D, method TEXT) RETURNS BIGINT
Calculate the kurtosis, or the 4th statistical moment, of the values contained
in a statistical aggregate. In a two-dimensional stats_agg
use
the _y
/ _x
form to access the kurtosis
of the dependent and independent variables.
The method
determines whether you calculate a population or sample kurtosis. These
values can be provided as their full names, or you can abbreviate them as pop
or samp
.
These are the only four accepted values for the method
argument. The default is sample
.
For more information about statistical aggregate functions, see the hyperfunctions documentation.
Required arguments
Name | Type | Description |
---|---|---|
summary | StatsSummary1D /StatsSummary2D | The already constructed data structure from a previous stats_agg call |
Optional arguments
Name | Type | Description |
---|---|---|
method | TEXT | The method for the calculation 'population' or 'sample' (default) |
Returns
Column | Type | Description |
---|---|---|
kurtosis /kurtosis_y /kurtosis_x | DOUBLE PRECISION | The kurtosis of the values in the statistical aggregate |
Sample usage
SELECT kurtosis_y(stats_agg(data, data))
FROM generate_series(0, 100) data;
kurtosis_y
------------
1.78195
Found an issue on this page?
Report an issue!