Wednesday 29 July 2009

Matrix multiplication

Microsoft excel provides a function for matrix multiplication. Matrix multiplication process in microsoft excel accordance with the rules of the matrix. As with addition and pegurangan matrix. In our matrix multiplication is also doing an array of product from range of data. we will try to multiply two matrix (3x3 order)

1. Create a matrix as below (only accecories bracket, can be ignored)




2. Block range to put the product (adjusted order to the matrix results)
notes:
Order the product matrix = (mxn) (mxn) = (nxm)



3. Type the formula:
=MMULT(A4:C6,E4:G6)



Perform array by pressing the key combination Ctrl + Shift + Enter

4. The result will look like the image below




Related Posts by Categories



No comments:

Post a Comment

Random Posts