Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu

GEOMEAN function

Description

Geometric mean function. GEOMEAN(range) computes the geometric mean of the contents of the cells in the specified range.

The geometric mean is calculated as follows:

Geometric mean$$\left ( \prod_{i=1}^n{x_i} \right ) ^\tfrac1n = \sqrt[n]{x_1 x_2 \cdots x_n} = \exp\left[\frac1n\sum_{i=1}^n\ln x_i\right] $$

The geometric mean is undefined for a data set that contains zero or negative values.

Calculator

GEOMEAN(,,,,)

Related functions