Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Cubic Splines
- Retrieving unique values from a range or array ...
- A catenary function
- The history of the theory of beam bending - Part 3
- Writing Arrays to the worksheet - VBA function
- Converting from global to local coordinates (and vice versa)
- Linestgap with data in rows
Recent Comments
Tag Archives: over-fitting
Using Linest for non-linear curve fitting, examples, hints and warnings
Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog. This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading
Posted in Curve fitting, Excel
Tagged Data Analysis Tools, Excel, Linest, non-linear fitting, non-linear regression, over-fitting, Trend
3 Comments