-------- Original Message --------
Subject: macros to derive eigenvalues/eigenvectors in Excel? -- Poptools
Jacobi
Date: Fri, 13 Mar 2009 09:57:34 -0700 (PDT)
From: Thomas DeWitt <[email protected]>
To: <[email protected]>
Brian,
Poptools (Google it for download site) is a great way to go.
For general square (e.g. covariance) matrices use the "Jacobi" function
rather than "Eigs".
Jacobi writes eigenvectors of unit length.
Poptools also does SVD and many other useful things like resampling.
If you would like some demo spreadsheets I can send privately.
I base my entire graduate Biometry course on Excel with Poptools.
-Thom DeWitt
>=))))(º> >=))))(º> >=))))(º> {|||||}º>
^ ^ L L L L
Dr. Thomas J. DeWitt, Associate Professor
Departments of Wildlife & Fisheries Sciences
and Plant Pathology & Microbiology
Interdisciplinary Research Program in Ecology & Evolutionary Biology
Texas A&M University
2258 TAMU
College Station, TX 77843-2258
Tel. (979) 458-1684 (office)
Tel. (979) 845-7522 (lab)
Fax (979) 845-4096
E-mail [email protected]
Web http://wfsc.tamu.edu/faculty/tdewitt/webpage.htm
TAMU Map to DeWitt lab & office:
http://www.tamu.edu/map/gifs/detail/FGHB.gif
morphmet <[email protected]> 03/13/09 11:46 AM
-------- Original Message --------
Subject: any macros to derive eigenvalues/eigenvectors in Excel?
Date: Fri, 13 Mar 2009 09:25:06 -0700 (PDT)
From: Brian Villmoare <[email protected]>
To: [email protected]
Hi - I was just wondering if there were any macros that anyone has seen
that can determine the eigenvalues and eigenvectors for a matrix in
Excel. It seems like it would be very useful for calculating
multivariate stats in Excel. Or, maybe some small stand-alone program?
Thanks!
Brian
--
Replies will be sent to the list.
For more information visit http://www.morphometrics.org
--
Replies will be sent to the list.
For more information visit http://www.morphometrics.org
