摘要
迭代算法是指利用计算机反复执行同一个模式的运算,并结合变量因素,实现对最终值的明确。迭代算法是一种线性的函数计算模式,基于不同的运算方式,可以将其分为雅克比迭代、二分法迭代、牛顿迭代等,基于此方程在Excel中的应用,不需要软件便可直观展现计算最终数值。笔者基于迭代算法在Excel中的应用,阐述了迭代算法应用的要点和原理,并对不同迭代算法的应用进行了分析,具有重要借鉴价值。
Iterative algorithm refers to the use of computers to repeatedly perform the same mode of operation,and combined with variable factors,to achieve a clear final value.Iterative algorithm is a linear function calculation model.Based on different operation modes,it can be divided into Jacobian iteration,dichotomy iteration,Newton iteration and so on.Based on the application of this equation in Excel,the final value of calculation can be visually displayed without software.Based on the application of iteration algorithm in Excel,this paper expounds the main points and principles of the application of iteration algorithm,and analyses the application of different iteration algorithm,which has important reference value.
作者
杜宗飞
Du Zongfei(Tongxiang No.1 Middle School, Jiaxing Zhejiang 314500, China)
出处
《信息与电脑》
2019年第1期73-74,共2页
Information & Computer
