Tag Archives: LOGEST

Fitting high order polynomials

Posted on February 4, 2011 by

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 , , , , , , , , | 27 Comments

Using LINEST for non-linear curve fitting

Posted on January 19, 2011 by

Update 28 June 2015:  Also see Using Linest for non-linear curve fitting examples, hints, and warnings for more examples of fitting exponential and polynomial curves using LinEst. A frequent question on internet forums everywhere is how to do a least squares fit … Continue reading →

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