🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: sci.math.stat
Article #874

Help: Eigen routines for spreadsheet

#874
From: Hyram Ballard
Date: Tue, 12 Jan 1993 21:59
12 lines
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!glgyhrb

Show 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