HARMEAN

The HARMEAN function in Google Sheets calculates the harmonic mean of a dataset, a type of average best suited for rates and ratios, such as speeds or price-to-earnings figures. Dive into our comprehensive guide to master its application.

Parameters

• value1: The first value or range to include in the harmonic mean calculation.
• value2: [Optional] Additional values or ranges to include.

Step-by-Step Tutorial

1. Calculating the harmonic mean of numbers:

   • Example: =HARMEAN(2, 4, 8)
   • Result: 3.4285...

2. Calculating the harmonic mean of a range:

   • Example: If A1:A3 contains 60, 40, 30, then =HARMEAN(A1:A3) returns 41.5384...

Use Cases and Scenarios

1. Speed Calculations: Average speeds traveled over equal distances at different rates.
2. Financial Ratios: Average price-to-earnings ratios across a portfolio in a way that reduces the impact of outliers.
3. Rate Analysis: Combine rates, such as work rates or fuel efficiency, into a single representative average.

Related Functions

• AVERAGE: Returns the arithmetic mean of a dataset.
• GEOMEAN: Returns the geometric mean of a dataset.
• MEDIAN: Returns the median value of a dataset.

Related Articles

• Understanding Statistical Functions in Google Sheets