On Sep 30, 1:29 pm, "Dana DeLouis" wrote:
Hi. Suppose your first three data values are in A1:A3.
In B3, enter this array formula:
=GEOMEAN($A$1:A3+1)-1 (Ctrl+Shift+Enter)

I'm not sure, but I think someone pointed out a flaw with GEOMEAN not
too long ago. If my recollection is correct, it is more reliable to
compute the geometric mean with the following array formula (ctrl-
shift-Enter):

=exp(average(ln(1+$A$1:A3))) - 1

I like that formula for another reason: it is easy to modify it to
compute the "geometric std dev" -- simply replace "average" with
"stdev".

In any case, as I pointed out to the OP, that computes the average
__quarterly__ rate of return, not the __annualized__ rate of return
that the OP thought he/she was computing. So everything here needs to
be annualized, to wit:

=geomean(1+$A$1:A3)^4 - 1

=exp(4*average(ln(1+$A$1:A3))) - 1