The application of excel in solving linear equations and nonlinear equation

Abstract-Solutions to linear equations and nonlinear equation are not only the main teaching contents of the course Computer Method , but also widely applied in engineering. It´s difficult for non-computer major students to program and understand abstract theoretical explanations of mathematics. During the teaching process, the author finds out that it´s vivid, intuitive and understandable to use Excel to solve linear equations and nonlinear equation. Taking equations 10X₁-X₂-2X₃=7.2, -X₁+10X₂-2X₃=8.3, -X₁-X₂+5X₃=4.2 and x³+2x²-16x-20=0 as instance, the author of this paper respectively explains the solution process of Jacobi iteration method, Seidel iteration method by Excel linear equations , and the solution process of Progressive scanning method , Newton iteration method, Interpolation method and Two-point chord cutting method by Excel nonlinear equation as well.