Documentation/Calc Functions/GEOMEAN

Function name:
GEOMEAN

Category:
Statistical Analysis

Summary:
Calculates the geometric mean of a set of numbers. The geometric mean of a set of N numbers is the Nth root of the product of the numbers.

Syntax:
GEOMEAN(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a non-negative real number which is the geometric mean of the set of numbers.

Arguments:
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers for which the geometric mean is to be calculated.


 * If any of the arguments contain a value less than zero then the function returns an error value. However, empty cells and those with non-numeric (except for logical) values are ignored.

Additional details:

 * The formula for GEOMEAN is:

where N is the set of numbers passed as arguments and n is the size of that set. To find the value of n, use the function COUNT(N).
 * For more details on the geometric mean, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUNT COUNT]

ODF standard:
Section 6.18.34

Equivalent Excel functions:
GEOMEAN