HARMEAN
Formulas / HARMEANCalculate 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.
Need help with Formulas?
Frequently Asked Questions
What is the HARMEAN function?
What types of values can I use in the HARMEAN function?
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
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.