Click in the cell representing y in your equation cell B12 in Figure 5 to put this cell label in your equation. How to get the equation from a straight line graph. Right click on the trendline equation Format Trendline Label change Category to Number and add 10 decimals.
This equationformula can be from any type of scatter graph for exa.
Slope of trendline b. Set the initial value of X as 0 in cell B6. The following image shows how to create the y-values for this equation in Excel using the range of 1 to 10 for the x-values. Click in the cell representing y in your equation cell B12 in Figure 5 to put this cell label in your equation.