Returns the kurtosis of a data set.
Cú pháp
KURT(number1, [number2], ...)Đối số
number1bắt buộc
The first number, cell reference, or range for which you want to calculate kurtosis.
number2tùy chọn
Additional numbers, cell references, or ranges, up to 255 total.
The KURT function measures the 'tailedness' of a probability distribution, indicating whether the data has more or less extreme outliers than a normal distribution. A positive kurtosis indicates a peaked distribution, while a negative kurtosis indicates a flatter distribution.
=KURT(1, 2, 3, 4, 5)→-1.3Calculates the kurtosis for a simple set of five consecutive integers.
Select a cell
Click on the cell where you want to display the kurtosis result.
Enter the formula
Type =KURT( followed by the range of your data, then close the parenthesis.
Press Enter
Press the Enter key to calculate the kurtosis of the selected data set.
A kurtosis value of 0 indicates that the distribution has a shape similar to a normal distribution.