View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default how i calculate pearson correlation coefficient for excel graph

Hello, Jon!
You wrote on Sun, 17 Sep 2006 00:28:59 -0400:

JP "The CORREL() function in many major spreadsheet packages,
JP such as Microsoft Excel and Gnumeric calculates Pearsons
JP correlation coefficient."

JP Wolfram adds that:

JP "The correlation coefficient is also known as the
JP product-moment coefficient of correlation or Pearson's
JP correlation."

JP I wouldn't count on the Excel help files to be much help,
JP especially about statistics.

It is interesting that the Help entries for PEARSON and CORREL
look confusingly different. Rather than analyse the equations, I
calculated PEARSON and CORREL for several sets of data with
identical numerical results :-)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not