Why does Matlab's xcorr function give a different solution than Excel's correl function for some data sets?
显示 更早的评论
For this simple two column data set, with 89 rows, I observed a different solution for the zero lag correlation coefficient in microsoft excel than I found for the zero lag solution value in Matlab using xcorr. The Excel value is 0.709183, whereas the Matlab value is only 0.5889
I used this code in matlab to develop the lag correlation set: [cross,lags] = xcorr(column1,column2,45,'coeff'); stem(lags,cross) The zero lag value for the matlab solution is at lag 46 I believe.
Which solution is correct and why?
回答（1 个）
Stephan
2016-10-20
0 个投票
you need to use the matlab function corrcoef() to get the same result. I tried and they are the same. Good luck.
类别
在 帮助中心 和 File Exchange 中查找有关 Correlation and Convolution 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
