Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu

HARMEAN function

Description

Harmonic mean function. HARMEAN(range) computes the harmonic mean of the contents of the cells in the specified range.

The harmonic mean is calculated as follows:

Harmonic mean$$\frac{n}{\frac1{x_1} + \frac1{x_2} + \cdots + \frac1{x_n}} = \frac{n}{\sum\limits_{i=1}^n \frac1{x_i}} $$

The harmonic mean is undefined for a data set that contains zero or negative values.

Calculator

HARMEAN(,,,,)

Related functions