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

  • Context: Undergrad 
  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Linear Regression
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
5 replies · 2K views
Messages
7,830
Reaction score
13,158
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?
upload_2017-2-23_18-57-9.png
 
Physics news on Phys.org
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.