In principle, discovering new exoplanets is pretty easy. Simply measure the brightness of a star over time, and when a planet passes in front of the star, the brightness will dim slightly. The more ...
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.