Adjusted R Squared in Excel
You Don't Have to be a Statistician to understand
R Squared and Adjusted R Squared
Regression analysis evaluates the effects of one or more independent variables on a single dependent variable. Regression arrives at an equation to predict performance based on each of the inputs.
The R Squared and Adjusted R Squared values give the goodness of fit. Anything over 0.80 (80%) is considered a good fit.
R Squared can be biased. So, Adjusted R Squared tweaks the R Squared based on degrees of freedom.
Example of QI Macros Results
Analysis: If R Squared is greater than 0.80, as it is in this case, there is a good fit to the data. Some statistics references recommend using the Adjusted R Squared value.
In this example, R Squared of 0.980 means that 98% of the variation can be explained by the independent variables. Notice that the Adjusted R Squared (0.976) is less than R Squared (.980).
Why Choose QI Macros Statistical Software for Excel?
- Only $299 USD - less with quantity discounts
- No annual fees
- Free Technical Support
Easy to Use
- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free