### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Downloads by category
- The angle between two vectors, Python version
- Solving the Lagrangian Point equation for the Moon
- Cubic Splines
- Fitting high order polynomials
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples

### Recent Comments

# 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