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
Chow test of Structural BreakDear Statalist members, Can Chow test be performed on panel data with only one variable? I would li…
Two questions about marginal effects (xtreg)Hello! I want to evaluate how sales of a specific product change as its price increases (due to a t…
Create rank depending on 2 variablesHey Stata Community! I have a question concerning generating a new variable. My dataset looks like…
tfdiff error messageHi everyone, I am having an issue with the command tfdiff. My data is more or less as follow: nu…
Steady state for ARIMA modelsHi, I need to test the hypothesis that fixed effects in my model do not correlate with deviations f…
Subscribe to:
Post Comments (Atom)
0 Response to Spearman correlation table export into Excel
Post a Comment