Figure 2: Animated graph showing possible places a line of best fit could be drawn. Credit: Technology Networks. Through the magic of least sums regression, and with a few simple equations, we can ...

Trend lines are a type of regression analysis ... and in doing do, calculates the equation of the trend line. This equation can be accessed using Excel's built-in Visual Basic tools.