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
Fuzzy RDD with possible BootstrapDear all, I have a question and I would like to ask for advice. I am trying to evaluate the impact …
SchemesI have just upgraded from 15 to 16. Is there any way to import my schemes from 15 without having to …
Keep last 4 digits of a numeric variableHi everyone, I would like to ask you how can I keep the last 4 digits of the variable date. It is a …
how do you drop all data not equal to two values in a columnI know I can use the drop and keep functions to clean my data, but what happens if I have a column a…
OLS regression where one independent variable is a rare eventHello all, I am performance ols regression, something like: regress y i.x1##i.x2 x3 x4 x5, cluster…
Subscribe to:
Post Comments (Atom)
0 Response to Spearman correlation table export into Excel
Post a Comment