# How to run a regression in Excel

Regression in Excel is a way to automate the statistical process of comparing multiple sets of information to see how changes in independent variables affect changes in dependent variables. If you’ve always wanted to find a correlation between two things, regression analysis in Excel is one of the best ways to do it.

The instructions in this article apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010.

## What does regression mean?

Contents

Regression is a statistical modeling approach that analysts use to determine relationships among multiple variables.

Regression analysis starts with a single variable that you are trying to analyze and independent variables that you are testing to see if they affect that single variable. The analysis examines changes in the independent variables and attempts to correlate those changes with the resulting changes in each (dependent) variable.

It may sound like advanced statistics, but Excel makes this complex analysis available to everyone.

## Perform linear regression in Excel

The simplest form of regression analysis is linear regression. Simple linear regression examines the relationship between just two variables.

For example, the table below shows data containing the number of calories a person has burned each day and their weight on that day.

Because this table contains two columns of data, and one variable could potentially affect the other, you can use Excel to perform a regression analysis on this data.

Before you can use Excel’s regression analysis feature, you must enable the Analysis ToolPak add-on in the Excel Options screen.

• In Excel, select the dossier and choose options.
• Finally select the Go to Button.
• In the Add-Ins pop-up window. activate Analysis Toolkit by clicking on the box in front of it to put a tick and select OK.
How to use INDEX and MATCH function in Excel

Now that the Analysis ToolPak is activated, you can start performing regression analysis in Excel.

## Multiple linear regression analysis in Excel

To perform the same linear regression but with multiple independent variables, select the entire range (multiple columns and rows) for Enter the X range.

If you select multiple independent variables, you are less likely to find such a strong correlation because there are many variables.

However, regression analysis in Excel can help you find correlations with one or more of these variables that you may not know existed just by looking at the data manually.