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

Average Function
Math Statistics Class

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

Average (mean) value of numeric arguments.

    Average(12, 34, 56) = 34
    Average(SampleData) = 145.152173913043
See also:
    AverageArray Function
    Median Function
    Mode Function
    GeometricMean Function
    HarmonicMean Function
    TrimMean Function
    Sum Function
    Count Function
    StatVarType Property
    AVERAGE Function (Microsoft Excel)
    AVERAGEA Function (Microsoft Excel)
vValues: The values that are to be averaged. 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 average (mean) of the numeric values. Function returns Null if none of the arguments are numeric.

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