Multiple Regression in Excel

The multiple regression in Microsoft Excel is possible, and the best method is acknowledgment of a step-by-step instruction that make it possible to do it. The first thing is having a data that could look something like this:

 

data table1. Click on data (1), and then click on the data analysis (2)data analysis

Note: The data analysis could be gotten from the add-in (file > options > add-ins > Go).

2. Choose Regression in the Data Analysis, and click ok.

choose regression

3. Choose the data you’d want to analyze on X values (1), and Y values (2). Select desired options, under the residuals (3), and press ok (4).

residuals

In conclusion, the multiple regression would look something like this:

Multiple Regression ready

Template

You can download the Template here – Download