Linear Regression Equation Excel. The formula that appears on the chart is in the regression equation in the form y bx a where. On the data tab in the analysis group click data analysis.
You should now see that the excel graphing routine uses linear regression to calculate the slope y intercept and correlation coefficient. Select the x axis horizontal and y axis data and click ok. To create a regression equation using excel follow these steps.
Here s a more detailed definition of the formula s parameters.
Check the labels box to include headers. Select the residuals checkbox and click ok. Using the regression equation to calculate concentrations highlight a spreadsheet cell to hold x the result of the final equation cell c12 labeled b in figure 5. B is the line s slope.
