You have stated a truth; the correlation coefficient must exist between
-1.o and 1.0, OTHERWISE, there is something wrong with either the data
or the calculation. I would look at the data to be sue it was properly
displayed. I know this doesn't give you an exact answer to your math,
but it does reinforce your initial belief. George F.
--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile:
http://www.excelforum.com/member.php...o&userid=24124
View this thread:
http://www.excelforum.com/showthread...hreadid=391059