Microsoft Excel can generate trend lines based on data you provide, and in doing do, calculates the equation of the trend line. This equation can be accessed using Excel's built-in Visual Basic tools.

Least squares regression equations How do you calculate a least squares regression line by hand? Drawing a least squares regression line by hand What are the disadvantages of least-squares regression?

The line of best fit is an output of regression analysis that represents the relationship between two or more variables in a dataset.

In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula. R2, or R-squared, is the relationship between ...

Robert A. Stine, Bootstrap Prediction Intervals for Regression, Journal of the American Statistical Association, Vol. 80, No. 392 (Dec., 1985), pp. 1026-1031 ...