Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Linking Excel to C
- Beam actions and deflections by Macaulay's Method
- Cubic Splines
Recent Comments

khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in…
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