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

[WWGD]

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?

 

[BvU]

Did you consult the help file ? Anything there that specifically needs extra explanation ?

 

[MarneMath]

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).

 

[BvU]

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.

 

[WWGD]

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?

 

[WWGD]

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.