The TREND function has three primary uses in Excel: Calculate a linear trend through a ... function calculates what would be the line of best fit on a chart using the least-squares method.

A linear equation is drawn as a straight line on a set of axes. To draw the graph we need coordinates. We generate these coordinates by substituting values into the linear equation. STEP 1 - Draw ...