# Combined Pearson/Spearman Correlation Matrix with significance Classic List Threaded 1 message Reply | Threaded
Open this post in threaded view
|

## Combined Pearson/Spearman Correlation Matrix with significance

 This post has NOT been accepted by the mailing list yet. This post was updated on . Dear all, According to the code from the following post in this forum: Combined Pearson/Spearmn Correaltion MatrixI am trying to calculate the combined Pearson and Spearman Correlation matrix. I am using -corr- and -spearman-, which works fine. But with -corr- I cannot get the significance (p-value or stars and so on). So I tried -pwcorr-,-list- which gives me the exact results but with significance. Using this "new combination" I cannot create the matrix as with -corr-. //Get Pearson Matrix corr var1 var2 var3 matrix R = r(C) //Get Row and Column Names local rnames : rownames R local cnames : colnames R //Get Spearman Rank Matrix spearman var1 var2 var3, matrix star(0.05) matrix S = r(Rho) //Convert Pearson Matrix to Mata Matrix mata: mataR = st_matrix("R") //Convert Spearman Rank Matrix to Mata Matrix mata: mataS = st_matrix("S") //Clone Mata Pearson Matrix for Combined mataRS Mata Matrix //Pearsson and Spearman Rank Matrix in Mata mata: mataRS = mataR //Replace Pearson r with Spearman rho in Top Half of Combined mataRS Mata Matrix mata: mataRS[1,2] = mataS[2,1] mata.... and so on. //Display Pearson, Spearman Rank, and combined Matrices in Mata mata: mataR mata: mataS mata: mataRS //Convert combined mataRS Mata Matrix to Stata Matrix RS mata: st_matrix("RS", mataRS) matrix rownames RS = `rnames' matrix colnames RS = `cnames' //Display combined Stata Matrix RS matlist RS, format(%8.4f) When I replace -corr- with -pwcorr-,-list- I get the following error after using: mata: mataRS[1,2] = mataS[2,1] :  3301  subscript invalid" for the command Is there a "smart" way to solve this? (btw, I am working with TeXMaker, so it would be great if the output can be transferred for Latex.) Thank you very much. --