Not returning correct Matrix Calculation

04282021, 05:25 AM
Post: #5




RE: Not returning correct Matrix Calculation
(04272021 10:56 PM)Albert Chan Wrote:(04272021 08:20 PM)Amer7 Wrote: I guess something is wrong in Excel ( all formulas seemed ok). I have found the Issue, Im not sure why this happens. When number in column F have in front of them  ( minus, aka they are negative) Inverse matrix is not going to be the same as in Excel. So when I input O matrix as all positive numbers I get inverse matrix correct. And in last matrix calculation ( excel uses formula example (trn(A)*N) + O and when I adjust this to (trn(A)*N)  O I get everything correct. I'm not sure why this difference is happening between calculator and Excel. Downloaded a virtual TI Nspire to check, they also get the same Matrix as we on our HP Prime. So its something querk of Excel. 

« Next Oldest  Next Newest »

Messages In This Thread 
Not returning correct Matrix Calculation  Amer7  04272021, 06:47 PM
RE: Not returning correct Matrix Calculation  Albert Chan  04272021, 08:09 PM
RE: Not returning correct Matrix Calculation  Amer7  04272021, 08:20 PM
RE: Not returning correct Matrix Calculation  Albert Chan  04272021, 10:56 PM
RE: Not returning correct Matrix Calculation  Amer7  04282021 05:25 AM

User(s) browsing this thread: 1 Guest(s)