As Nick says, calculations that can be done in Excel can usually be done in Stata. However, if Philomena wants the results to be in a spreadsheet-like format, with 1 observation per estimated parameter and data on estimates, confidence intervals, P-values, and other parameter attributes, then a possible solution is to use the -parmest- package, downloadable from SSC (for Stata 11 users) or from my website (for users of earlier Stata versions). The -parmest- package creates Stata output datasets (or resultssets) with 1 observation per estimated parameter, and data on the estimates, confidence limits, P-values, and many other parameter attributes. In default, these results are in double precision, although the user may specify the -float- option to make them single-precision and save space.
Alternatively, Philomena may prefer to use the e() results directly. For more detauls on these, type
help ereturn
in Stata.
I hope this helps.
Best wishes
Roger
Roger B Newson BSc MSc DPhil
Lecturer in Medical Statistics
Respiratory Epidemiology and Public Health Group
National Heart and Lung Institute
Imperial College London
Royal Brompton Campus
Room 33, Emmanuel Kaye Building
1B Manresa Road
London SW3 6LR
UNITED KINGDOM
Tel: +44 (0)20 7352 8121 ext 3381
Fax: +44 (0)20 7351 8322
Email: [email protected]
Web page: http://www.imperial.ac.uk/nhli/r.newson/
Departmental Web page:
http://www1.imperial.ac.uk/medicine/about/divisions/nhli/respiration/popgenetics/reph/
Opinions expressed are those of the author, not of the institution.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
Sent: 20 October 2009 11:12
To: [email protected]
Subject: st: RE: how to access e(b) and e(V)
I imagine that StataCorp developers would very much like to hear of any
calculation that can be done easily in Excel, which I understand to be a
spreadsheet application, but not in Stata.
Nick
[email protected]
[email protected]
I would like to export the coefficient matrix and the variance
covariance matrix into excel to do some calculations-i need very exact
values, so i can't use the output. Where does Stata store these matrices
and how can I access them?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
