### 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
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Retrieving unique values from a range or array ...
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Problems with UCase and LCase in VBA
- Time in hours and minutes between two dates

### Recent Comments

dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks Concrete Stress Bloc… on Stress blocks in AS 3600 Section Properties f… on Using Section Properties-… dougaj4 on ULS Design Functions and … dougaj4 on ULS Design Functions and … dougaj4 on Using LinEst() on data with… Eduardo Torres on Using LinEst() on data with… DonB on ULS Design Functions and … DonB on ULS Design Functions and … James D on ULS Design Functions and …

# Tag Archives: Linest

## Deflections and Moments in Rectangular Plates

Following a question here I have compared tabulated coefficients for deflections and bending moments in a rectangular plate with results of a Strand7 analysis using 8 noded plate/shell elements. The results are summarised below, and in a spreadsheet which also … Continue reading

Posted in Beam Bending, Curve fitting, Excel, Finite Element Analysis, Newton
Tagged Excel, FEA, Linest, Moody, Pilkey, plate bending, plate deflections, Plate stresses, Roark, Strand7, Timoshenko
Leave a comment

## LinEstGap with non-linear functions

The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data. It … Continue reading

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Exponential curves, Linest, Linest with gaps, Log curves, non-linear curve fitting, Polynomial curves, Power curves, UDF, VBA
1 Comment

## Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

Least squares linear regression in Excel is easy. That’s what the Linest and Trend functions do. That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Linest, Python, SciPy, UDF, VBA, Weighted least squares regression
5 Comments

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

## Using LinEst() on data with gaps

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps. There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading