Geometric mean is the average of a set of products technically, the nth root of n numbers.
The general formula for the geometric mean of n numbers is the nth root of their product.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range.
Examples
In the example shown, GEOMEAN is used to calculate a compound annual growth rate.
TRIMMEAN Function
The Excel TRIMMEAN function calculates mean (average) while excluding outliers.
The number of data points to exclude is provided as a percentage.
HARMEAN Function
The Excel HARMEAN function returns the harmonic mean for a set of numeric values.
The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.
Harmonic mean can be used to calculate a mean that reduces the impact of large outliers.
RRI Function
The Excel RRI function returns an equivalent interest rate for the growth of an investment.
you’re able to use RRI to calculate Compound Annual Growth Rate (CAGR) in Excel.
