Documentation/Calc Functions/GEOMEAN
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
GEOMEAN
Category:
Statistical Analysis
Summary:
Calculates the geometric mean of a set of positive numbers. The geometric mean of n numbers is obtained by multiplying the numbers and taking the n-th root of their product.
Syntax:
GEOMEAN(Number 1 [; Number 2 [; … [; Number 255]]])
Returns:
Returns a non-negative real number which is the geometric mean of the supplied numbers.
Arguments:
Number 1, Number 2, … , Number 255 give the set of real numbers for which the geometric mean is to be calculated. Each argument may take one of the following forms:
- A real number, or an expression that evaluates to a real number.
- A reference to a single cell containing a real number.
- A simple reference to a cell range containing real numbers.
- The name of a named range, comprising cells containing real numbers.
- The name of a database range, comprising cells containing real numbers.
- An inline array of real numbers (for example, {1.1, 2.2, 3.3, 4.4}).
Note that although GEOMEAN can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.
The following conditions (including errors) may be encountered:
- If any argument is a string in quotation marks, then GEOMEAN reports a parameter list error (Err:504).
- Text in cells and empty cells are ignored.
- If there are no supplied numbers, then GEOMEAN reports a #NUM! error.
- If any supplied number is negative, then GEOMEAN reports an invalid argument error (Err:502).
- If only one value is supplied, then GEOMEAN returns that value.
Additional details:
- The formula for calculating the geometric mean ([math]\displaystyle{ \bar{x}_{geom} }[/math]) of a dataset [math]\displaystyle{ \left\{ {x_1, x_2, \cdot \cdot \cdot, x_{n-1}, x_n} \right\} }[/math] is:
- [math]\displaystyle{ \bar{x}_{geom}~=~\left( \prod_{i=1}^{n} x_i \right)^\frac{1}{n}=\sqrt[n]{x_1\times x_2\times \cdot \cdot \cdot \times x_{n-1}\times x_n} }[/math]
- To find the value of n, use the COUNT function.
- For more information on the geometric mean, visit Wikipedia's Geometric mean page.
Examples:
Formula | Description | Returns |
---|---|---|
=GEOMEAN(A1:A5) where cells A1:A5 contain the values 1, 2, 3, 4, and 5 respectively. | Here the function calculates the geometric mean of the five values passed in a cell range. | 2.60517108469735 |
=GEOMEAN(23.4; 34.5; 45.6; 56.7) | Here the function calculates the geometric mean of the four values passed as individual arguments. | 38.0098112965012 |
=GEOMEAN({2; 4; 6; 8; 10; 12}) | Here the function calculates the geometric mean of the six values passed in an inline array. | 5.98759033104782 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
GEOMEAN