PC Review


Reply
Thread Tools Rate Thread

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
View this thread: http://www.excelforum.com/showthread...hreadid=533217

 
Reply With Quote
 
 
 
 
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
> View this thread: http://www.excelforum.com/showthread...hreadid=533217
>



 
Reply With Quote
 
 
 
 
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
> View this thread: http://www.excelforum.com/showthread...hreadid=533217
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel recognizes two different spellings as the same password cmaddox Microsoft Excel Crashes 4 15th Mar 2009 11:26 AM
merge for a mass mailing (Excel)only recognizes first 820 recipien =?Utf-8?B?TGFycnk=?= Microsoft Word Document Management 2 20th Jun 2005 02:58 AM
Re: CD-ROM RECOGNIZES AUDIO BUT NOT SOFTWARE Service Pack Windows XP Help 0 31st Aug 2004 05:42 PM
WinXP only recognizes 2GB on new 160GB drive =?Utf-8?B?ZGFpbG9zaGFuZQ==?= Windows XP Help 1 12th Feb 2004 01:00 PM
Win 2K Pro recognizes single processor MB as dual type Ned Joseph Microsoft Windows 2000 Setup 0 30th Dec 2003 05:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:32 PM.