 

Finding Eigen Value of Symmetric matrix Using Microsoft Excel Share this: Google+ Eigen value is very important for many applications in Science and Engineering such as solution to linear and nonlinear differential equations, boundary value problem, chaos theory, discrete dynamical system, Markov chain, network analysis, Population growth model, are just a few applications to mentions. Eigen value of symmetric matrix appears to be very useful for many practical problems. Many statistical and decisionmaking tools such as multidimensional scaling (MDS) and Principle component Analysis (PCA) are rely heavily on the finding of Eigen value of symmetric matrix of covariance or correlation matrix. Many people believe that finding Eigen value is very difficult problem. In this tutorial, we will learn an easy way to find Eigen value of a symmetric matrix using MS Excel Goal seeks. In principle, finding Eigen value is the same problem as finding a root of polynomial equation. Symmetric matrix has special properties that the Eigen values are always real number (not complex number). That is why we can easily solve using MS excel Goal seeks. You can use the procedure below to find the Eigen value of any square matrix, but some of the complex Eigen value may never be found. Click here for explanation on how to get symmetric matrix from any matrix. Suppose we have a symmetric , and we want to find the Eigen value of it. The procedure is back to the definition of Eigen value as the root of characteristic equation , where is identity matrix and is the Eigen vector of matrix . The characteristic equation can be solved if the determinant of the first term is equal to zero, or . This is exactly what we are going to do in the following steps to find the Eigen value of symmetric matrix . You may download the spreadsheet in here.
Check this blog for your possible problem
See also:
Send your comments, questions and suggestions
Preferable reference for this tutorial is Teknomo, Kardi. Finding Eigen Value of Symmetric matrix Using Microsoft Excel. http:\\people.revoledu.com\kardi\ tutorial\Excel\EigenValue.html


© 2006 Kardi Teknomo. All Rights Reserved. Designed by CNV Media 