ReferenceFunctionsStatistics Functions
KURT
Returns the sample excess kurtosis of a numeric distribution.
Summary
KURT indicates tail heaviness relative to a normal distribution after Excel-style sample
correction.
Remarks
- Requires at least four numeric values.
- Returns
#DIV/0!when there are fewer than four numbers or zero sample standard deviation. - Positive values suggest heavier tails; negative values suggest lighter tails.
- Non-numeric values in ranges are ignored by statistical-collection rules.
Examples
Uniformly spaced values
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
-1.2
Heavier-tail sample
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
-2.3069755007920767
Related functions
Runtime metadata
Category
Statistics
Signature
KURT(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source