Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Richard Williams <richardwilliams.ndu@gmail.com> |
| To | statalist@hsphsun2.harvard.edu, statalist <statalist@hsphsun2.harvard.edu> |
| Subject | Re: st: unstandardized and beta coefficients on the same esttab table |
| Date | Mon, 09 Dec 2013 16:07:53 -0500 |
At 01:08 PM 12/9/2013, Paolo Moncagatta wrote:
Thanks a lot Doug, I tried it out but the regression on the standardized variables didn't give me exactly the numbers as the beta coefficients of the original regression. They were close, but not the same...and I cannot figure out what is going on. Anyway, thanks a lot for your time, Paolo
With do it yourself standardization you have to be careful that the same cases are being analyzed. If you are following Doug's example, after the preserve statement try adding
keep if e(sample)The -center- command (available from SSC) with the s and inplace options would be a little simpler. Tweaking Doug's example,
sysuse auto, clear regress mpg weight displacement, beta estimates store original preserve keep if e(sample) center mpg weight displacement, s inplace regress mpg weight displacement estimates store stdized estimates table original stdized estimates restore original restore
On Mon, Dec 9, 2013 at 5:49 PM, Doug Hemken <dehemken@wisc.edu> wrote: > Not without calculating the betas and formatting the output yourself. > > What I have in mind is this: > > > sysuse auto > regress mpg weight displacement > estimates store original > preserve > foreach var of varlist mpg weight displacement { > quietly summarize `var' > replace `var' = (`var' - r(mean))/r(sd) > } > regress mpg weight displacement > estimates store stdized > estimates table original stdized > estimates restore original > restore > > > Doug > > On 12/09/13, Paolo Moncagatta > wrote: >> Thanks Doug, >> >> But is there any way to do this withoout transforming my original data? >> Best regards, >> >> Paolo >> >> On Mon, Dec 9, 2013 at 4:03 AM, Doug Hemken <dehemken@wisc.edu> wrote: >> > (1) run the regression >> > (2) store the results>> > (3) standardize your data, overwriting the variables with the updated values>> > (4) run the revised regression >> > (5) build a table with the old and new results >> >>> > Since they have the same variable names, the results will line up side by side>> > >> > On 12/08/13, Paolo Moncagatta >> > wrote: >> >> Hi there, >> >> >> >> Could anyone give me a tip on how to report both the unstandardized >> >> and the beta coefficients, side by side, on a table using -esttab- or >> >> -estout-? >> >> >> >> Thanks in advance for your time and help! >> >> >> >> Paolo >> >> * >> >> * 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/ >> > >> > -- >> > Doug Hemken >> > 4226I Social Science Bldg. >> > >> > dehemken@wisc.edu >> > 262-4327 >> >>> > To make a consulting appointment send me an email, or use the on-line scheduler: >> > https://calendar.wisc.edu/scheduling-assistant/public/profiles/PlRxCykH.html>> > * >> > * 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/ >> * >> * 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/ > > -- > Doug Hemken > 4226I Social Science Bldg. > > dehemken@wisc.edu > 262-4327 >> To make a consulting appointment send me an email, or use the on-line scheduler: > https://calendar.wisc.edu/scheduling-assistant/public/profiles/PlRxCykH.html> * > * 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/ * * 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/
------------------------------------------- Richard Williams, Notre Dame Dept of Sociology OFFICE: (574)631-6668, (574)631-6463 HOME: (574)289-5227 EMAIL: Richard.A.Williams.5@ND.Edu WWW: http://www.nd.edu/~rwilliam * * 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/