Article View: sci.math.stat
Article #874Help: Eigen routines for spreadsheet
From: Hyram Ballard
Date: Tue, 12 Jan 1993 21:59
Date: Tue, 12 Jan 1993 21:59
12 lines
1087 bytes
1087 bytes
Please accept my humble incursion into this group but I could use some help on extracting eigenvalues and eigenvectors from symmetric matrices using a spreadsheet. I have produced a multiple discriminant analysis model in Excel which calculates the variance sum of squares matrices but to complete the analysis I have to take the matrix into MatLabII to get the eigens. Although this is no real problem it is a bit in-elegant and I would like to be able to do the whole analysis within one application. If you have or know of any spreadsheet routines or references to procedures suited to a spreadsheet environment I would be very grateful if you could pass them on or point me in the right direction. Thank you for your help, Hyram Ballard
Technical Details
Message-ID:
<1993Jan13.105921.509@otago.ac.nz>Path:
arc1-ca.pugleaf.net!sparky!uunet!comp.vuw.ac.nz!canterbury.ac.nz!otago.ac.nz!glgyhrbShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!comp.vuw.ac.nz!canterbury.ac.nz!otago.ac.nz!glgyhrb From: glgyhrb@otago.ac.nz (Hyram Ballard) Newsgroups: sci.math.stat Subject: Help: Eigen routines for spreadsheet Message-ID: <1993Jan13.105921.509@otago.ac.nz> Date: 13 Jan 93 10:59:21 +1300 Organization: Dept. of Geology, Univ. of Otago, NZ Lines: 12