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
Calculating 95% CI for a chi square analysis?If I'm looking for how a category "treatment type" affects category "diagnosis" in a 2x2 chi square …
Using mysuest to compare coefficients from different imputationsHello everyone, I require some assistance with regard to using mysuest for the sake of comparing co…
how to export stata result to excel using table and tabstat command Sex usual_residence registered_place income_1 income_2 Male New York Washington Dc 2000 2112 …
putexcel with dates as row namesDear All, I'm trying to compute some statistics of my sample dataset. In particular I'm interested …
Reshaping data long to wide(NSS, 64th round)Hi, The data I am detailing with pertains to the household and individual-level data from the Natio…
Subscribe to:
Post Comments (Atom)
0 Response to Spearman correlation table export into Excel
Post a Comment