HARMEAN

Formulas / HARMEAN
Calculate the harmonic mean.
HARMEAN(number1, [number2], ...)
  • number1, number2, ... - the arguments for which to calculate the mean

Examples

  • =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.

Summary

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.

Frequently Asked Questions

What is the HARMEAN function?
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.
What types of values can I use in the HARMEAN function?
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.
What are some examples of using the HARMEAN function?
  • 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

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.