Manuals/calci/GEOMEAN

From ZCubes Wiki
Revision as of 21:36, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''GEOMEAN''' (n1, n2...)</font></font> <font size="3"><font face="Tim...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

GEOMEAN (n1, n2...)

n1, n2 etc are parameters. You can also give as an array or use array reference.


To calculates the geometric mean. Parameter can be an array.


·        Parameters are numbers, names, arrays, and references.

·        Here logical values and the text representations of numbers are calculated.

·        GEOMEAN calculates the error value when data point ≤ 0.

Formulas:-

*                       The equation to find out the geometric mean is:


GEOMEAN


 

GEOMEAN (B2, B3, B4, B5)

GEOMEAN (2, 4, 6, 8) = 4.4267


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 2 4.426728
Row2 4
Row3 6
Row4 8
Row5
Row6