Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Downloads
- Writing Arrays to the worksheet - VBA function
- Automatic download of csv files
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