From the graph, we see that R 2 = 0.9488. In addition, Excel can be used to display the R-squared value. This video will show the long way (statistics textbook way) of calculating the intercept and the slop. On an Excel chart, there's a trendline you can see which illustrates the regression line - the rate of change Using Microsoft Excel to calculate Regression Equation. Here's the linear regression formula: y = bx + a + ε As you can see, the equation shows how y is related to x. Scroll down to find the regression option and click OK Given a set of data, video demonstrates how to find the linear regression for the data and the correlation using Excel which includes a graph with a best-fit.
You will now see a window listing the various statistical tests that Excel can perform. Click on the Data menu, and then choose the Data Analysis tab. To run the regression, arrange your data in columns as seen below. Home How to find regression equation in Excel
