Excel functions / Statistics
KURT function
Kurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
Syntax
=KURT(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
When to use it
KURT gives the excess kurtosis: positive when the data has more extreme values than a normal distribution would, negative when it has fewer. It needs at least four values.
Examples
Response times with one long wait
A B C 1 Response (min) 2 3 5.80 3 4 4 4 5 5 6 6 7 30 In C2:
=KURT(A2:A7)→ 5.80Well above 0: the 30-minute wait is an outlier.
Common mistakes
- Few values. Kurtosis from a handful of values is unreliable. Look at the data with a histogram too.
KURT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: KURT
- Danish: TOPSTEJL
- Dutch: KURTOSIS
- Finnish: KURT
- French: KURTOSIS
- German: KURT
- Hungarian: CSÚCSOSSÁG
- Italian: CURTOSI
- Norwegian: KURT
- Polish: KURTOZA
- Portuguese (Brazil): CURT
- Portuguese (Portugal): CURT
- Russian: ЭКСЦЕСС
- Spanish: CURTOSIS
- Swedish: TOPPIGHET
- Turkish: BASIKLIK
Practise it
Related functions
- SKEW: Skewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
- STDEV: Standard deviation of a sample.
- FREQUENCY: Counts how many values fall into each bin, for a histogram. Spills one more count than there are bins: the last counts values above the top bin.