Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: unstandardized and beta coefficients on the same esttab table


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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index