Skip to content

geomean

Geometric mean.

v = geomean(number1, number2, ...)

Returns the geometric mean ((x1 · x2 · ... · xn)^(1/n)) of the positive numeric arguments. All values must be positive; non-positive values raise a #NUM! error.

geomean(2, 4, 8) % 4
  • harmean — Harmonic mean.
  • average — Arithmetic mean of numeric arguments (Excel-compatible).