Previously, you have to use Excels Analysis ToolPak or a combination of different functions.

Got a different version No problem, you can still follow the exact same steps.

They are factors used in solving the dependent variable due to their influence or effect on the said variable.

Lets assume youre visualizing your e-commerce sites pageviews and sales the previous year.

This indicates that as the independent variable increases, the dependent variable also increases.

The same with our example, as the pageviews increase, we can expect to see a rise in sales as well.

This suggests that as the independent variable increases, the dependent variable decreases.

There is no correlation between the variables (therefore, no way to predict the next values) when the points in the scatter plot dont resemble a line as they are scattered.

You can still see a line if you add a trendline no matter how random the points are, but the line is usually close to a horizontal line.

Now, you can visually see the correlation between the variables without breaking a sweat.

Regression In Excel For Mac