- #1

honeysyd

- 3

- 0

**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

Last edited by a moderator: