For financial investment return calculations the geometric mean is calculated on the decimal multiplier equivalent values not percent values ie a 6 increase becomes 106. GEOMEAN number1 number2 The GEOMEAN function syntax has the following arguments. To calculate the geometric mean we take their product instead.
5th Square Root of 1 005 1 01 1 02 1 05 1 02 1 -003621 Multiply the result by 100 to calculate the percentage.
GEOMEAN number1 number2 The GEOMEAN function syntax has the following arguments. For financial investment return calculations the geometric mean is calculated on the decimal multiplier equivalent values not percent values ie a 6 increase becomes 106. In order to calculate Geometric Mean we multiply the given numbers altogether and then take a square root given that there are two numbers or cube root for three numbers 5 th root for five numbers etc. Which is 16 millimeters or about the thickness of a coin.