The geometric mean is the average of a relevant set of quantities multiplied together to produce a product. The Geometric Mean GM of a series containing n observations is the nth root of the product of the values. To to this we use the growth factor values in column D in the GEOMEAN function then subtract 1.
If all 𝑿 0 and 𝑵 is odd The geometric mean in terms of th root is.
Where the number arguments are one or more positive numeric values or arrays of numeric values for which you want to calculate the geometric mean. What if there are 2 growth rates and the product turned out to be negative. Geometric Mean Product of 1 Rn 1n -1. The arithmetic mean would be 4 92 65.