Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Beam actions and deflections by Macaulay's Method
- Reinforced Concrete Moment-Curvature - 1
- Frame Analysis with Excel
- Biaxial bending update
- Retrieving unique values from a range or array ...
- ConBeamU Update
- Unit aware continuous beam spreadsheet update
Recent Comments
Tag Archives: Weighted least squares regression
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
9 Comments