Nice t-test output tables

[Kuno Mafis]

Hi guys,

I would like to get the results for my t-test as a nice word-file output. What's the best way to do that?
These outreg2 and esttab commands are not working properly. I'm only getting empty pages or empty tables.


Any advice is appreciated

[Rich Goldstein]

you might want to look at part 4 of Chuck Huber's 7 part blog series on the version 17 -table- command: https://blog.stata.com/2021/08/24/cu...istical-tests/

[William Lisowski]

You may find the community contributed asdoc command helpful. Use the following Stata commands to install it and review the documentation.

net install asdoc, from(http://fintechprofessor.com)
help asdoc

[Kuno Mafis]

You may find the community contributed asdoc command helpful. Use the following Stata commands to install it and review the documentation.

net install asdoc, from(http://fintechprofessor.com)
help asdoc

Thanks,
I tried it, but unfortunately it also doesn't work well. I'm getting several different errors.
While using the provided data, the specific command works but my word-file again is empty, there is just a headline.
And when I try the same command with my data, it doesn't even work.

[William Lisowski]

With no example of the code you ran and the errors Stata reported in the Results window, it's impossible to tell you how to change your code.

It works for me. This is based on the first example from the documentation.

clear all
cls
sysuse auto, clear
asdoc ttest rep78==0, title(T-test results : mean == 0)  save(~/Downloads/report.doc) replace
asdoc ttest price==0, rowappend save(~/Downloads/report.doc) append
asdoc ttest mpg==0, rowappend save(~/Downloads/report.doc) append
asdoc ttest turn==0, rowappend save(~/Downloads/report.doc) append
asdoc ttest weight==0, rowappend save(~/Downloads/report.doc) append

. sysuse auto, clear
(1978 automobile data)

. asdoc ttest rep78==0, title(T-test results : mean == 0)  save(~/Downloads/report.doc) replace

                    T-test results : mean == 0

-------------------------------------------------------------------------
                 |       obs       Mean     St_Err    t_value    p_value
-----------------+-------------------------------------------------------
           rep78 |        69      3.406       .119    28.5785          0
-------------------------------------------------------------------------
(file ~/Downloads/report.doc not found)
  0.119
Click to Open File:  ~/Downloads/report.doc

. asdoc ttest price==0, rowappend save(~/Downloads/report.doc) append

                    One-sample t test for price

-------------------------------------------------------------------------
                 |       obs       Mean     St_Err    t_value    p_value
-----------------+-------------------------------------------------------
           price |        74   6165.257    342.872     17.981          0
-------------------------------------------------------------------------
  342.872
Click to Open File:  ~/Downloads/report.doc

. asdoc ttest mpg==0, rowappend save(~/Downloads/report.doc) append

                    One-sample t test for mpg

-------------------------------------------------------------------------
                 |       obs       Mean     St_Err    t_value    p_value
-----------------+-------------------------------------------------------
             mpg |        74    21.2975      .6725    31.6665          0
-------------------------------------------------------------------------
  0.672
Click to Open File:  ~/Downloads/report.doc

. asdoc ttest turn==0, rowappend save(~/Downloads/report.doc) append

                    One-sample t test for turn

-------------------------------------------------------------------------
                 |       obs       Mean     St_Err    t_value    p_value
-----------------+-------------------------------------------------------
            turn |        74    39.6485      .5115    77.5275          0
-------------------------------------------------------------------------
  0.512
Click to Open File:  ~/Downloads/report.doc

. asdoc ttest weight==0, rowappend save(~/Downloads/report.doc) append

                    One-sample t test for weight

-------------------------------------------------------------------------
                 |       obs       Mean     St_Err    t_value    p_value
-----------------+-------------------------------------------------------
          weight |        74   3019.459     90.347    33.4205          0
-------------------------------------------------------------------------
  90.347
Click to Open File:  ~/Downloads/report.doc

.

[Kuno Mafis]

You're right, sorry.
But what I mean is rather somethign like this here.

I'm getting closer to it with the esttab command but I'm not yet where I want to be.

[Attaullah Shah]

What you are asking for is comprehensively covered in the table1 template of asdocx. See this post for details https://fintechprofessor.com/asdocx/...tients-asdocx/

[Rich Goldstein]

take a look at part 4 of Chuck Huber's series of blogs on the -table- command: https://blog.stata.com/2021/08/24/cu...istical-tests/