outreg2 with incorrect asterisk in excel

[Jae Li]

Hi Statalists,

I find an issue with outreg2 for exporting regression results out to the excel, that is they seem to put the incorrect asterisk next to the regression coefficients based on the statistical significance levels. For example, the coefficient is -.0.121 with a t-statistic of 1.69. It's supposed to be one asterisk next to the coefficient because the t-statistic value for the statistical significance at 10% is 1.65. However, when I use outreg2 to export it to excel, there is no asterisk next to the coefficient, and such cases happened a few times during the work, either without an asterisk or less an asterisk than it is supposed to be.

Does anyone possibly know why is it? Many thanks for your time and help in advance!

[Phil Bromiley]

You didn't get a quick answer. You'll increase your chances of a useful answer by following the FAQ on asking questions - provide Stata code in code delimiters, readable Stata output, and sample data using dataex (which you do). Note also that most of us are not from your area - you'll increase your chances of a useful answer by explaining in general terms.

Never seen this problem, but I usually use outreg2 to export to word. You might want to check your options on stars.

[Jae Li]

@Phil Bromiley Hi Phil, thank you for your prompt reply!

Here is my code for outreg2:

outreg2 using data.xls, excel  keep (inv new MTB lev cash size) sortvar(inv new MTB lev cash size ) tstat tdec(2) bdec(3) ctitle(`dep')  bracket

Do you mean I shall specify it in the option?

 alpha(0.01, 0.05, 0.1)

Many thanks for your help in advance!