摘要
Excel的矩阵运算功能可以求解系数矩阵是非奇异的线性方程组,适当地设置目标函数和约束条件,Excel的规划求解功能也可以用来求解线性方程组,也可以求矩阵的秩。笔者给出Excel求解线性方程组的两种情形和求矩阵的秩情形。
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.