KURT function
KURT returns the excess kurtosis of a data set, which describes how heavy its tails are compared with a normal distribution. Positive means more outliers, negative means fewer.
Example
Read it as a sentence: measure how sharply peaked the numbers in A1:A8 are, which gives 0.940625.
Excel shows 0.940625
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
Syntax
KURT(number1, [number2], ...)
Arguments in [square brackets] are optional.
-
number1(required) - First number, array or range.
-
number2(optional) - Further numbers or ranges.
Returns: The excess kurtosis of the data.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=KURT({2,4,4,4,5,5,7,9}) | 0.940625 | Array constant |
=KURT(Data!A1:A8) | 0.940625 | Range of numbers |
=KURT(Data!A1:A4,Data!F1:F5) | -0.811302645 | Two ranges |
=KURT(10,"20",TRUE) | #DIV/0! | Direct args: number, text-number, TRUE |
=KURT(10,"abc") | #VALUE! | Direct arg: non-numeric text |
=KURT(5) | #DIV/0! | Single number |
=KURT({1,"2",TRUE,3}) | #DIV/0! | Array with text and boolean |
=KURT(1,2,3) | #DIV/0! | Three points |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
F
1
2
1
2
4
2
3
4
3
4
4
4
5
5
5
6
5
7
7
8
9
Data
Watch out for
- Needs at least four values.
- Reports excess kurtosis, so a normal distribution is near 0.
Where it works
- Excel
- KURT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .