View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dare Dare is offline
external usenet poster
 
Posts: 2
Default solving a matrix in Excel


reference of root:
(1,-1,1,-1,1,-1,1,-2)*X-1=0

below the data is 9 elements long per row, with the last element of the
row the augment of the matrix:

row 1:
-0.87618856 -0.287065453 -0.013432611 0.091462494 -0.013432611 0.0914624
94 -0.013432611 0.093827036 -0.090909091

row 2:
-0.287065453 -0.285522631 0.136657108 -0.147725177 0.136657108 -0.147725
177 0.136657108 -0.148060573 0.090909091

row 3:
-0.013432611 0.136657108 -0.77085744 0.12890946 0.22914256 0.12890946 0.
22914256 0.139759521 -0.090909091

row 4:
0.104037807 -0.147725177 0.12890946 -0.847780517 0.12890946 0.152219483
0.12890946 0.160738542 0.090909091

row 5:
-0.013432611 0.136657108 0.22914256 0.12890946 -0.77085744 0.12890946 0.
22914256 0.139759521 -0.090909091

row 6:
0.091462494 -0.147725177 0.12890946 0.152219483 0.12890946 -0.847780517
0.12890946 0.160738542 0.090909091

row 7:
-0.013432611 0.136657108 0.22914256 0.12890946 0.22914256 0.12890946 -0.
77085744 0.139759521 -0.090909091

row 8:
0.093827036 -0.148060573 0.139759521 0.160738542 0.139759521 0.160738542
0.139759521 -0.830155456 0.181818182

the nature of the problem is outlined on my site at,

http://mypeoplepc.com/members/jon8338/polynomial/

Jon

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!