View Single Post
  #5   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

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.