Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula for geometric mean with some negative data
The only formula they give is for positive data. I am trying to calculate the
geometric mean of returns for different portfolios with some negative data. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula for geometric mean with some negative data
On Fri, 20 Jan 2006 13:27:02 -0800, "jett"
wrote: The only formula they give is for positive data. I am trying to calculate the geometric mean of returns for different portfolios with some negative data. Probably you should "convert" everything to positive numbers by adding one (1) to all the percentage returns; then subtract one (1) from your result. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |