Results 1 to 7 of 7

Calculating Eigenvalues and Eigenvectors in Excel

This is a discussion on Calculating Eigenvalues and Eigenvectors in Excel within the Excel Questions forums, part of the Question Forums category; Hi everyone, I need a macro that returns the Eigenvalues and Eingenvectors of a regular matrix. I would like to ...

  1. #1
    Board Regular
    Join Date
    Sep 2008
    Location
    Cape Town, South-Africa
    Posts
    303

    Default Calculating Eigenvalues and Eigenvectors in Excel

    Hi everyone,
    I need a macro that returns the Eigenvalues and Eingenvectors of a regular matrix. I would like to use vba and write a procedure but I need some pointers first. Does anybody know where I can find spreadsheet based step by step calculations to find Eigenvalues/Eigenvectors from time series? Or, alternatively, has anybody dealt with this before and written a macro already? Lastly, is there an excel add-in that calculates these vectors? Any help on the matter is greatly appreciated
    Regards
    Florian

    'Ich habe fertig!'

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    70,341

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    I suggest you Google for "Eigenvalues excel". You will get lots of hits.
    Microsoft MVP - Excel

  3. #3
    Board Regular
    Join Date
    Sep 2008
    Location
    Cape Town, South-Africa
    Posts
    303

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    In know it's a nuisance when people try to circumvene doing their own internet research but I've already extensively searched the net for model answers. Unfortunately, I could not really find an excel/VBA-based implementation. Should anybody have any promising leads it would be great
    Regards
    Florian

    'Ich habe fertig!'

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    70,341

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    Microsoft MVP - Excel

  5. #5
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    66,269

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    Florian

    I really think you should look for yourself.

    There are plenty of resources out there, take a look for the add-in 'Matrix.xla'.

    And which one to use would really be up to yourself based on your actual needs.

    It's been some time (school/uni) since I've worked with eigenvalues etc but I took a look at some of the articles I found when googled.

    Talk about over my head - whoosh!!!!
    If posting code please use code tags.

  6. #6
    Board Regular
    Join Date
    Sep 2008
    Location
    Cape Town, South-Africa
    Posts
    303

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    Following up on my on post
    I have found the extremely powerful add-in matrix.xla. The package includes absolutely everything you could possibly want to manipulate and calculate when it comes to vectors and matrices. And the best part is, it is absolutel 100% free-ware. And the cherry on top of the cherry is that the VBA code is accessible. One word of caution, though, the website below states explicitly that the macros were configured to run on pre-Vista Windows versions in conjunction with Excel 2003. So far, the installation and all applications that I have tried out worked absolutely fine in Excel 2007 (yes, I also have the world's most annoying operating system!). And since the code is accessible you may select and manipulate as much as you like should there be any compatitbility issues. I hope those guys come up with a green-lighted Excel2007 version soon. In the mean-time I provide the link to their download site (their are plenty of other powerful tools as well):

    http://digilander.libero.it/foxes/SoftwareDownload.htm
    Regards
    Florian

    'Ich habe fertig!'

  7. #7
    Board Regular
    Join Date
    Sep 2008
    Location
    Cape Town, South-Africa
    Posts
    303

    Default Re: Calculating Eigenvalues and Eigenvectors in Excel

    p.s. thanks for the link, Andrew, I recommend this to anybody who needs to calculate Eigenvectors and Eigenvalues for regular matrices (it is simple and works with the pre-installed goalseek feature)
    Regards
    Florian

    'Ich habe fertig!'

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com