### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Problems with UCase and LCase in VBA
- Using LINEST for non-linear curve fitting
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fine as a Bee's wing

### Recent Comments

vefa okumus on Section Properties with MeshPY… dougaj4 on Section Properties with MeshPY… vefa okumus on Section Properties with MeshPY… Working with units i… on Evaluating text with units and… Working with units i… on Daily Download 24: Units for… dougaj4 on Evaluating text with units and… dougaj4 on About Newton Excel Bach Jay Tan on About Newton Excel Bach Scipy Statistics Fun… on xlwSciPy update for Python… dougaj4 on 3DFrame Ver 1.03 and Frame4 Ve… Tony on 3DFrame Ver 1.03 and Frame4 Ve… Using Section Proper… on Section properties for groups… Brad Clarke on Section properties for groups… dougaj4 on Section properties for groups… Brad Clarke on Section properties for groups…

# 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 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 curve fitting, Excel, least squares, Linest, LOGEST, XY chart
91 Comments