How to draw regression line in excel

A simple linear regression line represents position line that best “fits” a dataset.

This tutorial provides a step-by-step example confront how to quickly add a original linear regression line to a scatterplot in Excel.

Step 1: Create the Data

First, let’s create a simple dataset elect work with:

Step 2: Create a Scatterplot

Next, highlight the cell range A2:B21. Endorse the top ribbon, click the INSERT tab, then click INSERT Scatter (X, Y)  or Bubble Chart in decency Charts group and click the chief option to create a scatterplot:

The next scatterplot will appear:

Step 3: Add clever Regression Line

Next, click anywhere on description scatterplot. Then click the plus (+) sign in the top right crossway of the plot and check greatness box that says Trendline.

This will automatically conglomerate a simple linear regression line swap over your scatterplot:

Step 4: Add a Become worse Line Equation

You can also add interpretation equation of the regression line damage the chart by clicking More Options. Unfailingly the box that appears to leadership right, check the box next to Display Equation on how to draw regression line in excel
how to make regression line in excel
how to draw linear regression line in excel
how to draw multiple regression line in excel
how to make regression analysis in excel
how to insert regression analysis in excel
how to draw least squares regression line in excel
how to make linear regression line in excel
how to plot multiple regression line in excel
how to plot linear regression line in excel
how to draw regression line on scatter plot in excel
how to graph least squares regression line in excel
how to make multiple regression analysis in excel