Thread: Matrix Algebra
View Single Post
 
Old 10-11-2011, 04:30 PM
judicial85 judicial85 is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default Matrix Algebra

Good evening!

I've come across some matrix problems, as I am currently dealing with some physics work in my field.

I have a variety of real-number 3x3 matricies that I would need to diagonalize, which can take a lot of scribbling time with scrap paper.
(i.e. Any square matrix A = PDP^-1) Is there a way I can get excel to produce the eigenvalues for me? Ideally I would have a function where I could input the 3x3 array and it would produce the diagonal elements for me.

Thanks! Bryan
Reply With Quote