Recent Comments
Tag Archives: AlgLib
Daily Download 13: The ALGLIB maths library and Excel
Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading
Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, complex numbers, Cubic splines, Excel, Matrix Functions, statistics, UDF, VBA
7 Comments
Alglib Spline Functions 1.32
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 Akima Spline, AlgLib, Catmull-Rom Spline, Cubic spline, Excel, Hermite Spline, Least Squares fit, Spline, Spline Integration, UDF, VBA
Leave a comment
Non linear regression – 2; ALGLIB functions
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 AlgLib, Excel, Least Squares fit, non-linear regression, UDF, VBA
8 Comments
Non linear regression – 1
Recent posts have described how to fit linear equations (or equations that can be made linear) to a set of data, using the Excel Linest functions, or User Defined Functions (UDF’s) linking to the ALGLIB library (see Using LINEST for non-linear … Continue reading
Posted in AlgLib, Concrete, Excel, Maths, Newton
Tagged AlgLib, Excel, non-linear regression, Solver
6 Comments
Newton Excel Bach, not (just) an Excel Blog 