+ Reply to Thread
Results 1 to 3 of 3

How do I type this so excel recognizes it?

  1. #1
    Registered User
    Join Date
    04-15-2006
    Posts
    5

    How do I type this so excel recognizes it?

    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.

  2. #2
    Barb Reinhardt
    Guest

    Re: How do I type this so excel recognizes it?

    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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




  3. #3
    Dana DeLouis
    Guest

    Re: How do I type this so excel recognizes it?

    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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1