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

Variance Function
Math Statistics Class

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

Variance of numeric arguments.

    Variance(12, 34, 56) = 484
    Variance(SampleData) = 563.55900621118
See also:
    VarianceArray Function
    VariancePopulation Function
    StandardDeviation Function
    AverageDeviation Function
    MedianDeviation Function
    DeviationsSquared Function
    StatVarType Property
    VAR Function (Microsoft Excel)
    VARA Function (Microsoft Excel)
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 variance of the numeric values. Function returns Null if there are fewer than two numeric values.

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