HARMEAN

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

Syntax HARMEAN (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 This is an alternative form of calculating a mean for a sample with strong positive skewedness and no negative values. It is obtained by taking the reciprocal of the arithmetic mean of the reciprocals of a list of numbers.

The result of HARMEAN is smaller than the geometric mean calculated by GEOMEAN.

Example This function returns 9.731:

HARMEAN(5,4,25,60,14,26)

See Also AVERAGE, COUNT, GEOMEAN, SKEW