Gauss Seidel

Solves a set of N linear equations in N unknowns by the Gaussian-Seidel method. Returns the array of N unknowns, in column format only.

Syntax

GaussSeidel(coeff_matrix,const_vector, init_values) coeff_matrix a reference to an N row x N column array of coefficients const_vector a reference to an N row x 1 column array of constants init_values a reference to an N row x 1 column array of initial values

Remarks

• The coeff_matrix, const_vector and init_values tables can contain values or formulas.

• The optional init_values may be helpful for large arrays.

• The GaussSeidel function is an array function. You must select an N row x 1 column vertical range of cells, enter the function and then press CONTROL+SHIFT+ENTER (Windows) or COMMAND+RETURN or CONTROL+SHIFT+RETURN (Macintosh).

See Also

GaussElim, GaussJordanl, GaussJordan2, SimultEqNL

+1 0

Post a comment