摘要
Excd不但具有强大的数据分析和处理功能，而且具有丰富的函数，在数学计算中发挥着不客忽视的作用。本文主要介绍Excel在进行计算行列式值、矩阵的转置、矩阵的逆、矩阵的秩、两矩阵的乘积、矩阵的特征向量和特征值以及矩阵在进行解线性方程组时的应用。
Excel has not only powerful ability of data analyzing and dealing with,but it also has abundant functions,which play large effect on mathematical calculations.In this paper,some applications in calculations of matrix are introduced particularly,such as the calculation of range formular,the transfering of matrix,the athwart of matrix,the product of matrixes,the proper values and characteristic vectors of matrix and the applicadtion in unbinding linear equations.
出处
《电脑知识与技术》
2007年第1期12-13,47,共3页
Computer Knowledge and Technology
关键词
Excel矩阵
函数
矩阵秩
矩阵逆
Excel Matrix
Function
Order of Matrix
Athwart of Matrix
