Skip to main content
P
PhilipLeitch1-Visitor
1-Visitor
January 3, 2010
Question

How to generate Eigenvalues

  • January 3, 2010
  • 2 replies
  • 6745 views
Hi.

I have a worksheet I'm attempting to translate into SQL (Structured Query Language), specifically Transact-SQL (Microsoft SQL Server language).

Currently the only stumbling block is that I need to generate Eigenvalues.

Are there standard algorithms that I can use, or is this so complicated that I should just pay for an external Maths library?

Thanks,
Philip
___________________
Nobody can hear you scream in Euclidean space.

2 replies

P
ptc-13682881-Visitor
1-Visitor
January 4, 2010
The maths of the "Eigenvalues" are given in Mathcad.

jmG
S
SteenGroðe10-Marble
10-Marble
January 4, 2010
Try eigenvals ... and if you also want the vectors eigenvec given one of the eigenvals.

Steen Gro�e
N
Ninetrees3-Newcomer
3-Newcomer
January 5, 2010
Yes, this shouldn't be a necessary step...

From M14020 Help - eigenvecs(M, ["L"])
"The nth column of the matrix returned is an eigenvector corresponding to the nth eigenvalue returned by eigenvals."

I seem to recall a problem with this in the past, i.e., the eigenvalues and vectors were not in the same order. Perhaps this was fixed in M14?

I always check now...

Rich
http://www.downeastengineering.com/
A
AlvaroDíaz12-Amethyst
12-Amethyst
January 4, 2010
In the attached excel file you can found a macro to compute the eigenvalues if they are reals; that because I don't like to use complexes with excel (using macros or any other cheat), and is one of the most important argument to reject excel.

The only one excel vba function dependence is mmult, the product of arrays, so hope that can be translated to any other language.

Regards. Alvaro.
Terms & ConditionsCookie settingsAccessibility statement