Tag Archives: LOGEST

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

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

Using LINEST for non-linear curve fitting

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