Harmonic Mean

Basic Exercise


Make an application to calculate the harmonic mean of selected values. Note: $MH = \frac{N}{\frac{1}{x_{1}}+\frac{1}{x_{2}}+\frac{1}{x_{3}}+...+\frac{1}{x_{n}}}$

Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Create a variable to add to the denominator the inverse $(\frac{1}{x})$ of the value in a cell. Use the counting of $n$ as the numerator.

Show Answer

Download exercise Download answer

SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2023 SuperExcelVBA | ABOUT

Protected by Copyscape