XLPack 6.1
Excel Worksheet Function Numerical Library Reference Manual
Loading...
Searching...
No Matches

◆ WCpzero()

Function WCpzero ( N As  Long,
A As  Variant 
)

Roots of a polynomial with complex coefficients by Newton method (complex number representation in Excel format)

Purpose
WCpzero computes all roots of a polynomial p(z) with complex coefficients by Newton method.
p(z) = a0*z^n + a1*z^(n-1) + ... + an

To represent complex numbers in Excel cells, complex number format in Excel (e.g. 2.5+1i) is used. Worksheet function Complex can be used to input complex numbers into cells.
Returns
N+1 x 2
Column 1Columns 2
Rows 1 to NRootsError bound for the computed roots
Row N+1Return codeNumber of iterations performed to converge

Return code.
= 0: Successful exit.
= 1: Maximum number of iterations (25*N) exceeded. Best current estimates of the zeros are returned. Error bounds are not calculated.
Parameters
[in]NDegree of polynomial. (N >= 1)
[in]A(N+1 x 1) or (1 x N+1) Complex coefficients a0 to an of polynomial a0 x^n + a1 x^(n-1) + … + a(n-1)x + an.
Reference
SLATEC
Example
Solve the following algebraic equation.
x^3 + (-19-14i)*x^2 + (67+191i)*x + 116-612i = 0
The exact solutions are 8 + 4i, 4 + 9i and 7 + i.

WCpzero