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

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

  1. Response times with one long wait

    ABC
    1Response (min)
    235.80
    34
    44
    55
    66
    730

    In C2: =KURT(A2:A7) → 5.80

    Well above 0: the 30-minute wait is an outlier.

    Try this example

Common mistakes

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.

Translate a whole formula

Try KURT in the playground

Practise it

Related functions