Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Inconsistent stars and p-values exported using xml_tab
From
"Tsankova, Teodora" <[email protected]>
To
<[email protected]>
Subject
st: Inconsistent stars and p-values exported using xml_tab
Date
Mon, 19 Aug 2013 13:34:37 +0100
Dear Statalist -
I have encountered a problem with xml_tab initially pointed out by
http://www.stata.com/statalist/archive/2013-06/msg00637.html
I am using a simple reg command and regardless of the standard errors reported I get different p-values in my excel output than the ones reported in the command window.
I use the following commands:
eststo Foreign_1: reg gtloans_yoy parent_else $bankvars_c $parvars_c regional_exposure ccode_* if year==2009, robust
/*
Linear regression Number of obs = 94
F( 23, 70) = 1.85
Prob > F = 0.0262
R-squared = 0.3803
Root MSE = 16.282
Robust
gtloans_yoy Coef. Std. Err. t P>t [95% Conf. Interval]
parent_else 7.761223 5.344712 1.45 0.151 -2.898469 18.42092
pre_crisis_growth -.1139003 .1009452 -1.13 0.263 -.3152291 .0874285
roae .0475998 .1807119 0.26 0.793 -.3128187 .4080184
logta 2.884664 1.741943 1.66 0.102 -.5895319 6.35886
nlcf .0538845 .0231177 2.33 0.023 .0077777 .0999913
eqnl .1858825 .1585593 1.17 0.245 -.1303541 .5021191
lacf -.2763895 .1203949 -2.30 0.025 -.5165096 -.0362695
llrgl .4656151 .9475554 0.49 0.625 -1.424225 2.355455
pb_ReturnonAvgAss -1.084579 .6514647 -1.66 0.100 -2.383885 .2147259
log_pb_TotalAssets .0213451 1.353194 0.02 0.987 -2.677515 2.720205
pb_EquityNetLoans -.7124961 .3161895 -2.25 0.027 -1.343116 -.0818759
parent_gdp_yoy 1.398121 .8266898 1.69 0.095 -.2506596 3.046902
regional_exposure -.0507246 .6319286 -0.08 0.936 -1.311066 1.209617
*/
xml_tab _all using Table_3_cs.xls, append sheet("2011 N-VC") pvalue star(* 0.1 ** 0.05 *** 0.01) stats(N r2) nol b
eststo clear
The excel output file begins with:
parent_else
7.761
0.146)
pre_crisis_growth
-0.114
(0.259)
The p-values are clearly different in the two outputs. Stars exported are also not the same as the p-values shown in the output window would suggest.
Any ideas on what I am doing wrong or which statistics are in fact exported are welcome.
Thank you,
Teodora
______________________________________________________________
This message may contain privileged information. If you have received this message by mistake, please keep it confidential and return it to the sender.
Although we have taken steps to minimise the risk of transmitting software viruses, the EBRD accepts no liability for any loss or damage caused by computer viruses and would advise you to carry out your own virus checks.
The contents of this e-mail do not necessarily represent the views of the EBRD.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/