Manuals/calci/GEOMEAN
GEOMEAN (n1, n2...)
n1, n2 etc are parameters. You can also give as an array or use array reference.
To calculates the geometric mean. Parameter can be an array.
· Parameters are numbers, names, arrays, and references.
· Here logical values and the text representations of numbers are calculated.
· GEOMEAN calculates the error value when data point ≤ 0.
Formulas:-
* The equation to find out the geometric mean is:
GEOMEAN
GEOMEAN (B2, B3, B4, B5)
GEOMEAN (2, 4, 6, 8) = 4.4267
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 4.426728 | ||
| Row2 | 4 | |||
| Row3 | 6 | |||
| Row4 | 8 | |||
| Row5 | ||||
| Row6 |
