Function Math Statistics Class

SkewExcel

Returns the skewness of a distribution, as defined by Microsoft Excel. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Signature (Visual Basic / VBA)

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

Code Example

    SkewExcel(12, 34, 56) = 0
    SkewExcel(12, 34, 78) = 0.935219529582824
    SkewExcel(SampleData) = 0.369981667557386

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 skewness of the numeric values. Function returns Null if there are fewer than three numeric values.