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

# RE: st: RE: Why Do I get Different Results in Stata and Spss?

 From DE SOUZA Eric To "'statalist@hsphsun2.harvard.edu'" Subject RE: st: RE: Why Do I get Different Results in Stata and Spss? Date Mon, 7 Apr 2014 13:51:43 +0200

```Mark,
Yuval is aware of this as is clear from his reply to my post. I did not notice that he had no degrees of freedom left.

His question is why he gets different results in Stata and in SPSS. But I don't see what he gets in SPSS anywhere. So it is not possible to answer his question.

Eric de Souza
College of Europe
Brugge (Bruges), Belgium
http://www.coleurope.eu

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Schaffer, Mark E
Sent: 07 April 2014 13:31
To: statalist@hsphsun2.harvard.edu
Subject: RE: st: RE: Why Do I get Different Results in Stata and Spss?

Yuval,

Maybe I'm missing something, but 18 variables + the constant = 19, hence the 100% R-sq.

--Mark

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Yuval Arbel
> Sent: 07 April 2014 12:24
> To: statalist
> Subject: Re: st: RE: Why Do I get Different Results in Stata and Spss?
>
> Eric, thanks for your answer. As I implied in my original e-mail there
> are 19 observations and 18 variables. In my original e-mail I called
> this problem degrees of freedom problem: if you had 19 obs. and 19
> coefficients R-square would become 100%, because you get 19 equations
> with 19 unknowns (and with a single vector of solutions.
>
> The question is does this problem might cause different results in
> different statistical softwares
>
> On Mon, Apr 7, 2014 at 12:33 PM, DE SOUZA Eric
> <eric.de_souza@coleurope.eu> wrote:
> > The R2 = 1 and the residual sum of squares = 0 says everything: you
> > have
> the same variable (or linear  combination of variables) on the left
> and right hand side of the equation.
> >
> >
> > Eric de Souza
> > College of Europe
> > Brugge (Bruges), Belgium
> > http://www.coleurope.eu
> >
> >
> >
> > -----Original Message-----
> > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Yuval Arbel
> > Sent: 06 April 2014 15:07
> > To: statalist
> > Subject: st: Why Do I get Different Results in Stata and Spss?
> >
> > Dear Statalisters,
> >
> > I ran the following model in stata and spss and got different results.
> > Obviously, there are degrees-of-freedom problem in this dataset, but
> > I
> wonder whether this is the reason I got very different results.
> >
> > Here is the output:
> >
> > . reg close_avg_after1 close_avg_before tal100_before equity_return
> leverage inventory_cycle costumers_cycle suppliers_cycle gor
> >> ss_profit_per liquidity working_capital cash_flowoversales
> >> rate_ofnetprofit valuestock equityvsbalance equitymultiplier ratioo
> >> fshorttermloanslongterm interestcoverageratio rateofsalesexpenses
> >
> >       Source |       SS       df       MS              Number of obs =      19
> > -------------+------------------------------           F( 18,     0) =       .
> >        Model |  1999905.68    18  111105.871           Prob > F      =       .
> >     Residual |           0     0           .           R-squared     =  1.0000
> > -------------+------------------------------           Adj R-squared =       .
> >        Total |  1999905.68    18  111105.871           Root MSE      =       0
> >
> > --------------------------------------------------------------------
> > -----------------------
> ----
> >              close_avg_after1 |      Coef.   Std. Err.      t    P>|t|
> >     [95% Conf. Interval]
> > ------------------------------+-------------------------------------
> > ------------------------------+----
> > ------------------------------+-----------------------
> >              close_avg_before |   2.185104          .        .       .
> >            .           .
> >                 tal100_before |  -6.284746          .        .       .
> >            .           .
> >                 equity_return |  -.0717535          .        .       .
> >            .           .
> >                      leverage |  -83.99337          .        .       .
> >            .           .
> >               inventory_cycle |  -1.484844          .        .       .
> >            .           .
> >               costumers_cycle |    4.74203          .        .       .
> >            .           .
> >               suppliers_cycle |  -1.866507          .        .       .
> >            .           .
> >              gorss_profit_per |  -10306.54          .        .       .
> >            .           .
> >                     liquidity |   5696.688          .        .       .
> >            .           .
> >               working_capital |   4.95e-07          .        .       .
> >            .           .
> >            cash_flowoversales |  -4959.692          .        .       .
> >            .           .
> >              rate_ofnetprofit |  -473.2787          .        .       .
> >            .           .
> >                    valuestock |   85.21832          .        .       .
> >            .           .
> >               equityvsbalance |  -3335.051          .        .       .
> >            .           .
> >              equitymultiplier |   6.059973          .        .       .
> >            .           .
> > ratioofshorttermloanslongterm |  -6718.584          .        .       .
> >            .           .
> >         interestcoverageratio |  -3.395753          .        .       .
> >            .           .
> >           rateofsalesexpenses |  -1193.081          .        .       .
> >            .           .
> >                         _cons |   13705.22          .        .       .
> >            .           .
> > --------------------------------------------------------------------
> > -----------------------
> ----
> >
> >
> > --
> > Dr. Yuval Arbel
> > 4 Shaar Palmer Street,
> > Haifa 33031, Israel
> > e-mail1: yuval.arbel@carmel.ac.il
> > e-mail2: yuval.arbel@gmail.com
> > You can access my latest IZA discussion paper at
> http://ftp.iza.org/dp7946.pdf You can access my latest paper on SSRN at:
> http://ssrn.com/abstract=2263398 You can access previous papers on
> SSRN
> at: http://ssrn.com/author=1313670
> > *
> > *   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/
>
>
>
> --
> Dr. Yuval Arbel
> 4 Shaar Palmer Street,
> Haifa 33031, Israel
> e-mail1: yuval.arbel@carmel.ac.il
> e-mail2: yuval.arbel@gmail.com
> You can access my latest IZA discussion paper at
> http://ftp.iza.org/dp7946.pdf You can access my latest paper on SSRN
> at:
> http://ssrn.com/abstract=2263398
> You can access previous papers on SSRN at:
> http://ssrn.com/author=1313670
> *
> *   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/

-----
Sunday Times Scottish University of the Year 2011-2013 Top in the UK for student experience Fourth university in the UK and top in Scotland (National Student Survey 2012)

We invite research leaders and ambitious early career researchers to
to apply.

Heriot-Watt University is a Scottish charity
registered under charity number SC000278.

*
*   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/
```