SOLVING LINEAR EQUATIONS AND NONLINEAR EQUATION IN APPLICATION OF EXCEL
Keywords:
Excel; linear equations; 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 10X1-X2-2X3=7.2, -X1+10X2-2X3=8.3, -X1-X2+5X3=4.2 and x3+2x2-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.
References
Yang Tao, Wang Airu, Wang Zenghui. Computational Method [M].
China Waterpower Press .2005
Cao Shuguo.The Application of Excel in Solving Nonlinear Equation [J].Technology of Computer and Information.2005
Wang Nengchao. Simple Tutorial of Computational Method [M].
Higher Education Press.2004
Jin Yiqing, Chen Yue. Numerical Methods [M]. China Machine Press.2000
Wang Guihong, Jiang Lanling. Base of College Computer [M]. China Agricultural Press.2008
