If you've ever found yourself copying the same formula down hundreds of rows in Excel, you know how tedious it gets. The usual approach, dragging formulas, adjusting cell references, and hoping ...
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.