KURTOSIS Function | Teradata Vantage - KURTOSIS - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

Returns the kurtosis of the distribution of value_expression.

This function returns the REAL data type.

To invoke the time series version of this function, use the GROUP BY TIME clause. For more information, see Teradata Vantage™ - Time Series Tables and Operations, B035-1208.

Kurtosis

Kurtosis is the fourth moment of the distribution of the standardized (z) values. It is a measure of the outlier (rare, extreme observation) character of the distribution as compared with the normal, Gaussian distribution.

The normal distribution has a kurtosis of 0.

Positive kurtosis indicates that the distribution is more outlier-prone than the normal distribution, while negative kurtosis indicates that the distribution is less outlier-prone than the normal distribution.

Computation

The equation for computing KURTOSIS is defined as follows:



where:

This variable … Represents …
x value_expression