Excel 2008—What’s the Difference between the CORREL and PEARSON Functions?

[Ed]

Both the CORREL and PEARSON functions give me the same answer as when
I calculate a Pearson’s coefficient of correlation, or r, by hand. So
what’d the difference between these two functions?

Ed

 

[CyberTaz]

I have no idea Ed - Stats ain't my strong suit But perhaps the
definitions in Excel Help with provide the distinction:

http://office.microsoft.com/client/...ns=EXCEL&lcid=1033&QueryID=hYOFAs5pU&respos=1

http://office.microsoft.com/client/...s=EXCEL&lcid=1033&QueryID=mYOFyXnUD0&respos=1

--
HTH |:>)
Bob Jones
Office:Mac MVP

Both the CORREL and PEARSON functions give me the same answer as when
I calculate a Pearson’s coefficient of correlation, or r, by hand. So
what’d the difference between these two functions?

Ed