Hi everyone,
I have a problem trying to export my Spearman correlation results into Excel.
I use:
matrix A = r(Rho)
esttab matrix(A, fmt(%5.2f)) using "Results.csv", replace
Using this command I have the correlation table BUT without stars (0.01) + I need only print (0.1) with 4 signs after comma but in Excel I get everything exported with 2 signs.
Is it anyhow possible to get only the needed results exported and with the stars?***
I find the solution only for "correlation" and not for "spearman".
Thank you a lot in advance!
Related Posts with Spearman correlation table export into Excel
Marginsplots for different values of xHello, first post so apologies if something similar has been asked before. I'm investigating the rel…
'End Duplicates' error in mata programing Hello, everyone. I'm Zhang. I would like to ask you a question about an 'End Duplicates' error in …
Testing of adjusted Kaplan-Meier survivalHow to test for adjusted kaplan-meier survival analysis ? I am able to create adjusted KM graph but …
Comparing two probit models with clustered standard errorsHey everyone, I would like to compare two probit models (that are nested) to see whether the additi…
Generating data according to a patternHello list, I am trying to generate data according to the following pattern: Obs A B C ------------…
Subscribe to:
Post Comments (Atom)
0 Response to Spearman correlation table export into Excel
Post a Comment