Manuals/calci/GEOMEAN

GEOMEAN()

Parameters are any set of positive real numbers.
- GEOMEAN(),Returns the geometric mean.

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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} numbers is defined as the Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle n^{th}} root of the product of the numbers.
In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle GEOMEAN()} , Parameters are any set of positive real numbers and first parameter is required. From second parameters 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle [a_1,a_2,...a_n]} is given by:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ({\prod_{i=1}^n a_i})^{\frac{1}{n}} = \sqrt[n]{a_1, a_2 ... a_n}}

This function will give the result as error when

1.Any one of the argument is non-numeric
2.Any one Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle value \le 0}

3.Any one of the references cannot be translated in to numbers.

ZOS

The syntax is to calculate GEOMEAN in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle GEOMEAN()} .
- Parameters are any set of positive real numbers.
For e.g.,GEOMEAN(1,2,3,4,5),GEOMEAN(11.5..20.5..0.5)