Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / KURT
In This Topic
    KURT
    In This Topic

    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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    GAMMADIST | Statistical Functions