Recent Comments
dougaj4 on Tanh-Sinh Quadrature v. 5… 
metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Numerical Integration With Tan… Tanh-Sinh Quadrature… on Numerical Integration With Tan… 
Graeme Dennes on Numerical Integration With Tan… 
John Maddock on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… 
Charles Chika on Frame Analysis with Excel… dougaj4 on Weighted Least Squares Regress… 
NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… John Maddock on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan…
Tag Archives: high order polynomials
Python for VBA users – 5; Using built in numpy functions
Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged complex numbers, Cubic, Excel, high order polynomials, Jenkins-Traub Method, Polynomial, Python, PyXLL, Quadratic, Quartic, UDF, VBA
5 Comments
Daily Download 14: Curve Fitting 1
Today’s download topic covers fitting a straight line or curve to scattered data, using the “least squares” method. Fitting a spline curve to pass exactly through a series of points will be covered in a few days. Use of the … Continue reading
Posted in AlgLib, Charts, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, high order polynomials, least squares method, linear regression, non-linear regression, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 