Multiple Linear regression analysis using Microsoft Excel's data analysis Tool Pak and ANOVA Concept 

Multiple linear regression is a method we can use to understand the relationship between two or more explanatory variables and a response variable. For Multiple Regression the order of the variables does matter; all of the independent variables must be in consecutive columns, and having the dependent variable first is easier. The order of the independent variables is not important-just that they are in consecutive columns. The coefficient section of your output will have one row for the intercept and one row for each independent variable (in the order of the columns). If you run the analysis twice with the only change being the order of the columns for the independent variable, the only change in the output will be the order of the rows in the coefficient section. Learn how to conduct multiple linear regression using Excel data analysis tool Pak and ANOVA Concepts.