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

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 …

Jun 30, 2009 · Hey, I'm trying to use teh =GEOMEAN() function to find the geometric mean of a set of numbers. My numbers are in percentages, and some of them are negative (they …

Nov 4, 2009 · I have a data set of 11,000 numbers with no more than 2 digits per number. I have to get the geometric mean but excel 2010 limits to 5.0748E+307 (or roughly...

Nov 8, 2010 · You cannot calculate a geometric mean with data that includes 0. Maybe this array entered formula =GEOMEAN (IF (G135:G165<>0,G135:G165)) confirmed with CTRL + Shift + …

Feb 25, 2005 · Andrew Poulsom MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Feb 7, 2008 #2 If your data is in A1:H1, in another cell enter: =GEOMEAN (1+A1:H1)-1 and press …

Oct 23, 2006 · AhoyNC Well-known Member Joined Oct 10, 2011 Messages 5,615 Office Version 365 Platform Windows Jul 20, 2022 #2 When I use your example I get 2.078425, not 3.82 See …

Feb 17, 2002 · Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with …

Jun 23, 2010 · The geometric mean will accommodate negative returns. You can calculate the average more simply using the first and last values, e.g. if 100 increases to 120 over 5 …

Aug 10, 2014 · Hi, I am trying to find the geometric mean of a range of values based on another range of data and if that falls into a certain bin width. So for example, finding the geometric …