Use of R^2 adjusted in Simple Linear Regression-Excel?

5 replies · 2K views · last reply
Science Advisor
Homework Helper
Messages
7,927
Reaction score
13,242
Hi All,
I am kind of confused at the fact that Excel uses the measurement of adjusted ## R^2 ## for simple
linear regressions ; please see below. What does that even mean, what is the adjustment for?
Screenshot of Excel SUMMARY OUTPUT regression statistics and ANOVA table, with Multiple R 0.944, R Square 0.890, Adjusted R Square 0.889, and Observations 117.000.
 
Did you consult the help file ? Anything there that specifically needs extra explanation ?
 
I think WWGD question is more aimed at what does an adjusted R squared value mean in terms of a simple linear regression as opposed to what it means just in excel. The simple answer is that it means nothing. It's probably just part of the standard output but it should more or less be aligned with the regular r squared value since there isn't an adjustment being made per say. (i.e. as is the case in this example).
 
  • Like
Likes   Reactions: WWGD
I sure hope you are right. I resent people taxiing with 747s when they don't even have a driver's license. And even then there's a risk they inadvertently take off.
 
BvU said:
Did you consult the help file ? Anything there that specifically needs extra explanation ?
Yes, essentially what Marne said: adjusted R-squared, AFAIK, is used in OLS to avoid distortions when additional variables are included. How does this make sense when we only use one variable?
 
  • Like
Likes   Reactions: BvU
MarneMath said:
I think WWGD question is more aimed at what does an adjusted R squared value mean in terms of a simple linear regression as opposed to what it means just in excel. The simple answer is that it means nothing. It's probably just part of the standard output but it should more or less be aligned with the regular r squared value since there isn't an adjustment being made per say. (i.e. as is the case in this example).
Precisely. The adjustment is done for additional variables that are included, AFAIK.