| 基于Excel求高次方程的解 |
| |
| 引用本文： | 彭海静.基于Excel求高次方程的解[J].计算机应用与软件,2006,23(2):142-144. |
| |
| 作者姓名： | 彭海静 |
| |
| 作者单位： | 泰州师范高等专科学校信息科学系,江苏,泰州,225300 |
| |
| 摘 要： | 如何求解一元高次方程的根是在工程计算与数值分析中的重要问题之一。利用Excel提供的强大的数值计算功能，无需编程即可求一元高次方程的根。文中对如何确定方程所有实根所在区间进行了研究，并给出一种简便快速的方法。本文还介绍了利用Excel的单变量求解和规划求解功能求方程近似解的方法，其中规划求解功能能够求得更高精度的解。
|
| 关 键 词： | 方程求根 根的区间 单变量求解 规划求解 |
| 收稿时间： | 01 28 2005 12:00AM |
| 修稿时间： | 2005-01-28 |
THE SOLUTION OF HIGHER DEGREE EQUATION BASED ON EXCEL |
| |
| Peng Haijing.THE SOLUTION OF HIGHER DEGREE EQUATION BASED ON EXCEL[J].Computer Applications and Software,2006,23(2):142-144. |
| |
| Authors: | Peng Haijing |
| |
| Affiliation: | Department of Information Science, Taizhou Normal College, Taizhou Jiangsu 225300, China |
| |
| Abstract: | In engineering computation and numerical analysis,it is one of the key problems to obtain the roots of higher degree equation. Excel provides the strong function of numeric computations. Applying the function ,the results can be produced witl,out coding. In this paper, the author studies how to get the intervals of all the real roots, and give a easy method. Then methods using goal seek and programming in Excel to solve the equation were introduced. |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
