Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Contour plots with Excel and Matplotlib
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Drawing in Excel 7 - Creating drawings from coordinates
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Stereograms
- Deflections and Moments in Rectangular Plates
- The Countif bug (and how to avoid it)
Recent Comments
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
Using LINEST for non-linear curve fitting
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 curve fitting, Excel, least squares, Linest, LOGEST, XY chart
91 Comments