Function Math Statistics Class

KurtosisExcel

Returns the kurtosis of a distribution, as defined by Microsoft Excel. Measures the relative peakedness or flatness of a distribution.

Signature (Visual Basic / VBA)

Public Function KurtosisExcel( _
    ParamArray vValues() As Variant _
    ) As Variant

Code Example

    KurtosisExcel(12, 34, 56, 78) = -1.2
    KurtosisExcel(SampleData) = -0.066025135059001

Parameters

Parameter Description
vValues The values that are to be processed. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.

Return Value

Function returns the kurtosis of the numeric values. Function returns Null if there are fewer than four numeric values.