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
No comments:
Post a Comment