May 31, 2007 · I am trying to work out how to calculate the geometric mean of a series of values, some of which are negative, ie. investment returns over a series of years with some negatives. …

May 15, 2015 · The first step to taking the geometric mean of a data set that includes negative numbers will be to define what is meant (mathematically) by geometric mean when negative …

Jun 16, 2014 · Calculating Geometric Mean in a Pivot Table Greetings, I have a very large database that I am trying to perform some calculation on using Excel. I need to calculate …

Feb 18, 2008 · Please help to find a single formula to calculate negative and positive stream of returns. The problem is that =geomean formula does not work with negative numbers. Here's …

Jun 30, 2009 · You usually use the geometric mean to calculate an average of a compounded rate of return and the formula is: =GEOMEAN (1+A1:AN)-1 confirm with Control-Shift-Enter …

Jan 20, 2006 · 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.

Sep 6, 2013 · The Excel GEOMEAN function only accepts non-negative numbers, so you need to use the return factor in that function to calculate the average annual return. Here's an example …

Jul 13, 2015 · Equivalent to AVERAGEIF for GEOMEAN Hi all Is there a function in Excel which is equivalent to AVERAGEIF but calculates the geometric mean rather than the arithmetic …

Feb 25, 2005 · I have the following annual returns on an investment and would like to calculate the compund annual return. How can I do this without actually doing the multiplication to find …

Nov 8, 2010 · I have Excel 2007. I am using geomean to calculate monthly fecal-e. coli values at a waste water treatment plant. The sample frequency is 1-2 samples weekly. There 8 samples in …