# How do I type this so excel recognizes it?

fronty
Guest
Posts: n/a

 16th Apr 2006

I need to calculate the geometric average of returns on stocks.

I looked at the definition of geomean and it will not work for me. I
need to use this formula.

Rgeo={[(1+R1)(1+R2)....(1+Rn)]}^(1/n) -1

Any help would be greatly appreciated.

--
fronty
------------------------------------------------------------------------
fronty's Profile: http://www.excelforum.com/member.php...o&userid=33530

Barb Reinhardt
Guest
Posts: n/a

 16th Apr 2006
Add a helper column to calculate 1 + R1, 1+ R2, ETC.

Let's say that your data is in R1, R2, R3 to R10 for this example.
Create Q1-Q10
Q1:R1+1
Copy to Q10

Q11: =product(Q1:Q10)^(1/10)-1

"fronty" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I need to calculate the geometric average of returns on stocks.
>
> I looked at the definition of geomean and it will not work for me. I
> need to use this formula.
>
> Rgeo={[(1+R1)(1+R2)....(1+Rn)]}^(1/n) -1
>
> Any help would be greatly appreciated.
>
>
> --
> fronty
> ------------------------------------------------------------------------
> fronty's Profile:
> http://www.excelforum.com/member.php...o&userid=33530
>

Dana DeLouis
Guest
Posts: n/a

 16th Apr 2006
Hi. If v represents the Range A1:A10, then the following two Array Formulas
appear to work ok.

=POWER(PRODUCT(v+1),1/10)-1

=GEOMEAN(v+1)-1

Enter w/ Ctrl+Shift+Enter.
--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003

"fronty" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I need to calculate the geometric average of returns on stocks.
>
> I looked at the definition of geomean and it will not work for me. I
> need to use this formula.
>
> Rgeo={[(1+R1)(1+R2)....(1+Rn)]}^(1/n) -1
>
> Any help would be greatly appreciated.
>
>
> --
> fronty
> ------------------------------------------------------------------------
> fronty's Profile:
> http://www.excelforum.com/member.php...o&userid=33530
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post cmaddox Microsoft Excel Crashes 4 15th Mar 2009 11:26 AM =?Utf-8?B?TGFycnk=?= Microsoft Word Document Management 2 20th Jun 2005 02:58 AM Service Pack Windows XP Help 0 31st Aug 2004 05:42 PM =?Utf-8?B?ZGFpbG9zaGFuZQ==?= Windows XP Help 1 12th Feb 2004 01:00 PM Ned Joseph Microsoft Windows 2000 Setup 0 30th Dec 2003 05:36 AM

Features