GEOMEAN
Syntax:
GEOMEAN ( argument-list )
Description: Computes the geometric mean of an array or range of positive data.
Mathematical Formula:
Arguments:
Name |
Type |
Description |
|---|---|---|
argument-list |
logical, number, name, array, or reference to number. |
The arguments in argument-list designate the values to be averaged. Logical values and text representations of numbers that entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included. |
Return Type and Value: number – The geometric mean of an array or range of positive data.
However, if the value of any data point ≤ 0, #NUM! is returned.
example: