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.
The simple definition of a mean is that of a numeric quantity which represents the center of a collection of numbers. Here the trick lies in defining the exact type of numeric collection, as beyond ...