GEOMEAN function

This topic describes the formula syntax and usage of the GEOMEAN function in the Data Quality Execute Formula transform.

Description

Returns the geometric mean of a range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.

Syntax

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

The GEOMEAN function syntax has the following arguments:

  • number1, number2, ... The first argument number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single range instead of arguments separated by commas.

Notes

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • If any data point ≤ 0, GEOMEAN generates an error.
  • The equation for the geometric mean is:

Example