On an Excel chart theres a trendline you can see which illustrates the regression line the rate of change. For our example well try to fit regression for Weight values which is a dependent variable with the help of Height values which is an independent variable. This is the predictor variable also called dependent variable.
Heres the linear regression formula.
In your Excel click File Options. This produces the value 36. To create a regression equation using Excel follow these steps. In the Add-ins dialog box tick off Analysis Toolpak and click OK.