Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Section Properties with MeshPY, including torsion and warping
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Filling Blanks with Go To-Special (and local help rant)
- Finding Prime Numbers with Excel, and using Array Formulas
Recent Comments
Tag Archives: Trend
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