How to determine geometric mean of 152 values?
 

Excel does not seem to handle such a large number of data points.

How to determine geometric mean of 152 values?
 

"Jerry G" <Jerry wrote in message
...
Excel does not seem to handle such a large number of data points.

What version of Excel?

I tried A1 to A170 and that was my limit in XL 2002 - seemed to work, though
thru A171 gave me the #NUM thing

Beege

How to determine geometric mean of 152 values?
 

=EXP(AVERAGE(LN(A1:A152)))

make sure you use Ctrl + Shift + Enter


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553788