### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Taming Symbols in Excel
- Section Properties of Defined Shapes - Spreadsheet

### Recent Comments

Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…

# Tag Archives: least squares

## More circle fitting options with Scipy

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles. An example of the problem can be seen in the screen shots below: The function … Continue reading

Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged curve fitting, Excel, least squares, Numpy, ODR, Python, SciPy, VBA
Leave a comment

## ALGLIB linear and polynomial fitting functions

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

## 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