### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

### Recent Comments

The age of snakeoil… on They all laughed at Christophe… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… Indexing pdf files,… on Indexing pdf content dougaj4 on The answer to Life the Univers… Matija Bandić on The answer to Life the Univers… Afazio on Plotting Mandelbrot dougaj4 on Plotting Mandelbrot Afazio on Plotting Mandelbrot r/excel - LINEST… on Weighted Least Squares Regress… dougaj4 on Downloads Rajesh M on Downloads dougaj4 on Downloads

# Tag Archives: non-linear regression

## Using Linest for non-linear curve fitting, examples, hints and warnings

Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog. This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading

Posted in Curve fitting, Excel
Tagged Data Analysis Tools, Excel, Linest, non-linear fitting, non-linear regression, over-fitting, Trend
3 Comments

## Daily Download 14: Curve Fitting 1

Today’s download topic covers fitting a straight line or curve to scattered data, using the “least squares” method. Fitting a spline curve to pass exactly through a series of points will be covered in a few days. Use of the … Continue reading

Posted in AlgLib, Charts, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, high order polynomials, least squares method, linear regression, non-linear regression, UDF, VBA
Leave a comment

## Non linear regression – 2; ALGLIB functions

The previous post looked at using the Excel Solver to fit a non-linear equation to a given set of data, using the least squares method. This approach is reasonably convenient and straightforward, but it has a number of disadvantages: The … Continue reading

Posted in AlgLib, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, Least Squares fit, non-linear regression, UDF, VBA
8 Comments

## Non linear regression – 1

Recent posts have described how to fit linear equations (or equations that can be made linear) to a set of data, using the Excel Linest functions, or User Defined Functions (UDF’s) linking to the ALGLIB library (see Using LINEST for non-linear … Continue reading

Posted in AlgLib, Concrete, Excel, Maths, Newton
Tagged AlgLib, Excel, non-linear regression, Solver
4 Comments