How to fit Quadratic and Cubic Curves with LINEST in Excel
The Excel LINEST function is normally used to fit a straight line to data points. However, using this little-known technique you can also fit higher-order curves. This example shows how to use LINEST to fit Quadratic and Cubic Curves to data. This example comes from the sample spreadsheet LINEST-2-3.xlsx in our Excel for Engineers online…