|
<< Click to Display Table of Contents >> KURT (kurtosis) |
Syntax:
KURT(Number1, Number2, Number3, Number4 [, Number5 ...])
or
KURT(Range1 [, Range2, Range3 ...])
Description:
Returns the kurtosis of a probability distribution.
The Kurtosis is a measure of the "peakedness" of a distribution compared a normal distribution.
For a steeper arched ("narrow-peaked") distribution the kurtosis is a positive value, for a flatter arched ("broad-peaked") curve 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 given, 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:
Measuring the height of several test persons led to 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: