KURTOSIS Function

Returns the kurtosis of all values in an expression.

Categories: Aggregate
Descriptive Statistics
Returned data type: DOUBLE

Syntax

KURTOSIS(expression)

Arguments

expression

specifies any valid SQL expression.

Data type DOUBLE
See <sql-expression>
FedSQL Expressions

Details

Kurtosis is primarily a measure of the heaviness of the tails of a distribution. Large values of kurtosis indicate that the distribution has heavy tails.
Null values and SAS missing values are ignored and are not included in the computation.
At least four nonnull or nonmissing arguments are required. Otherwise, the function returns a null value. If all nonnull or nonmissing arguments have equal values, the kurtosis is mathematically undefined and the KURTOSIS function returns a null value.
You can use an aggregate function to produce a statistical summary of data in the entire table that is listed in the FROM clause or for each group that is specified in a GROUP BY clause. The GROUP BY clause groups data by a specified column or columns. When you use a GROUP BY clause, the aggregate function in the SELECT clause or in a HAVING clause instructs FedSQL in how to summarize the data for each group. FedSQL calculates the aggregate function separately for each group. If GROUP BY is omitted, then all the rows in the table or view are considered to be a single group.

Example

Table: WORLDTEMPS
The following statement illustrates the KURTOSIS function:
Statements
Results
select kurtosis(AvgLow) from worldtemps;
-0.87431

See Also

Functions:
SELECT Statement Clauses:
Last updated: February 23, 2017