Function Math Statistics Class

SkewArray

Returns the skewness of a distribution, as defined in Numerical Recipes in C, Second Edition. More efficient version of the Skew Function but with restrictions on the arguments it accepts. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Signature (Visual Basic / VBA)

Public Function SkewArray( _
    ByRef vValues As Variant _
    ) As Variant

Code Example

    SkewArray(Array(12, 34, 56)) = 0
    SkewArray(Array(12, 34, 78)) = 0.207826562129516
    SkewArray(SampleData) = 0.358004472742792

Parameters

Parameter Description
vValues Numeric-type array or Variant array containing only numeric elements. This function is NOT affected by the current setting of the StatVarType Property. It assumes that vValues is an array that contains only numeric elements.

Return Value

Function returns the skewness of the numeric values. Function returns Null if there are fewer than two numeric values in the array, or if there is some type of error, such as if the argument is a Variant array which contains an Object reference or String.