On Fri, 15 Sep 2006, in microsoft.public.excel.charting,
Jon Peltier said:
In a cell in the worksheet, enter this formula
=CORREL({y range},{x range})
Shouldn't that be =PEARSON({y range},{x range})? I only have Excel 97,
but I'm surprised to see that PEARSON() and CORREL() do not have a
pointer to each other in the "See also" section of the help file.
--
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.