Formulas and Functions

Chapter 10 Statistical Functions 261
Related Topics
For related functions and additional information, see:
“GAMMADIST” on page 259
“GAMMAINV” on page 260
“LN” on page 179
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
GEOMEAN
The GEOMEAN function returns the geometric mean.
GEOMEAN(pos-num, pos-num…)
 pos-num: A positive number. pos-num is a number value and must be greater
than 0.
 pos-num…:Optionally include one or more additional positive numbers.
Usage Notes
GEOMEAN multiples the arguments to arrive at a product and then takes the root of Â
the product that is equal to the number of arguments.
Example
=GEOMEAN(5, 7, 3, 2, 6, 22) returns 5.50130264578853.
Related Topics
For related functions and additional information, see:
“AVERAGE” on page 231
“HARMEAN” on page 262
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15