How to calculate the value of correlation coefficient r using Spearman correlation coefficient test?

Question

Muhammad shahid 2017-12-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371382-how-to-calculate-the-value-of-correlation-coefficient-r-using-spearman-correlation-coefficient-test

回答： Muhammad shahid 2017-12-7

A.xls

HI, For attached rainfall data sheet A.Xls I want to calculate the value of correlation coefficient "r" by using Spearman correlation coefficient test. Can some one help me to calculate it in mat-lab. Moreover kindly guide me how to interpret the value of r for strong, week and negligible correlation.

2 个评论
显示无隐藏无

Muhammad shahid 2017-12-6

Dear jean claude I have two variables in the attached sheet Year and rainfall I should consider them as X and Y? and RHO here represent the value of r?

jean claude 2017-12-6

yes that's your variables x and y , then rho is your coefficient r you're welcome!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

jean claude 2017-12-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371382-how-to-calculate-the-value-of-correlation-coefficient-r-using-spearman-correlation-coefficient-test#answer_294958

在 MATLAB Online 中打开

if you have the statistics toolbox you can use

[RHO,PVAL] = corr(x,y,'type','Spearman')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Muhammad shahid 2017-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371382-how-to-calculate-the-value-of-correlation-coefficient-r-using-spearman-correlation-coefficient-test#answer_295099

Dear jean claude I have developed this code for data in one column. I wan to perform this on many columns like for attached data set "B.xls" hOW I Would have to modify this code?

data = xlsread('V'); [nrows, ncolumns] = size(data); for i = 1:ncolumns X = data(1:nrows-1); Y = data(2:nrows); [RHO,PVAL] = corr(X,Y,'type','Spearman'); end