Recent Comments
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 