Use of R^2 adjusted in Simple Linear Regression-Excel?
- Level: Undergrad
- Thread starter WWGD
- Start date
-
- Tags
- Linear Regression
Join the discussion
Registration is free. Start your own thread to ask a follow-up.
5 replies · 2K views
Physics news on Phys.org
Discussion
Education Advisor
- 551
- 192
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).
Science Advisor
Homework Helper
- 7,907
- 13,225
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?BvU said:Did you consult the help file ? Anything there that specifically needs extra explanation ?
Science Advisor
Homework Helper
- 7,907
- 13,225
Precisely. The adjustment is done for additional variables that are included, AFAIK.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).
Similar threads
Undergrad Simple Linear Regression Problem
- Absolut
- · Replies 2 ·
- Set Theory, Logic, Probability, Statistics
- Replies
- 2
Stats: Simple Linear Regression
- Ted123
- · Replies 3 ·
- Calculus and Beyond Homework Help
- Replies
- 3