Export ttest and ANOVA Results to Excel

[Caroline Hoch]

I need help coding export of ttest and ANOVA results to Excel. For correlation, I ran the following:

putexcel set "file.xlsx", sheet(RQ1.2, replace) modify
pwcorr v1 v2, sig star(.05)
putexcel A1 = matrix(r(C)), names

How do I use the putexcel command for ttest and ANOVA results? Thanks!

[Andrew Musau]

See https://www.stata.com/manuals/tablesexample4.pdf and https://www.stata.com/manuals/rtableregression.pdf on using collect to retrieve the results, then export as an Excel file using collect export.

help collect export