Reporting t-test and Wilcoxon sign rank

[Stijn Groeningen]

Dear all,

I am trying to generate a table which displays means and median of certain variables by category in the following way:

bys targetadvisor: outreg2 using TargetSummary, replace sum(log) excel dec(3) eqkeep(N mean p50)

Where targetadvisor takes three levels for the quality level of each advisor.
I want to include p-values for a t-test of each value of the mean and a Wilcoxon sign rank test on the medians. Is there an easy way to construct a table containing these values? The outputs would look something like this:
https://drive.google.com/file/d/1Izu...ew?usp=sharing

I am sorry for the google link, for some reason the file would not upload.

Thanks!
Stijn

[Rich Goldstein]

I am not a user of -outreg2- so can't help with that

however, I do note that the sign rank test (do you mean -ranksum-?) is not a test of medians; see example 2 in

https://en.wikipedia.org/wiki/Mann%E...Whitney_U_test

[Stijn Groeningen]

Hi Rich,

I mean the Wilcoxon Signed Rank test, I am told it is possible to use it to test whether a sample median is significantly different from zero.
https://en.wikipedia.org/wiki/Wilcoxon_signed-rank_test