Category Archives: Newton

A Tail of Two Letters …

Posted on 14/02/2011 by dougaj4

… or the importance of being Douglas. I’m currently reading Douglas Hofstadter’s “I am a Strange Loop”, which has reminded me of two hypothetical imaginary letters that I never sent (and now never will) to Mr Hofstadter and Douglas Adams. … Continue reading →

Posted in Newton | Tagged , , , | 1 Comment

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

Seeing through Mingus eyes

Posted on 28/01/2011 by dougaj4

At the top of Bob Phillips’ Blog home page is a quote from Charles Mingus, the great jazz bassist, band leader and composer: “Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that’s creativity” If Bob hadn’t … Continue reading →

Posted in Bach, Computing - general, Newton | Tagged , , , | Leave a comment

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

Using LINEST for non-linear curve fitting

Posted on 19/01/2011 by dougaj4

Update 14 March 2020: See LinEstGap with non-linear functions for the latest version of Linest-Poly with new functions for non-linear curves allowing more convenient input and work with data with gaps errors, and/or hidden lines. Update 28 June 2015:  Also see … Continue reading →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 96 Comments