Make a Multiple Regression in Excel

Today we are going to perform a task that can be quite useful in hydrology, perform a Multiple Regression in Excel.nnFirst, suppose we have the following information:nnnn

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,

VARY	Varx1	Varx2
1	10	0
2	10	10
3	20	10
4	30	10
5	40	10
6	50	10
7	60	10

nnnThat is to say that we have a Variable Y that is based on the variables X1 and X2, in this case it is quite simple to say that the function would be:nnVar Y = VarX1*0.1+VarX2*0.1nnThen, to perform the Multiple Regression in Excel we have to first of all go to options >> Add-ons and verify that we have the option “Tools for analysis” enabled:nnnnnIf the option was not available, we simply have to go to Manage: “Excel plugins”, in the box we have to select the corresponding option:nnnnTo generate regression, we have to go to the Data tab and select Data Analysis:nnnnSelect the option Regression:nnnnY we complete the box with the information we have:nnnnnTo explain quickly, in the Y range we select the range of the variable Y, while for the input X range we select the range of the variables X, where it says Output Range, we select where we want the regression information to be displayed.nnThen, click accept, we will have the following box:nnnnnThen finally our regression would be:nnY = 1.5543122347522E-15+0.1*X1+0.1*X2nnAs always, I leave you the excel file with the information, although in this case, I don’t think it is very helpful. You can download it here: example_regression_multiplennn I remind you that you can find many more tutorials both of excel and many other programs. We hope this post will be to your liking and any doubts just leave it in the comments.nnnnn