GEOMEAN (First, Other...) GEOMEAN (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number Number
The geometric mean of the parameters.
Returns the geometric mean of the parameters. The geometric mean of n values is the n th root of their product. It is the correct average for growth factors. All values must be positive.
Examples
GEOMEAN (23.5, 46.7, { 69.5, 4.54 })
GEOMEAN (23,5; 46,7; { 69,5; 4,54 })
Returns roughly 24.3. Arrays are supported.
GEOMEAN (1.1, 1.2)
GEOMEAN (1,1; 1,2)
Returns roughly 1.149. Growth of 10% followed by growth of 20% is the same as growth of 14.9% twice, not 15% twice.