Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I solved the matrix using standard row operations. Then I used x=A^-1 *b in Excel and all I got was garbage. My first results showed virtually no error. The commands I used in Excel were, =MINVERSE(AA1:AH8) (Saved in AA11:AH18) =MMULT(AA11:AH18,AI1:AI8) (Saved in AI21:AI28) To review, the problem is to solve 8 equations for 8 unknowns. The unknowns are x[1],x[2],x[3],..,x[8] and the augmented matrix is, AA1 AB1 AC1 ... AH1 | AI1 AA2 AB2 AC2 ... AH2 | AI2 AA3 AB3 AC3 ... AH3 | AI3 .. .. AA8 AB8 AC8 ... AH8 | AI8 What did I do wrong? Jon *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solving Sudoku using Excel | Excel Discussion (Misc queries) | |||
Solving Sudoku with EXCEL | Excel Worksheet Functions | |||
Mathematic problem solving using Excel | Excel Worksheet Functions | |||
solving equations using Excel | Excel Discussion (Misc queries) | |||
i've got a simple excel problem that needs solving... | Excel Discussion (Misc queries) |