(Showing Draft Content)

This function returns the kurtosis of a data set.

Syntax

KURT(value1, value2, value3, value4, ...)

KURT(array)

KURT(array1, array2, ...)

Arguments

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.

Remarks

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.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

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