WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Multiple Regression Formula

Multiple Regression Formula

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

By Madhuri Thakur

What is a Multiple Regression Formula?

Multiple regression formula is used in the analysis of relationship between dependent and multiple independent variables and formula is represented by the equation Y is equal to a plus bX1 plus cX2 plus dX3 plus E where Y is dependent variable, X1, X2, X3 are independent variables, a is intercept, b, c, d are slopes, and E is residual value.

y = mx1 + mx2+ mx3+ b

Multiple Regression Formula

Where,

  • Y= the dependent variable of the regression
  • M= slope of the regression
  • X1=first independent variable of the regression
  • The x2=second independent variable of the regression
  • The x3=third independent variable of the regression
  • B= constant

Explanation of Regression Analysis Formula

Multiple Regressions are a method to predict the dependent variable with the help of two or more independent variables. While running this analysis, the main purpose of the researcher is to find out the relationship between the dependent variable and the independent variables. In order to predict the dependent variable, multiple independent variables are chosen, which can help in predicting the dependent variable. It is used when linear regression is not able to do serve the purpose. Regression analysis helps in the process of validating whether the predictor variables are good enough to help in predicting the dependent variable.

Examples

You can download this Multiple Regression Formula Excel Template here – Multiple Regression Formula Excel Template

Example #1

Let us try and understand the concept of multiple regressions analysis with the help of an example. Let us try to find out what is the relation between the distance covered by an UBER driver and the age of the driver and the number of years of experience of the driver.

Multiple Regression Formula Example 1

For the calculation of Multiple Regression, go to the Data tab in excel, and then select the data analysis option. For the further procedure and calculation refers to the given article here – Analysis ToolPak in Excel

Example 1.1jpg

The regression formula for the above example will be

  1. y = MX + MX + b
  2. y= 604.17*-3.18+604.17*-4.06+0
  3. y= -4377

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 UBER driver, and the independent variables are the age of the driver and the number of experiences he has in driving.

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

Example #2

Let us try and understand the concept of multiple regressions analysis with the help of another example. Let us try to find out what is the relation between the GPA of a class of students and the number of hours of study and the height of the students.

calculate multiple regression Example 2

For the calculation, go to the Data tab in excel and then select the data analysis option.

Example 2.1jpg

The regression equation for the above example will be

y = MX + MX + b

y= 1.08*.03+1.08*-.002+0

y= .0325

 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 is the GPA, and the independent variables are study hours and height of the students.

Example #3

Let us try and understand the concept of multiple regressions analysis with the help of another example. Let us try to find out what is the relation between the salary of a group of employees in an organization and the number of years of experience and the age of the employees.

calculate Example3

For the calculation, go to the Data tab in excel and then select the data analysis option.

Example3.1jpg

The regression equation for the above example will be

  • y = MX + MX + b
  • y= 41308*.-71+41308*-824+0
  • y= -37019

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 salary, and the independent variables are the experience and age of the employees.

Relevance and Use

Multiple regressions is a very useful statistical method. Regression plays a very role in the world of finance. A lot of forecasting is done using regression analysis. For example, the sales of a particular segment can be predicted in advance with the help of macroeconomic indicators that has a very good correlation with that segment.

Recommended Articles

This has been a guide to Multiple Regression Formula. Here we discuss how to perform Multiple Regression using data analysis along with examples and a downloadable excel template. You can learn more about statistical modeling from the following articles –

  • Relative Change
  • Formula of Correlation
  • ANOVA vs Regression
  • Formula of R Squared 
6 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 >>

Category iconExcel Modeling,  Financial Modeling Tutorials

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

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 Multiple Regression Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More