[Limdep Nlogit List] problem exporting results into Excel

Alberto M Zanni amz at albertomzanni.com
Wed Jul 1 00:04:27 AEST 2020


Dear all,

I have been struggling a bit while exporting results to excel (I am using NLogit version 5). This is a simple case 

my command
open; export="C:\Users\abzn\Documents\Alberto\DLP\resultsMNL11.csv" $
nlogit;
 lhs=choice;
 choices=A1,A2,A3;
 rhs=gcov, flower, tcov, isl_mid, isl_wide, bl_div,bl_slow, p_island, lane, tax, sq;
 export $

The results from the output below are different from those in the Excel table produced by the command above as the confidence interval values are inserted as cofficients of the next variable and so on...

I found a previous message reporting this but could not find the reply as well. Am I doing anything wrong? is there a way to resolve this? or do you know of a quicker trick to copy results into excel? 

thank you very much
Alberto

--------+--------------------------------------------------------------------
 | Standard Prob. 95% Confidence
 CHOICE| Coefficient Error z |z|>Z* Interval
--------+--------------------------------------------------------------------
 GCOV| .01168*** .00266 4.40 .0000 .00647 .01688
 FLOWER| .10408 .14518 .72 .4734 -.18047 .38862
 TCOV| .00444 .00274 1.62 .1054 -.00093 .00981
ISL_MID| -.28088* .16282 -1.73 .0845 -.59999 .03824
ISL_WIDE| -.17648 .15446 -1.14 .2532 -.47921 .12625
 BL_DIV| .25986** .12975 2.00 .0452 .00555 .51417
BL_SLOW| .01951 .12755 .15 .8785 -.23049 .26950
P_ISLAND| .11702 .09473 1.24 .2167 -.06866 .30270
 LANE| -.12308** .05929 -2.08 .0379 -.23929 -.00687
 TAX| -.00014*** .2962D-04 -4.69 .0000 -.00020 -.00008
 SQ| -1.69585*** .31846 -5.33 .0000 -2.32002 -1.07169
--------+--------------------------------------------------------------------
Note: nnnnn.D-xx or D+xx => multiply by 10 to -xx or +xx.
Note: ***, **, * ==> Significance at 1%, 5%, 10% level.
-----------------------------------------------------------------------------
Last Model Estimation Results                                                   




Variable
Coeff.  
Std.Err.
t-ratio 
P-value 
GCOV    
1.17E-02
2.66E-03
4.39608
1.10E-05
FLOWER  
6.47E-03
1.69E-02
0.104077
0.145178
TCOV    
0.716888
0.473443
-0.18047
0.388621
ISL_MID 
4.44E-03
2.74E-03
1.61915
0.105416
ISL_WIDE
-9.34E-04
9.81E-03
-0.28088
0.162818
BL_DIV  
-1.72509
8.45E-02
-0.59999
3.82E-02
BL_SLOW 
-0.17648
0.154456
-1.14258
0.253214
P_ISLAND
-0.47921
0.12625
0.25986
0.129754
LANE    
2.00271
4.52E-02
5.55E-03
0.514174
TAX     
1.95E-02
0.127552
0.152926
0.878457
SQ      
-0.23049
0.269504
0.117019
9.47E-02


More information about the Limdep mailing list