This function returns the kurtosis of a data set.
KURT(value1,value2,value3,value4,...)
KURT(array)
KURT(array1,array2,...)
For the arguments, you can use numbers, arrays, or references. If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes cells with the value zero in its calculations.
You must provide four or more value arguments. You may provide up to 255 arguments.
Kurtosis describes how peaked or flat a distribution is compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.
If the standard deviation of the values is zero, this function returns the #DIV/0! error value.
Accepts numeric data for all arguments. Returns numeric data.
KURT(F1:F8)
KURT(R1C6:R8C6)
KURT(F1:F8,G1:G8)
KURT(35,31,47,51,37,31,58,39) gives the result -0.7496238078