What is the formula for geometric mean with some negative data

J

jett

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Geometric Standard Deviation 11
I need to calculate a Geometric mean 7
geometric mean of a series of negative asset returns 8
Cumulative formula for word table 0
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
SUMIF with broken range 10
what is geometric mean or return 2
Dealing with the error: unable to filter on excel hc home school 0

Top