Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Downloads by category
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Rabbits, Foxes, and Lorenz Attractors
- Downloads
- Taming Symbols in Excel
Recent Comments
Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec… Kaushal on Deflections and Moments in Rec… Kurt Clark on Working with units in Excel…
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