# How to do Linear Regression in Excel

The linear regression is similar to multiple regression. But, there are difference between them.

## How it works?

The linear regression function answers the question: "What value will a given phenomenon (dependent variable) take, depending on the value of another phenomenon (explanatory variable)?" Due to the term "linear", a method which has a way to remove the explained phenomenon and the variable explanation is precisely linear.

## How to calculate?

We'd perform the task that together, in a step-by-step format. But, first you'd need to get the Data Analysis by following through these steps: file > options > add-ins> go > data analysis > ok. Further, you'd also needs a data that look like this:

1. Click on Data (1), and then press on the Data Analysis (2).

2. Click on the regression.

3. Select the cells for y-values (1), then the ones for x-values (2), and then check the labels (3). Finally, press ok (4).

4. Click on an empty cell (1), and then press insert (2). Press scatter chart (3), and choose a scatter chart (4).

5. Right click on the chart (1), and choose Select Data (2).