摘要
利用Excel中矩阵函数的强大的数据处理功能,用矩阵逆函数MINVERSE,克拉默法则,规化求解命令,和EXCEL中的IF函数和行列式值MDETERM函数四种方法,均可以方便的求出方程组的解。本文通过两个实例对上述方法做了详细介绍,并给出了题解图例。
Matrix function using Excel,a powerful data processing capabilities,with the matrix inverse function MINVERSE,cramer rule,regulation methods for solving a command,and EXCEL in the function and the determinant of four methods MDETERM function,can easily find the equation solutions group.In this paper, above two examples described in details,and gives the problem solution legend.
出处
《计算机光盘软件与应用》
2010年第14期40-41,共2页
Computer CD Software and Application