The Excel GEOMEAN Function

Related Function:
HARMEAN Function

GEOMETRIC MEAN
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 geometric mean of a set of values, y1, y2, ..., yn is calculated by the formula :
Geometric Mean Equation

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.

Further information can be found on the Wikipedia Geometric Mean page



Basic Description

The Excel GEOMEAN function calculates the geometric mean of a supplied set of values.

The format of the function is :

GEOMEAN( number1, [number2], ... )

Where the number arguments are 1 or more positive numeric values, for which you want to calculate the geometric mean.

These arguments can be supplied to the function either directly, as the results of other formulas, or as references to cells containing numeric values.

In Excel 2003 the function can accept up to 30 number arguments, but in Excel 2007 and Excel 2010 the function can accept up to 255 numbers.


Example of Excel Geomean Function

Geomean Function Example

Cell B1 of the spreadsheet on the right shows a simple example of the Excel Geomean Function, used to calculate the geometric mean of the values in cells A1-A5.

In this example, the Geomean function returns the value 1.622671112.


Further examples of the Excel Geomean function can be found on the Microsoft Office website.


Geomean Function Errors

If you get an error from the Excel Geomean function this is likely to be one of the following :

Common Errors
#NUM! - Occurs if any of the supplied values are negative
#VALUE! - Occurs if any of the supplied values cannot be interpreted as numeric values
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net