KURTOSIS Function | Teradata Vantage - KURTOSIS - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
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