Good morning, first I apologize for my elementary post. I have been working with asdoc and asdocx for only a short time and this is my first post.

I want to create a table for several variable i.e. Face Value, Spread, Monthly Return, Effec Bid-ask, where I report the mean (for Fannie Mae in one col), mean for Freddie Mac in one col, the unequal t-test value, the p-value for that test, the wilcox rank sum, and the results from the median test. showing the p-values and significance *****. I didn’t see an upload option so I will show you what I would like the output to look like.

Variable Fannie Freddie t-test t-test Wilcox Rank Sum Median Test

Mean Mean t-stat p-value p-value p-value

FaceValue

spread

Bond Maturity

Monthly Return

Rolls Liquidity

MBS Index

If possible add significance ***

I was able to generate the t-test portion, however the output didn’t group by issuer it showed Fannie count, Freddie Count, Fannie Mean, Freddie Mean, difference, st. error, t-value, p-value. How can I reformat the output and add the Wilcox Rank sum and the Median tests, the non-parametric tests.

thanks