[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