Hi everybody!
I just have a quick question. I have been running crosssectional OLS regressions, and my coefficients are significant (pvalue almost zero) however I realize that I often get strange Rsquared values which are either very close to zero or negative. Is this a problem with Eviews or does that mean that my regressions do not work?
Rsquared
Moderators: EViews Gareth, EViews Moderator

 Nonnormality and collinearity are NOT problems!
 Posts: 3499
 Joined: Wed Sep 17, 2008 2:25 pm
Re: Rsquared
Have you left a constant out of the regression?
Re: Rsquared
Now I tried with a constant but my Rsquared value is 0.000352

 Nonnormality and collinearity are NOT problems!
 Posts: 3499
 Joined: Wed Sep 17, 2008 2:25 pm
Re: Rsquared
There is not necessarily anything wrong, but you might post a screen shot of your output, along with describing what your variables are, to see if anyone has any suggestions.
Re: Rsquared
Thank you very much So I paste one of my regressions. I am just regressing a portfolio's total beta on its return as below. (total portfolio beta=betam1+betam2betam3betam4 and RET=portfolio return)
I'm happy about the positive and significant coefficient but am just worried about the strange Rsquared value. Thanks a lot again!
Dependent Variable: RET?
Method: Pooled Least Squares
Date: 08/03/12 Time: 23:11
Sample: 11 1910
Included observations: 1900
Crosssections included: 8
Total pool (balanced) observations: 15200
Variable Coefficient Std. Error tStatistic Prob.
BETAM1?+BETAM2?BETAM3?BETAM4? 0.034173 0.012899 2.649198 0.0081
Rsquared 0.000345 Mean dependent var 4.81E+09
Adjusted Rsquared 0.000345 S.D. dependent var 4.44E+11
S.E. of regression 4.44E+11 Akaike info criterion 56.47765
Sum squared resid 3.00E+27 Schwarz criterion 56.47815
Log likelihood 429229.1 HannanQuinn criter. 56.47781
DurbinWatson stat 2.001845
I'm happy about the positive and significant coefficient but am just worried about the strange Rsquared value. Thanks a lot again!
Dependent Variable: RET?
Method: Pooled Least Squares
Date: 08/03/12 Time: 23:11
Sample: 11 1910
Included observations: 1900
Crosssections included: 8
Total pool (balanced) observations: 15200
Variable Coefficient Std. Error tStatistic Prob.
BETAM1?+BETAM2?BETAM3?BETAM4? 0.034173 0.012899 2.649198 0.0081
Rsquared 0.000345 Mean dependent var 4.81E+09
Adjusted Rsquared 0.000345 S.D. dependent var 4.44E+11
S.E. of regression 4.44E+11 Akaike info criterion 56.47765
Sum squared resid 3.00E+27 Schwarz criterion 56.47815
Log likelihood 429229.1 HannanQuinn criter. 56.47781
DurbinWatson stat 2.001845

 Nonnormality and collinearity are NOT problems!
 Posts: 3499
 Joined: Wed Sep 17, 2008 2:25 pm
Re: Rsquared
You need to include a constant for this to make sense. If you are still getting a signicant coefficient with a constant included, then everything's probably okay. You have a very large number of observations which is what leads to a low Rsquare with significant tstats.
Re: Rsquared
Now I understand Thank you so much for the clarification! Have a wonderful day!
Selin
Selin
Return to “Econometric Discussions”
Who is online
Users browsing this forum: No registered users and 6 guests