Formulas and Functions

GEOMEAN
The GEOMEAN function returns the geometric mean of the specified number values.
GEOMEAN(pos-num, pos-num…)
pos-num: A number greater than 0.
pos-num…: Optionally include one or more additional positive numbers.
Notes
GEOMEAN multiplies 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. This is calculated by first determining the product of the arguments [5*7*3*2*6*22=27, 720], and then taking the 6th root (since there are six arguments) thereof [27720^(1/6)=5.50130264578853]. |