GEOMEAN

Description Computes the geometric mean of a list of positive numbers.

Syntax GEOMEAN (number_list)

Argument Description

number_list A list of between 1 and 30 arguments consisting of numbers, cell references, range references, and/or array constants. The arguments must evaluate to positive numbers or 0.Text and logical values in arrays or cells referenced by this function is ignored. Empty cells are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Argument	Description
number_list	A list of between 1 and 30 arguments consisting of numbers, cell references, range references, and/or array constants. The arguments must evaluate to positive numbers or 0.Text and logical values in arrays or cells referenced by this function is ignored. Empty cells are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Remarks The geometric mean is an alternative form of calculating a mean for a sample with strong positive skewedness and no negative values. It is obtained from a list of n numbers by taking the nth root of the product of the numbers.

Example This function returns 6.931:

GEOMEAN(1, 3, 5, 16, 42, 11)

This function returns 12:

GEOMEAN(24, 6)

See Also AVERAGE, COUNT, HARMEAN, SKEW