It is the average set of products technically defined as the n th root products of the expected number of periods. 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. Calculate monthly retirement income in Microsoft Excel.
The long-hand calculation would be.
How you calculate a geometric standard deviation however depends on which resource you are referencing. Calculate geometric average in Excel with GEOMEAN. In the example shown GEOMEAN is used to calculate a compound annual growth rate. Calculate a trimmed mean in Microsoft Excel.