摘要
文章探讨了利用Excel求解线性方程组和非线性方程数值解法,详细演示了利用Excel求解线性方程组的Gauss消去法,Gauss-seidel迭代法,Excel函数法,Excel的"规划求解"方法,以及求解非线性方程的操作过程。
This paper discuss about using Excel tools for numerically solving linear and nonlinear equations. We explain in detail about how to solve linear and nonlinear equations by Excel with illustrated examples on the Gauss elimination method, Gauss-Seidel iterative method, methods based on Excel functions and Programming methods in Excel.
出处
《电脑与信息技术》
2008年第5期38-40,共3页
Computer and Information Technology
基金
北京市属"人才强教"中青年骨干教师科研项目