How to Do Linear Regression in Excel?

Enter your X values in one column and Y values in another column

Select the data range

Go to the Insert tab

Click Scatter chart

Choose a scatter plot

Click a data point in the chart

Right-click and select Add Trendline

Choose Linear trendline

Check Display Equation on chart

Check Display R-squared value on chart

Use the equation to predict Y values

Or use the SLOPE function to get the slope

Or use the INTERCEPT function to get the intercept

Or use the LINEST function for full regression output

Suggested for You

Trending Today