(adsbygoogle = window.adsbygoogle || []).push({}); Different correlation coefficient results between Matlab and Excel. Please Help!!

I have two sets of dat as below. A problem is that matlab and excel returns a different value of correlation coefficient (i.e., 0.801 from Excel and 0.786 from Matlab).

For Matlab, I used the function: corrcoef(DataA, DataB). For excel, I used the function "Correl".

Would you please advise me which one is correct? I found that the excel uses different function from the one used in Matlab. I do not know how to write a function here, so I linked them as below.

http://office.microsoft.com/en-us/excel-help/correl-HP005209023.aspx [Broken]

http://www.mathworks.com.au/help/techdoc/ref/corrcoef.html

Thank you in advance

Data A

0.56

0.63

0.54

0.59

0.57

0.69

Data B

1.16

1.68

1.24

1.33

1.28

1.52

**Physics Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# MATLAB Different correlation coefficient results between Matlab and Excel. Please Help

**Physics Forums | Science Articles, Homework Help, Discussion**