The geometric mean and standard deviation should be used for investments that have a maturity horizon of one year or more because it accounts for the compounding that occurs over multiple years. Assuming that you are using it for an investment with “P” number of periods per year and that spans “n” years, the following equations can be used to derive the annual geometric mean and standard deviations of the investment’s returns. Note that if the number of periods is only 1 (i.e., you are using annual returns in your analysis), then the equations collapse to just using “n” the number of years:
Geometric Mean (GM)
CAGR stands for compound annual growth rate, and it is equivalent to the geometric mean.
Geometric Standard Deviation (GSD)
Note that sample statistics are being applied since the 1 (one) has been subtracted from all of the “P”
and “n×P” denominators for the standard deviation calculations.
n = number of years
P = number of periods per year
r = periodic return
V = Value of financial asset (e.g., index or stock price)
ln() = natural log function
exp() = Exponential function
Two example spreadsheets are attached which show how to calculate the Arithmetic and Geometric means and standard deviations for stocks, but these same techniques can be applied to any set of data.
For investments with a maturity horizon of one year or less, then the Arithmetic Mean and Standard Deviation should be used, and these equations can be found on another blog post here:
A PDF of this post can be downloaded by clicking here.
©2017 Ben Etzkorn