-------- Original Message -------- Subject: Re: macros to derive eigenvalues/eigenvectors in Excel? -- Poptools Jacobi Date: Fri, 13 Mar 2009 13:15:37 -0700 (PDT) From: Brian Villmoare <[email protected]> To: [email protected] References: <[email protected]> thanks!! that sounds great - it is for a class I am teaching as well. On Fri, Mar 13, 2009 at 5:17 PM, morphmet <[email protected] <mailto:[email protected]>> wrote: -------- 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] <mailto:[email protected]>> To: <[email protected] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[email protected]>> To: [email protected] <mailto:[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 -- Replies will be sent to the list. For more information visit http://www.morphometrics.org
