Matrix Multiplication and Inverse in Excel

How to multiply matrices using MS Excel

Finding the inverse of a matrix using Excel

Using the mmult, mdeterm and minverse commands in excel.

Category:

Education

Tags:

• Matrix
• Matrices
• Matrix Multiplication
• Matrix Inverse
• Matrix Excel
• Mmult
• MDeterm
• MInverse

[luismata8]

How would you do A^n ? for n= 1 to 20

[hifhif123]

@luismata8 Not sure it can be done. Only way I can think of is repeated multiplication with nested mmults...

I know this isn't ideal.

[112358d15]

ok, I know you can do matrix manipulations in excel, but why would you?

If you want software which comes in a nice shiny package use: MatLab, Maple, or Mathematica.

If you want software which is free use: Octave, Maxima, or PyLab

Spreadsheets in general and excel in particular are over-rated and over-used, the time you spend learning a proper piece of mathematical software will pay off, and quicker than you expect.

[hifhif123]

@112358d15 I do agree with most of what you say, I use Mathematica quite a lot myself. But not everyone knows how to use most math software, so it does help to know a few commands in excel, at least to check your answers. May be excel is over rated, but it isn't completely useless.

By the way, Mathematica 8 was out yesterday!!!

[Abitofwine]

Thanks for the help!

[collegeboy360]

genius man, genius.

[Abolwafa27]

such informative!

thank you very much

[navylaks2]

what about row and columb reduction?

[ryukenlmaoyes]

cheers, you sound like my lecturer which is kinda scary lol and no im not gonna tell you where i go to uni

[MartyCooley]

Thanks, good video

[Sozz541]

thanks for the help...:-D

[lovelyclover111]

I did it, thank you so much :)

[luismata8]

How would you do A^n ? for n= 1 to 20

[tabishfuhrer]

fantastic man thanks i didnt know u could do it like that Again thanks man!!!!!!!!

wonderful outstanding