Description Computes the kurtosis of a list of numbers.
Syntax KURT ( number_list )
Argument | Description |
---|---|
number_list | A list of between 1 and 30 arguments consisting of values, cell references, range references, and/or array constants. The argument(s) must contain at least 4 numbers.All numeric values, including 0, are used. Text and logical values in array constants and cells referenced by this function are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Remarks Kurtosis measures the peakedness of the curve around its mean. A kurtosis of zero is approximately the same as the normal distribution; a larger kurtosis indicates a more pronounced central peak, while a smaller kurtosis indicates a flattened distribution around the peak.
Kurtosis is also known as the fourth movement, the first three being mean, standard deviation, and skewness.
Equation
where s is the sample standard deviation.
Example This function returns -1.2:
See Also AVEDEV, AVERAGE, COUNT, DEVSQ, SKEW