Click on Insert and select Scatter Plot under the graphs section as shown in the image below. Open the Regression Analysis tool. You should have at least two columns of numbers that.
Now first calculate the intercept and slope for the regression equation.
Compare the equation to the equation we got in manual method. Now you can see the regression equation and R² value above the trendline. Click on the Data tab and Data Analysis. Select Regression and click OK.