Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.
Syntax
KURT(number1,number2, ...)
Number1,number2, ... are 1 to 30 arguments for which you want to calculate kurtosis. You can also use a single array or a reference to an array instead of arguments separated by commas.
Remarks
where:
s is the sample standard deviation.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Data | |
---|---|
3 | |
4 | |
5 | |
2 | |
3 | |
4 | |
5 | |
6 | |
4 | |
7 | |
Formula | Description (Result) |
=KURT(A2:A11) | Kurtosis of a data set above (-0.1518) |