Changes

Jump to navigation Jump to search
Line 12: Line 12:  
*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 <math>[a1,a2,...an]</math> is given by:
+
*The geometric mean of a data set <math>[a_1,a_2,...a_n]</math> is given by:
<math>({\prod_{i=1}^n ai})^{\frac{1}{n}} = \sqrt[n]{a1, a2 ... an}</math>
+
<math>({\prod_{i=1}^n a_i})^{\frac{1}{n}} = \sqrt[n]{a_1, a_2 ... a_n}</math>
 
*This function will give the result as error when  
 
*This function will give the result as error when  
 
  1.Any one of the argument is non-numeric
 
  1.Any one of the argument is non-numeric
writer
6,694

edits

Navigation menu