用Excel求解迭代问题  

Iteration solving for non-linear equation by Excel

作　　者：郑立辉[1] 范国枝[1] 韦一良[1] 宋光森[1] 

机构地区：[1]武汉工业学院化工系,湖北武汉430023

出　　处：《计算机与应用化学》2008年第11期1429-1431,共3页Computers and Applied Chemistry

基　　金：建设部科学研究项目(06-K7-7);湖北省科技攻关项目(2006AA101C23).

摘　　要：现有软件在求解迭代问题时,存在不同缺陷。根据Excel的特点,作者使用其公式和复制功能,介绍求解非线性方程迭代问题数值解的方法,该方法将Excel的公式和复制功能、加速迭代方法与人的思维能力结合起来,能快速、方便、准确地求解迭代问题,不需要编写程序,结合实例详细介绍其操作步骤。Iteration evaluation has not been satisfactorily settled by software present. Based on the filling handle of Excel, the solution to iteration by Excel was given in this article. Filling handle of Excel, accelerating iteration and human thinking are integrated into the method, which is accurate and efficient. The procedure of calculation is described in detail by examples in chemistry and chemical engineering calculation. No programming is required.

关 键 词：EXCEL 迭代求解 非线性方程 数值 准确 步骤 

分 类 号：TQ015.9[化学工程] TP301.6[自动化与计算机技术—计算机系统结构]