Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Adjusted R Squared (Table of Contents)**

## What is Adjusted R Squared?

Adjusted R Squared or Modified R^2 determines the extent of the variance of the dependent variable which can be explained by the independent variable. The specialty of the modified R^2 is it does not take into count the impact of all independent variables rather only those which impacts the variation of the dependent variable. The value of the modified R^2 can be negative also, though it is not negative most of the times.

### Adjusted R Squared Formula

The formula to calculate the adjusted R square of regression is represented as below,

**R^2 = {(1 / N) * Σ [(xi – x) * (yi – y)] / (σx * σy)}^2**

Where

- R^2= adjusted R square of the regression equation
- N= Number of observations in the regression equation
- Xi= Independent variable of the regression equation
- X= Mean of the independent variable of the regression equation
- Yi= Dependent variable of the regression equation
- Y= Mean of the dependent variable of the regression equation
- σx = Standard deviation of the independent variable
- σy = Standard deviation of the dependent variable.

**Please Note**

For calculating adjusted R^2 in excel it needs to be provided y and x variables in the excel and the whole output along with Adjusted R^2 is generated by Excel. It is a special case where it is difficult to provide the output in text format, unlike other formulas.

### Interpretation of Adjusted R Squared

Adjusted R^2, determines the extent of the variance of the dependent variable which can be explained by the independent variable. By looking at the adjusted R^2 value one can judge whether the data in the regression equation is a good fit. Higher the adjusted R^2 better the regression equation as it implies that the independent variable chosen in order to determine the dependent variable is able to explain the variation in the dependent variable.

The value of the modified R^2 can be negative also, though it is not negative most of the times. In case of adjusted R square, the value of the adjusted R square will go up with the addition of an independent variable only when the variation of the independent variable impacts the variation in the dependent variable. This is not applicable in case of R^2, only applicable to the value of adjusted R^2.

4.9 (927 ratings)

### Examples of Adjusted R Squared Formula (with Excel Template)

Let’s see some simple to advanced examples of Adjusted R Squared Equation to understand it better.

#### Example #1

Let us try and understand the concept of adjusted R^2 with the help of an example. Let us try to find out what is the relation between the distance covered by the truck driver and the age of the truck driver. Someone actually does regression equation to validate whether what he thinks of the relationship between two variables, is also validated by the regression equation.

In this particular example, we will see which variable is the dependent variable and which variable is the independent variable. The dependent variable in this regression equation is the distance covered by the truck driver and the independent variable is the age of the truck driver. By running a regression with the variables we got the adjusted R square to be 65%. The snapshot below depicts the regression output for the variables. The data set and the variables are presented in the excel sheet attached.

The adjusted R^2 value of 65% for this regression implies that 65% of the variation in the dependent variable is explained by the independent variable. Ideally, a researcher will look for the coefficient of determination which is closest to 100%.

#### Example #2

Let us try and understand the concept of adjusted R square with the help of another example. Let us try to find out what is the relation between the height of the students of a class and the GPA grade of those students. In this particular example, we will see which variable is the dependent variable and which variable is the independent variable. The dependent variable in this regression equation is the GPA of the students and the independent variable is the height of the students.

By running a regression with the variables we got the adjusted R^2 to be negligible or negative. The snapshot below depicts the regression output for the variables. The data set and the variables are presented in the excel sheet attached.

The adjusted R^2 value is negligible for this regression which implies that the variation in the dependent variable is not explained by the independent variable. Ideally, a researcher will look for the coefficient of determination which is closest to 100%.

### Interpretation

Adjusted R square is a very important output in order to find out whether the data set is a good fit or not. Someone actually does regression equation to validate whether what he thinks of the relationship between two variables, is also validated by the regression equation. Higher the adjusted R^2 better the regression equation as it implies that the independent variable chosen in order to determine the dependent variable is chosen properly. Ideally, a researcher will look for the coefficient of determination which is closest to 100%.

### Recommended Articles

This has been a guide to what is Adjusted R Squared and its meaning. Here we discuss how to perform Adjusted R Square using its formula along with examples and downloadable excel template. You can learn more about statistical modeling from the following articles –

- Coefficient of Determination
- Gini Coefficient Formula
- Formula of R Squared
- Regression vs ANOVA – Compare
- FORECAST Function in Excel
- Excel Dashboard Course

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply