Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. -- fronty ------------------------------------------------------------------------ fronty's Profile: http://www.excelforum.com/member.php...o&userid=33530 View this thread: http://www.excelforum.com/showthread...hreadid=533217 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
type mismatch on saving excel calculation mode via VB app | Excel Discussion (Misc queries) | |||
When I type 100 EXCEL changes it to 10. Why? | Excel Discussion (Misc queries) |