Use of R^2 adjusted in Simple Linear Regression-Excel?
- Context: Undergrad
- Thread starter WWGD
- Start date
-
- Tags
- Linear Regression
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
5 replies · 2K views
Discussion
Physics news on Phys.org
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,888
- 13,202
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,888
- 13,202
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