Category Archives: Excel

Charts for discussion

Posted on 24/02/2011 by dougaj4

See the comment from Georg Ströhlein under 2D Spline Interpolation with ALGLIB Here are the charts referred to:

Posted in Charts, Excel, Maths, Newton | Tagged , | 1 Comment

3 year report

Posted on 23/02/2011 by dougaj4

As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet.  The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading →

Posted in Excel | Tagged | 4 Comments

ALGLIB linear and polynomial fitting functions

Posted on 17/02/2011 by dougaj4

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 →

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

Fitting high order polynomials

Posted on 04/02/2011 by dougaj4

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 →

Posted in AlgLib, Charts, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 31 Comments

New Links

Posted on 26/01/2011 by dougaj4

Two new Excel links on the list to the right, both with a tonne of good information on how to get more out of Excel: Bob Phillips writes the Excel Do, Dynamic Does blog, with a focus on business information.  The … Continue reading →

Posted in Arch structures, Excel, Historic Bridges, Newton | Tagged , , | Leave a comment