I am using the following code
Code:
reg CAR01 NU_SUE NUE_D1 NUE_D2 logmcap lag_price i.fyearq test NU_SUE NU_SUE test (NU_SUE+NUE_D1) = 0 test (NU_SUE + NUE_D2) = 0 test (NU_SUE + NUE_D1 + NUE_D2) =0 outreg2 using ABC, append excel tstat dec(5)
However, the results of the F-test are not exported to the excel file.
My question is, how can I export the results of F-Test to the excel file?
For example
I want to export the following result to excel ( which is basically the second test)... I want to export the F value of 191.43 and the significance of this value as well to excel the file ABC. Like in the exported file, I should get the value as 191.43***.
test (NU_SUE+NUE_D1) = 0
( 1) NU_SUE + NUE_D1 = 0
F( 1, 51715) = 191.43
Prob > F = 0.0000
P.S: I didn't paste the regression results and data, as they were not required I guess. Please let me know if I am missing anything is explaining my question, I'll explain it.
Any help would be much appreciated, as I have to run these tests a number of times, and copy-pasting the results manually in excel to send to my supervisor takes a lot of time.
Thanks in advance.
0 Response to How to export the results of Wald-test/F-test to excel using outreg2 or any other alternative?
Post a Comment