GEOMEANThe GEOMEAN formula calculates the geometric mean, which is the nth root of the product of n numbers. It is commonly used to calculate average growth rates or ratios. The formula can take any number of arguments, but at least one argument is required.
- How to use
- Examples of using
GEOMEANformula not working?
- Similar formulas to
GEOMEAN formula with the syntax shown below, it has 1 required parameter:
- value1, value2, ... (required):
The numerical values for which to calculate the geometric mean. There must be at least one value.
ExamplesHere are a few example use cases that explain how to use the
GEOMEANformula in Google Sheets.
Calculate average growth rate
To calculate the average growth rate over a period of time, you can use GEOMEAN to find the nth root of the product of (1 + growth rate) for each period minus 1.
GEOMEAN can be used to calculate the average of ratios, such as debt-to-income ratios or expense-to-revenue ratios.
Calculate average return
To calculate the average return on an investment portfolio, you can use GEOMEAN to find the nth root of the product of (1 + return) for each period minus 1.
GEOMEANnot working? Here are some common mistakes people make when using the
GEOMEANGoogle Sheets Formula:
One of the values provided is not a number or is a negative number. GEOMEAN only works with positive numbers.
If any of the cells containing the values are empty, GEOMEAN will return an error.
Too many arguments
GEOMEAN only takes up to 30 arguments. If you provide more than 30, it will return an error.
Not enough arguments
GEOMEAN requires at least 2 arguments. If you provide less than 2, it will return an error.
If any of the values provided are zero, GEOMEAN will return an error.
The following functions are similar to
GEOMEAN or are often used with it in a formula:
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.
MEDIANfunction returns the median (middle) value of a set of numbers. It is commonly used to find the middle value in a range of data points. If the number of data points is even, it returns the average of the two middle values. This function can be useful in statistical analysis and data visualization.
STDEVfunction calculates the standard deviation of a set of numbers. It measures the amount of variation or dispersion of a set of values from the average (mean) value. It is commonly used in statistics to determine the spread of a data set. The values can be supplied as individual cells, ranges, or constants.
VARformula calculates the variance of a set of numerical values. Variance is a measure of how spread out a set of data is in relation to the mean. This formula is commonly used in statistical analysis to measure the variability or diversity of a dataset.
You can learn more about the
GEOMEAN Google Sheets function on Google Support.