GEOMEAN
Returns the geometric mean.
StatisticalStatistics & Analysis
What it does
Calculates the geometric mean of an array of positive data.
Syntax
GEOMEAN(number1, [number2], ...)
Arguments
number1(number) — First number or range.
Examples
Geometric Mean
Calculate for 4, 5, 8.
FORMULA
=GEOMEAN(A2:A4)
RESULT
5.43
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 4 |
| 3 | 5 |
| 4 | 8 |