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

**Formula of Multiple Regression (Table of Contents)**

## What is Multiple Regression Formula (Equation)?

Multiple Regressions are a method to predict the dependent variable with the help of two or more independent variables. While running a multiple regression 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. Now you can take look at the below-given formula of Multiple Regression.

### Formula of Multiple Regression

A multiple regression tries to find the best fit line for the dependent variable with the help of multiple independent variables. The equation for the multiple regression analysis is the same as the equation for a line which is

**y = mx1 + mx2+ mx3+ b**

Where,

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

### Explanation of Regression Analysis Formula

While running a multiple regression analysis, the main purpose of the researcher is to find out the relationship between the dependent variable and the independent variable. In order to predict the dependent variable, multiple independent variables are chosen which can help in predicting the dependent variable. Regression analysis helps in the process of validating whether the predictor variables are good enough to help in predicting the dependent variable.

### Examples of Multiple Regression Formula

Let’s see some simple to advanced examples of Multiple Regression Formula to understand it better.

#### 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.**

4.9 (927 ratings)

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

The regression formula for the above example will be

**y = mx + mx + b****y= 604.17*-3.18+604.17*-4.06+0****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 experience he has in driving.

#### 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.**

For the calculation of Multiple Regression go to the data tab in excel and then select data analysis option.

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 equation 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.**

For the calculation of Multiple Regression go to the data tab in excel and then select data analysis option.

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 experience and age of the employees.

### Relevance and Use of Multiple Regression Formula

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 downloadable excel template. You can learn more about statistical modeling from the following articles –

- Relative Change | Definition
- What is Standard Deviation Formula?
- Formula of Adjusted R Squared
- Formula of Correlation
- FORECAST Function in Excel
- Regression vs ANOVA – Compare
- R Squared Formula
- Relative Standard Deviation Formula

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

- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications