| 用 Excel 解线性方程组 |
| |
| 引用本文： | 黄明新. 用 Excel 解线性方程组[J]. 重庆工商大学学报(自然科学版), 1998, 0(4) |
| |
| 作者姓名： | 黄明新 |
| |
| 作者单位： | 渝州大学基础部 |
| |
| 摘 要： | Ｅｘｃｅｌ的矩阵运算功能可以求解系数矩阵是非奇异的线性方程组，适当地设置目标函数和约束条件，Ｅｘｃｅｌ的规划求解功能也可以用来求解线性方程组，也可以求矩阵的秩。笔者给出Ｅｘｃｅｌ求解线性方程组的两种情形和求矩阵的秩情形。
|
| 关 键 词： | Excel；矩阵运算；规划求解；秩 |
Solving the Set of Linear Equations by Using Microsoft Excel |
| |
| Huang Mingxin. Solving the Set of Linear Equations by Using Microsoft Excel[J]. Journal of Chongqing Technology and Business University:Natural Science Edition, 1998, 0(4) |
| |
| Authors: | Huang Mingxin |
| |
| Abstract: | The set of linear equations with an irrigular coefficient matrix is solved by using the function about matrix operations in Microsoft Excel,the programming function in Microsoft Excel can also be used to solve the linear equations and find the rank of a matrix. |
| |
| Keywords: | Excel matrix operations programming function rank |
| 本文献已被 CNKI 等数据库收录！ |
| 点击此处可从《重庆工商大学学报(自然科学版)》浏览原始摘要信息 |
|
点击此处可从《重庆工商大学学报(自然科学版)》下载全文 |
