<-- Previous || Up || Next -->

Skew Excel Array Function
Math Statistics Class

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

Returns the skewness of a distribution, as defined by Microsoft Excel.
More efficient version of the SkewExcel Function but with restrictions on the arguments it accepts.
The skewness characterizes the degree of asymmetry of a distribution around its mean.

Examples: 
    SkewExcelArray(Array(12, 34, 56)) = 0
    SkewExcelArray(Array(12, 34, 78)) = 0.935219529582824
    SkewExcelArray(SampleData) = 0.369981667557386
See also: 
    SkewExcel Function
    SkewArray Function
    KurtosisExcelArray Function
    StandardDeviationArray Function
    StandardDeviationPopulationArray Function
    VarianceArray Function
    VariancePopulationArray Function
    AverageArray Function
    SKEW Function (Microsoft Excel)
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 three 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.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.