View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default how i calculate pearson correlation coefficient for excel graph

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.