Changes

*<math>n1,n2</math> are the positive real numbers.

*<math>n1,n2</math> are the positive real numbers.

==Description==

==Description==

*This function gives the geometric mean of an array or references.

*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.  

*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 and the geometric mean of the three numbers is the cube root of their product.  

*The Geometric Mean of two numbers is, the square root of their product.

*So the geometric mean of n numbers is defined as the nth root of the product of the numbers.

*The Geometric Mean of the three numbers is, the cube root of their product.  

*In GEOMEAN(n1,n2...)n1,n2.., are positive real numbers and n1 is required. n2,n3.. are optional.

*So the geometric mean of <math>n</math> numbers is defined as the <math>n^{th}</math> root of the product of the numbers.

*The  arguments  can be numbers ,names, arrays or references that contain numbers.  

*In <math>GEOMEAN(n1,n2...)</math>, <math>n1,n2...</math> are the positive real numbers and <math>n1</math> is required. <math>n2,n3...</math> 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.

*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 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 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 {a1,a2 ...,an} is given by:

*The geometric mean of a data set {a1,a2 ...,an} is given by:

[PI(){i=1 to n} ai] ^{1/n} = sqrt[n]{a1, a2 ... an}.

<math>{\prod_{i=1}^n ai}^{\frac{1}{n}} = \sqrt[n]{a1, a2 ... an}</math>

*This function will give the result as error when  

*This function will give the result as error when  

#Any one of the argument is nonnumeric

1.Any one of the argument is non-numeric

#Any one value<=0

2.Any one <math>value \le 0</math>

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

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

==Examples==

==Examples==