How do you calculate a trendline in Excel? Excel displays the linear equation on the chart in the y=mx+b format. The formula for slope is this one: How do you insert a straight line in Excel?Īdd a linear regression line to the scatter chart by clicking the “Layout” tab, selecting the “Trendline” drop-down box and clicking “Trendline Options.” Select the “Linear” option and click the “Display Equation on Chart” box. Step 3: Plug these two points into the formula for slope. Your next step is to locate two points on the trend line. To find your equation of a trend line, follow these steps.Step 1: Draw your trend line.
How do you find the equation of a trendline?
