The GEOMEAN function returns the geometric mean of an array or range of positive data.
=GEOMEAN(num_1,[num_2], … )
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
|num_1||The first number, cell reference, or range for which you want the geometric mean|
|[num_2], …||Optional. Additional numbers, cell references or ranges for which you want the geometric mean, up to a maximum of 255|
|2||8||23||=GEOMEAN(A2:A9)||5.587767||Geometric mean of the data set contained in A2:A9|
|3||3||20||=GEOMEAN(A2:A9,B2:B5)||8.510038||Geometric mean of the data set contained in A2:A9 and B2:B5|
Usage note: Use GEOMEAN to calculate average growth rate given compound interest with variable rates.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied values cannot be interpreted as numeric values|
|#NUM!||Occurs if any of the supplied values are negative|
The geometric mean is a measure of mean that indicates the typical value of a set of numbers. This measure can only be used for positive values.
The equation for the geometric mean is:
Note that the Harmonic mean is always less than or equal to the Geometric mean and the Geometric mean is always less than or equal to the Arithmetic mean.
See Wikipedia for more information on geometric mean.