GEOMEAN(list)

The GEOMEAN function calculates the geometric mean of a list of numbers.

Each number y of the list should be > 0.

The formula for the geometric mean is:

image\ebx_-514590873.gif

For example:

GEOMEAN(3, 8, 7)

returns 5.5178, that is the 3rd or cubed root of 3*8*7.

See also:

Other statistical functions