|
<< Click to Display Table of Contents >> KURT (kurtosis) |
Syntax:
KURT(Number1, Number2, Number3, Number4 [, Number5 ...])
or
KURT(Range1 [, Range2, Range3 ...])
Description:
This returns the kurtosis of a probability distribution.
The kurtosis is a measure of the "peakedness" of a distribution compared to a normal distribution.
For a steeper curved ("narrow-peaked") distribution, the kurtosis is a positive value, while for a flatter curved ("broad-peaked") distribution, it is a negative value.
If the kurtosis approaches zero, the distribution has a good approximation to a normal distribution (see NORM.DIST/NORMDIST function).
Number1, Number2, Number3, etc., are the values to be evaluated. Empty cells, text and logical values are ignored.
At least four values have to be specified; otherwise, the function returns a #DIV/0! error value (division by zero).
Note:
This function does not accept value pairs (x value and y value) as arguments, but only the values of the distribution. If the same values appear multiple times, they must be repeated in the argument list accordingly (see example).
Example:
You measured the height of several test persons and obtained the following results: 1 x 1.60m, 2 x 1.65m, 4 x 1.70m, 2 x 1.75m and 1x1.80m.
To calculate the kurtosis of this distribution, the following formula can be used:
KURT(1.60, 1.65, 1.65, 1.70, 1.70, 1.70, 1.70, 1.75, 1.75, 1.80) returns 0.08036.
See also: