Analyzing Data with a Trend Line

An Excel file that teaches how to perform Performing Data Analysis with Trend Line operation.

Excel Source: Analyzing Data with A Trend Line

A trend line is added to the graphs. The coefficients are calculated from the equations. The level of fit is measured by the R² value. Deviations are analyzed in a table. The results are presented in a report view.

Hope it is useful.