Geomean, 261 geomean – Apple iWork '09 User Manual
Page 261
Chapter 10
Statistical Functions
261
Related Topics
For related functions and additional information, see:
“GAMMADIST” on page 259
“GAMMAINV” on page 260
“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:
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15