GEOMEAN

Formulas / GEOMEAN
Calculate the geometric mean.
=GEOMEAN(number1,[number2],...)
  • number1 - required, number or reference
  • number2 - [OPTIONAL] number or reference

Examples

  • =GEOMEAN(D6:D10)-1

    The GEOMEAN function is used to calculate the geometric mean of a set of numbers. This allows you to calculate the average of multiple numbers, taking into account their individual values. This example takes the geometric mean of the values in cells D6 to D10 and subtracts one from the result. This is useful for statistical analysis and other calculations.

  • =GEOMEAN(D6:D10)-1

    The GEOMEAN function can be used to calculate the average growth rate over a set period of time. For example, if you have a list of stock prices from the beginning of the year to the end of the year, you can use the GEOMEAN function to calculate the average growth rate of the stock over that time period. For example, this formula takes the geometric mean of the values in cells D6 to D10 and subtracts one from the result. This will give you the average growth rate of the stock.

  • =GEOMEAN(D6:D10)-1

    The GEOMEAN function can also be used to calculate the average of a set of numbers that are not all the same. For example, if you have a list of different types of fruits and their prices, you can use the GEOMEAN function to calculate the average price of the fruits. This example takes the geometric mean of the values in cells D6 to D10 and subtracts one from the result.


Summary

The GEOMEAN function is used to calculate the geometric mean of an array or range of data, which must be composed of positive numbers, arrays, or references. It is not compatible with logical values or text representations of numbers.

  • The GEOMEAN function takes multiple arguments, which can be numbers, names, arrays, or references.
  • The GEOMEAN function ignores empty cells and cells with text or logical values.

Frequently Asked Questions

What is the GEOMEAN function?
The GEOMEAN function is a spreadsheet function that calculates the average growth rate when given compound interest and variable rates.
What type of arguments does the GEOMEAN function take?
The GEOMEAN function takes numerical arguments. These arguments are required and can be either numbers or names, arrays or references that contain numbers. Subsequent arguments are optional.
How do I use the GEOMEAN function?
To use the GEOMEAN function, you must first enter numerical arguments. These arguments can be numbers, names, arrays, or references that contain numbers. Subsequent arguments are optional. Then, click the "Calculate" button to calculate the average growth rate.
What are some examples of the GEOMEAN function?
Here are some examples of the GEOMEAN function:
  • GEOMEAN(2, 5, 8) returns 4.8
  • GEOMEAN("A1", "B2", "C3") returns the average growth rate of the numbers in the referenced cells
  • GEOMEAN(A1:C3) returns the average growth rate of the numbers in the range

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV