Finding Graphical Equations

An Excel file that teaches how to perform Graphical Equation Finding operation.

Excel Template for Finding Graphical Equations

The data series is added to the graph. The equation is automatically derived by selecting the trend line. The coefficients are written to the cells. The goodness-of-fit coefficient is calculated to measure accuracy. The model is displayed linearly on the graph.

Hope it is useful.