Tag Archives: Least Squares fit

Alglib Spline Functions 1.32

Posted on 23/07/2012 by dougaj4

Following a comment to AlgLib Spline Functions, the AL-Spline-Matrix spreadsheets have been updated, and may be downloaded from AL-Spline-Matrix03 for Excel 2003 and earlier and AL-Spline-Matrix07 for Excel 2007 and 2010.

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | Leave a comment

Non linear regression – 2; ALGLIB functions

Posted on 05/03/2011 by dougaj4

The previous post looked at using the Excel Solver to fit a non-linear equation to a given set of data, using the least squares method.  This approach is reasonably convenient and straightforward, but it has a number of disadvantages: The … Continue reading →

Posted in AlgLib, Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments

AlgLib Spline Functions

Posted on 07/06/2010 by dougaj4

Following earlier posts on cubic splines I have collected the Alglib interpolation routines, and the necessary supporting routines, and written interface functions to allow most of the 1Dspline routines to be called from the spreadsheet.  Since there is a large measure … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 6 Comments