Recent Comments
Category Archives: VBA
More links
One of the nice things about running a blog is that visitors leave the address of the site that lead them here, and if you follow these links back it sometimes takes you to fascinating sites that you would never … Continue reading
Double Exponential Quadrature
Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to include Double Exponential Quadrature. His brief notes are given below, and more details and links to background information are included in the download file. ================================================================= Double Exponential Quadrature UDFs added to Tanh-Sinh Quadrature … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double exponential quadrature, Excel, numerical integration, Tanh-Sinh method, UDF, VBA
1 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
ALGLIB linear and polynomial fitting functions
As promised here: Fitting high order polynomials this post presents details of four Excel User Defined Functions (UDFs) linking with ALGLIB functions for least squares fitting of linear and polynomial functions. The new functions are: AL_Linest: AL_LinestCW: AL_PolyFit: and AL_PolyFitCW: These functions have been added … Continue reading
Fitting high order polynomials
This post is a follow up to Using LINEST for non-linear curve fitting and the following comments from Scott Rogers and Lori Miller. Scott found that he was getting different results from Linest and the xy chart trend line for polynomials of … Continue reading
Newton Excel Bach, not (just) an Excel Blog 