The GEOMEAN and HARMEAN are advanced statistical functions that typically require a deeper understanding of mathematics. This is probably why they aren't taught as often as the AVERAGE function.

Chris Gallant, CFA, is a senior manager of interest rate risk for ATB Financial with 10 years of experience in the financial markets. Vikki Velasquez is a researcher and writer who has managed, ...

How to average with and without the highest and lowest values in Excel Your email has been sent The article How to do more advanced averaging in Excel reviews Microsoft Excel’s many averaging ...

This post explains how to calculate Weighted Average in Excel with percentages. In a standard arithmetic average where the sum of values is divided by the number of values, each data value is treated ...

Whenever you deal with mathematics or normalization statistics, you will often need to take a large set of numbers and reduce it to a smaller scale. This is usually done with a normalization equation ...