Function Math Statistics Class

GeometricMean

Geometric mean of positive numeric arguments.

Signature (Visual Basic / VBA)

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

Code Example

    GeometricMean(12, 34, 56) = 28.3758837790029
    GeometricMean(SampleData) = 143.25252990045

Parameters

Parameter Description
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 geometric mean of the numeric values. Function returns Null if none of the arguments are numeric.