Geometric mean is the average rate of return of a set of values calculated using the products of. Convert 10 to a decimal and add 1 to it to get 110. 92052 1 - -7948 84736.
Usage notes The Excel GEOMEAN function calculates the geometric mean.
The Average annual growth rate AAGR is the average increase of an investment over a period of time. Geometric Mean 13276. 1 x 5 x 10 x 13 x 30 19500 and then calculate the 5-th root of 19500 721. If we substitute 06 for r 1 and 14 for r 2 equation 7 gives us 0992 ie the correct answer.