how to plot a regression line in excel for mac

Plot A Regression Line In Excel Free To Move

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.

Plot A Regression Line In Excel Free To Move

Feel free to move it around so that it doesnt block the data points or the line.

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

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.

Before, you have to mathematically solve it and manually draw a line closest to the data.

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

How To Plot A Regression Line In Excel For Mac