迭代算法在Excel中的实现探究
|
摘要
迭代算法是指利用计算机反复执行同一个模式的运算,并结合变量因素,实现对最终值的明确。迭代算法是一种线性的函数计算模式,基于不同的运算方式,可以将其分为雅克比迭代、二分法迭代、牛顿迭代等,基于此方程在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.
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.
引文
[1]张现东,卜昆,董一巍,等.基于迭代算法的复杂曲面零件三坐标测量快速精确定位方法[J].航空动力学报,2018,33(10):2525-2532.
[2]曹海燕,周冬,许方敏,等.大规模MIMO系统中基于权重二对角迭代的低复杂度预编码[J].电信科学,2018,34(9):63-69.
[2]曹海燕,周冬,许方敏,等.大规模MIMO系统中基于权重二对角迭代的低复杂度预编码[J].电信科学,2018,34(9):63-69.