writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 8:
Line 8: − + Line 21:
Line 21: − + − +
no edit summary
<div style="font-size:30px">'''GEOMEAN(n1,n2,…)'''</div><br/>
<div style="font-size:30px">'''GEOMEAN()'''</div><br/>
*<math>n1,n2...</math> are the positive real numbers.
*Parameters are any set of positive real numbers.
==Description==
==Description==
*The Geometric Mean of the three numbers is, the cube root of their product.
*The Geometric Mean of the three numbers is, the cube root of their product.
*So the geometric mean of <math>n</math> numbers is defined as the <math>n^{th}</math> root of the product of the numbers.
*So the geometric mean of <math>n</math> numbers is defined as the <math>n^{th}</math> root of the product of the 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.
*In <math>GEOMEAN()</math>, 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.
*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.
==ZOS==
==ZOS==
*The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN(n1,n2,...)</math>.
*The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN()</math>.
**<math>n1,n2...</math> are the positive real numbers.
**Parameters are any set of positive real numbers.
*For e.g.,GEOMEAN(1,2,3,4,5),GEOMEAN(11.5..20.5..0.5)
*For e.g.,GEOMEAN(1,2,3,4,5),GEOMEAN(11.5..20.5..0.5)
{{#ev:youtube|me2sEpY6LD4|280|center|Geometric Mean}}
{{#ev:youtube|me2sEpY6LD4|280|center|Geometric Mean}}