Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index