You're right, a quick test of the two functions suggests they give the
same numeric result every time.
Jon Peltier said:
A quick glimpse at Google led me to believe they were one and the same. Just
now Wikipedia tells me:
"The CORREL() function in many major spreadsheet packages, such as Microsoft
Excel and Gnumeric calculates Pearsons correlation coefficient."
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.