Tag Archives: Linest

Deflections and Moments in Rectangular Plates

Posted on August 9, 2020 by dougaj4

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 , , , , , , , , , , | 5 Comments

LinEstGap with non-linear functions

Posted on March 14, 2020 by dougaj4

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 , , , , , , , , , | 4 Comments

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

Posted on February 5, 2017 by dougaj4

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 , , , , , , | 9 Comments

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

Posted on June 28, 2015 by dougaj4

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 , , , , , , | 3 Comments

Using LinEst() on data with gaps

Posted on May 14, 2011 by dougaj4

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 →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 40 Comments