Tag Archives: non-linear 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 , , , , , , | 3 Comments

Alglib/Python linear and non-linear fitting functions

I have updated the Alglib spline-matrix spreadsheet to use the latest Alglib release, using the Python version, in conjunction with the Excel-Python add-in. To use the spreadsheet requires: Python ver 2.7 (or 2.6) Excel-Python Alglib with Python interface In addition … Continue reading

Posted in AlgLib, Excel, Link to Python, Newton, UDFs, VBA | Tagged , , , , , , | 4 Comments