Manuals/calci/GEOMEAN

GEOMEAN(n1,n2,…)

Description

This function gives the Geometric Mean of an array or references.
For example, it is used to calculate average rate of growth of human population.
The Geometric Mean of two numbers is, the square root of their product.
The Geometric Mean of the three numbers is, the cube root of their product.
So the geometric mean of $n$ numbers is defined as the $n^{th}$ root of the product of the numbers.
In $GEOMEAN(n1,n2...)$ , $n1,n2...$ are the positive real numbers and $n1$ is required. $n2,n3...$ are optional.
The arguments can be numbers,names,arrays or references that contain numbers.
Also we can directly use logical values and text representations of numbers.
The values are ignored, when the argument contains logical values or empty cells.
The Geometric and Arithmetic Means are equal, when all the numbers in the given set are equal, otherwise the Geometric Mean of a data set is less than the data set's Arithmetic Mean.
The geometric mean of a data set $[a_{1},a_{2},...a_{n}]$ is given by:

$({\prod _{i=1}^{n}a_{i}})^{\frac {1}{n}}={\sqrt[{n}]{a_{1},a_{2}...a_{n}}}$

1.Any one of the argument is non-numeric
2.Any one  $value\leq 0$ 
3.Any one of the references cannot be translated in to numbers.

The syntax is to calculate GEOMEAN in ZOS is .
- $n1,n2...$ are the positive real numbers.
For e.g.,geomean(1,2,3,4,5),geomean(11.5..20.5..0.5)