This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of A matrix give there a formula of =mdeterm(select A matrix). Nest hit enter. You will get determinant of A. Next if you want to find the A inverse give there a formula of =minverse(select the matrix A) and press cntl+shft+enter. You will get the inverse. If you want to multiply three matrices at a time then you have to give this formula. That is =mmult(select the A matrix, select the B matrix). It will multiply AxB. So next give a formula that =mmult(mmult(matrix A selection, B selection), (matrix c selection) ). Then you will get AxBxC. You have a option to select AxB matrix and then C matrix to get AxBxC matrix. So that is the formula to do matrix in excel.
Home
Microsoft Office How to Do matrix multiplication and inverse in MS Excel
By Sean Conaty
May 3, 2010 01:18 PM
Just updated your iPhone? You'll find new Apple Intelligence capabilities, sudoku puzzles, Camera Control enhancements, volume control limits, layered Voice Memo recordings, and other useful features. Find out what's new and changed on your iPhone with the iOS 18.2 update.
Comments
No Comments Exist
Be the first, drop a comment!