Calculate the harmonic mean.

`HARMEAN(number1, [number2], ...)`

- number1, number2, ... - the arguments for which to calculate the mean

`=HARMEAN(A2:A8)`

The HARMEAN function can be used to calculate the harmonic mean of a set of data. For example, if you have a set of numbers in cells A2 through A8, you can use the function to calculate the harmonic mean of that set by entering the formula into a cell.

`=HARMEAN(A2:A8)`

The harmonic mean is a type of average and is used when dealing with data that has an outlier or a large range of values. For example, if you have a set of numbers that range from 7 to 1000, the harmonic mean will give you a better idea of the average of the data than the arithmetic mean or median. To calculate the harmonic mean of this data set, you can use the HARMEAN function and enter the formula into a cell.

`=HARMEAN(A2:A8)`

The harmonic mean is also useful for calculating the average of fractions or ratios. For example, if you have a set of fractions in cells A2 through A8, you can use the HARMEAN function to calculate the harmonic mean. To do this, enter the formula into a cell.

The HARMEAN function is used to calculate the harmonic mean of a set of data. The harmonic mean is always less than the arithmetic mean.

- The HARMEAN function calculates the harmonic mean of numerical values.
- Sourcetable ignores empty cells, cells with text or logical values, when calculating the harmonic mean.

The HARMEAN function is a Sourcetable function that calculates the harmonic mean of a data set. The harmonic mean is always less than the arithmetic mean.

You can use numerical values and logical values in the HARMEAN function. Text representations of numbers that are typed directly in the HARMEAN function's arguments are also counted.

- Calculating the harmonic mean of a set of numbers
- Calculating the harmonic mean of a set of logical values
- Calculating the harmonic mean of a set of text representations of numbers