摘要
数值分析作为理工科的一门核心基础课程,不仅是我们今后学习有关计算机应用知识中不可缺少的数学工具,也是工程理论和处理离散结构所必须的描述工具和方法。随着计算机的普及,办公软件中的Excel工具得到了广泛地应用。由于其具有数据处理功能强大、操作方便、学习容易等优点,不仅适合制作各种企业报表和数据统计图表,而且为数值分析中繁琐的数值计算提供了一种有力的手段。本文应用Excel解决数值分析中诸如求解线性方程组、拟合、方程求根等一系列问题。
The numerical analysis,which is a sciences and engineering＇s core curriculum,not only is the essen-tial mathematical tool that we study the knowledge about computer application later with,but also is the essen-tial description tool and method that is for project theory and processing the separate structure with. With the popularization of computer,Excellas one of the office software tool has been widely used. Because of its the da-ta processing function to be formidable,the ease of operation,studying easily,it not only suits making all kinds of enterprise report form and the data statistical graph,but also provides a powerful method for the tedious nu-merical calculus of numerical analysis. In this paper,Excellcan be used for solving linear equations,the fitting, the numerical differentiation and so on.
出处
《东北电力大学学报》
2013年第5期69-72,共4页
Journal of Northeast Electric Power University
关键词
EXCEL
拟和
迭代
初值问题
方程求根
Excel
Fitting
The iteration
The initial-value problem
Extract the roots of equation
