hi, I have to get an inverse matrix of a square matrix (20*20) on excel , to make sure that calculation is right I Knew that multiplying the matrix with its inverse should yields a unity matrix which have a diagonal of ones and other cells are zeros but when i multiply the matrix with the inverse i got the result is a matrix with adiagonal of ones but not all other cells are zeros (some have values like 1,2,etc ... is this ok or what often is my mistake? thanks in advance
I used the available Minverse function in excel , should i insert a manual function? and what should it be?
To Manal Lotfy: I will suggest to try to solve your example in another program. For example, you may try Wolfram|Alpha (a computational knowledge engine):
https://www.wolframalpha.com/examples/mathematics/algebra/matrices/
If you are using MINVERSE, the result should be right. How do you multiply the matrices together? With MMULT? Otherwise, you might accidentally get an entry-wise product, and then the check obviously would fail.
- Badges
- Science topic
- Similar topics
- Mathematics