Multiple linear regression is a method that can use to understand the relationship between two or more independent variables and a dependent variable.
The following are the steps to conduct a multiple linear regression.
1. Enter the data
2. Select Data Tab and click on Data Analysis. A new window will pop up.
3. Select Regression and Click Ok
4. For Input Y Range, fill in the array of values for the response variable.
5. For Input X Range, fill in the array of values for the two explanatory variables. Check the box next to Labels so Excel knows that we included the variable names in the input ranges.
6. For Output Range, select a cell where you would like the output of the regression to appear. Then click OK.