The KURT function in Excel is a statistical tool that measures the kurtosis of a data set. Kurtosis is a descriptor of the shape of the distribution of data points, providing insight into the tailedness and sharpness of the distribution. A high kurtosis indicates heavy tails and a sharp peak, while low kurtosis signifies lighter tails and a flatter peak.
Syntax
KURT(number1, [number2], ...)
- number1: This is required and represents the first number or range of numbers for which you want to calculate kurtosis.
- number2: This is optional and can be additional numbers or ranges, allowing up to 254 arguments in total.
Example #1
KURT(A1:A10)
Calculates kurtosis for the data in cells A1 through A10. For a dataset of [1, 2, 2, 2, 3, 3, 3, 3, 3, 4], it might return a result of 1.5625, indicating the data is leptokurtic (more peaked than a normal distribution).
Example #2
KURT(B1:B10, C1:C10)
This function evaluates the kurtosis of values in both B1:B10 and C1:C10. Suppose B1:B10 represents [1, 5, 2, 4, 5] and C1:C10 is [3, 2, 4, 1, 6], the result could be 0.5, which indicates a distribution flatter than normal.
Example #3
KURT(D1:D100)
This function determines the kurtosis of the 100 data points in the range D1:D100. If the dataset consists of numbers ranging from 1 to 100 arranged uniformly, it may yield a result close to 0, showing a normal distribution.
Error handling
- NUM!: This error occurs if the dataset provided has less than four data points, as kurtosis cannot be calculated with insufficient data.
- DIV/0!: This message appears when all provided numbers are the same, making variance zero and thus preventing kurtosis calculation.