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

The next big software update for iPhone is coming sometime in April and will include a Food section in Apple News+, an easy-to-miss new Ambient Music app, Priority Notifications thanks to Apple Intelligence, and updates to apps like Mail, Photos, Podcasts, and Safari. See what else is coming to your iPhone with the iOS 18.4 update.
Comments
Be the first, drop a comment!