用Excel求解线性方程组

Conducting linear equation groups with Excel

借助Excel中的函数功能,通过实例介绍了用Excel求解线性方程组的具体方法.首先在Excel中输入系数矩阵,并判断线性方程组是否有解,然后求出系数矩阵的逆矩阵,最后求出线性方程组的解.该方法避免了繁琐的手工运算,使求解线性方程组变得轻松和快捷.

With the help of the function in Excel, some specific approaches to the solution of linear equation groups by means of Excel are illustrated. Firstly, the coefficient matrix is put into Excel so as to see the possible solution to the linear equation groups ; then the reciprocal matrix of the coefficient matrix is obtained ; lastly the solution to the linear equation group is gotten. All in all, the approach makes it easy and quick to conduct linear equation groups for its avoidance of the complicated manual calculation.