How do I type this so excel recognizes it?

Discussion in 'Microsoft Excel Worksheet Functions' started by fronty, Apr 16, 2006.

  1. fronty

    fronty Guest

    fronty, Apr 16, 2006
    #1
    1. Advertisements

  2. 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" <> wrote in
    message news:...
    >
    > 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?action=getinfo&userid=33530
    > View this thread: http://www.excelforum.com/showthread.php?threadid=533217
    >
     
    Barb Reinhardt, Apr 16, 2006
    #2
    1. Advertisements

  3. fronty

    Dana DeLouis Guest

    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" <> wrote in
    message news:...
    >
    > 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?action=getinfo&userid=33530
    > View this thread: http://www.excelforum.com/showthread.php?threadid=533217
    >
     
    Dana DeLouis, Apr 16, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeffrey

    Cannot Type Text Into The Excel VBA Help Index

    Jeffrey, Dec 23, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    168
    Jeffrey
    Dec 23, 2003
  2. derek Masten

    Excel Reverse Address type of problem

    derek Masten, Jan 22, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    365
    Chip Pearson
    Jan 22, 2004
  3. Kaushik Roy

    Open Add-In Type File in Microsoft Excel

    Kaushik Roy, Mar 15, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    161
    Charles Williams
    Mar 15, 2004
  4. Jonathan Rynd

    TYPE(B290:B295) in Excel 2000

    Jonathan Rynd, Jul 22, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    8
    Views:
    155
    Jonathan Rynd
    Jul 23, 2004
  5. Guest

    Formula that recognizes duplicates

    Guest, Jun 7, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    7
    Views:
    123
    Guest
    Jun 8, 2005
Loading...

Share This Page