用Excel VBA进行矩阵特征值的数值计算

Computation of Matrix Eigenvalues by VBA in Excel

为了在未安装数学计算软件或编程软件的计算机上进行较复杂的矩阵计算,利用常用办公软件Office中的Excel便于矩阵输入和显示的特点,结合Excel中内嵌的VBA可编程功能,编写了计算实对称矩阵特征值的隐式移位QR算法的VBA宏代码,给出了Excel中利用该宏代码进行特征值计算的具体操作步骤,并得到了很好的计算结果。VBA宏代码和Excel的计算操作步骤都不复杂冗长,这是一条在缺乏专用软件时进行矩阵数值计算的可行途径。

In order to perform the complicated matrix computations without any numerical computing software or programming language compilers, the characters of convenient matrices entering and showing in Excel was used. With programming capability by VBA embedded in Excel, the VBA Macro programs to compute the eigenvalues of real symmetric matrix were proposed. The relative Excel operating steps were provided with good results in practice. As both VBA Macros and the relative operations of Excel were simple and short, it was shown that temporary matrix computations with no special software could be performed with Office software.