How to Run Multiple Regression in Excel

Excel is a suitable program for running multiple regressions for users who do not have more advanced statistical software. This regression run is both quick and easy to learn.

Steps

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/71/Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/71/Run-a- Multiple-Regression-in-Excel-Step-1-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-1-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/51/Addin0.jpg/728px-Addin0.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/5/51/Addin0.jpg/728px-Addin0.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:412,”licensing”:”<div class=”mw-parser-output”></div>”}

Open Microsoft Excel.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c9/Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c9/Run-a- Multiple-Regression-in-Excel-Step-2-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-2-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f4/Addin1.jpg/728px-Addin1.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/f/f4/Addin1.jpg/728px-Addin1.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:412,”licensing”:”<div class=”mw-parser-output”></div>”}

Check if Analysis TopPak is working by clicking the “Data” tab. If you don’t see this option, you need to enable the Add-in as follows:

Open the “File” menu (or press Alt+F) and select “Options”
Click “Add-Ins” on the left side of the window
Click “Go” next to the “Manage: Add-ins” option at the bottom of the window
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1f/Addin2.jpg/728px-Addin2.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/1/1f/Addin2.jpg/700px-Addin2.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:700,”bigHeight”:396,”licensing”:”<div class=”mw-parser-output”></div>”}

Select Add-ins

In the new window, check the box next to “Analysis TopPak”, then click “OK”

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Addin3.jpg/728px-Addin3.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/2/26/Addin3.jpg/728px-Addin3.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:412,”licensing”:”<div class=”mw-parser-output”></div>”}
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/27/Addin4.jpg/728px-Addin4.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/2/27/Addin4.jpg/728px-Addin4.jpg”,”smallWidth”:460,”smallHeight”:261,”bigWidth”:728,”bigHeight”:413,”licensing”:”<div class=”mw-parser-output”></div>”}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Addin5.jpg/728px-Addin5.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/8/85/Addin5.jpg/728px-Addin5.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:412,”licensing”:”<div class=”mw-parser-output”></div>”}

The add-in is now enabled

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a7/Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a7/Run-a- Multiple-Regression-in-Excel-Step-3-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-3-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter your data or open the data file. The data should be in contiguous columns and the labels should be in the first row of each column.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/33/Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/33/Run-a- Multiple-Regression-in-Excel-Step-4-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-4-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Select the “Data” tab, then click “Data Analysis” in the “Analysis” section (usually located at or near the right of the Data tab options).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3a/Addin6.jpg/728px-Addin6.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/3/3a/Addin6.jpg/728px-Addin6.jpg”,”smallWidth”:460,”smallHeight”:297,”bigWidth”:728,”bigHeight”:470,”licensing”:”<div class=”mw-parser-output”></div>”}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b1/Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b1/Run-a- Multiple-Regression-in-Excel-Step-5-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-5-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter dependent data by placing the mouse pointer in the “Input Y-Range” field, then selecting the data column in the Workbook (a collection of worksheet types).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3a/Addin6.jpg/728px-Addin6.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/3/3a/Addin6.jpg/728px-Addin6.jpg”,”smallWidth”:460,”smallHeight”:297,”bigWidth”:728,”bigHeight”:470,”licensing”:”<div class=”mw-parser-output”></div>”}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/10/Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/10/Run-a- Multiple-Regression-in-Excel-Step-6-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-6-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

You can enter independent variables by placing the mouse pointer in the “Input X-Range” field, and then selecting multiple columns in the Workbook (such as selecting $C$1: $E$53).

NOTE: The independent variable data columns MUST be next to each other for the input data to work properly.
If you’re using labels (usually in the first row of each column), you’ll need to click the box right next to “Labels”.
The default confidence level is 95%. If you want to change this value, click in the box next to “Confidence Level” and adjust the value as desired.
You can type in “New Worksheet Ply” field under “Output Options”

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Run-a- Multiple-Regression-in-Excel-Step-7-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-7-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Select the desired options in the “Residuals” section. The output residual graph is generated using the “Residual Plots” and “Line Fit Plots” options.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3e/Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg/v4-728px- Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3e/Run-a- Multiple-Regression-in-Excel-Step-8-Version-5.jpg/v4-728px-Run-a-Multiple-Regression-in-Excel-Step-8-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}

Click “OK” and the analysis will proceed.

Steps

Related Posts