Manuals/calci/GEOMEAN
Jump to navigation
Jump to search
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 |