WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Adjusted R Squared

Adjusted R Squared

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Adjusted R Squared?

Adjusted R Squared refers to the statistical tool which helps the investors in measuring the extent of the variance of the variable which is dependent that can be explained with the independent variable and it considers the impact of only those independent variables which have an impact on the variation of the dependent variable.

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 impact 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 time.

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

Adjusted R Squared Formula

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 it in excel, it needs to be provided y and x variables in the excel, and Excel generates the whole output along with Adjusted R^2. It is a particular case where it is difficult to provide the work in text format, unlike other formulas.

Interpretation

Adjusted R square 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. The higher the adjusted R^2 better the regression equation as it implies that the independent variable is chosen to determine the dependent variable can 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 time. In the 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 the case of R^2, only relevant to the value of adjusted R^2.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Examples

You can download this Adjusted R Squared Formula Excel Template here – Adjusted R Squared Formula Excel Template

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 does a 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.

Adjusted R Squared Formula Example 1.1jpg

The adjusted R^2 value of 65% for this regression implies that the independent variable explains 65% of the variation in the dependent 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.

Example 2.1jpg

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

Interpretation

Adjusted R square is a significant output to find out whether the data set is a good fit or not. Someone does a regression equation to validate whether what he thinks of the relationship between two variables is also validated by the regression equation. Higher the value, the better the regression equation as it implies that the independent variable chosen to determine the dependent variable is appropriately chosen. 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 and examples and a downloadable excel template. You can learn more about statistical modeling from the following articles –

  • Coefficient of Determination
  • Gini Coefficient Formula
  • R Squared
  • Regression vs ANOVA
  • Expected Value Formula
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Adjusted R Squared Formula Excel Template

Coursera IPO Financial Model & Valuation Free Download