Matrix functions in Excel

Today I introduce to you the synthesis of matrix functions in Excel 2013. The article will guide in detail the syntax and specific examples for each matrix function. Hope to help you a lot.

1. Transpose function

- Meaning: The function returns the transposition matrix of a given matrix. You notice the function is correct with matrices with the same number of rows and columns.

- Syntax: Transpose (array [n, n]) .

Where: Array is a 2-dimensional array with a row and column index of n.

- For example:

Matrix functions in Excel Picture 1

Step 1: In the cell you want to display the transposition matrix, enter the command as shown:

Matrix functions in Excel Picture 2

Step 2: Press Enter -> display the command you type False . Highlight the data area F11: G12 -> press F2 -> Ctrl + Shift + Enter .

Matrix functions in Excel Picture 3

Note: The original matrix has many rows and columns, then you highlight the corresponding data area with so many rows and columns.

2. Mdeterm function

- Meaning: The function returns the determinant of matrices.

- Syntax: Mdeterm (array [n, n]) .

Where: Array is a 2-dimensional array with a row and column index of n.

- For example:

Matrix functions in Excel Picture 4

Step 1: In the cell where you need to calculate the determinant, enter the following command:

Matrix functions in Excel Picture 5

Step 2: Press Enter, the result will be:

Matrix functions in Excel Picture 6

3. Minverse function

- Meaning: Returns the inverse matrix of the given matrix.

- Syntax: Minverse (array [n, n]) .

Where: Array is a 2-dimensional array with equal number of columns and rows.

- For example:

Matrix functions in Excel Picture 7

Step 1: In the cell you want to display the inverse matrix, enter the following command:

Matrix functions in Excel Picture 8

Step 2: Press Enter , highlight the data area C11: D12 -> press F2 -> Ctrl + Shift + Enter . The result is as shown in the picture:

Matrix functions in Excel Picture 9

4. Mmult function

- Meaning: Returns the product of 2 matrices.

- Syntax: Mmult (aray1, array2) .

Where: The number of columns of matrix 1 is equal to the number of rows of matrix 2.

- Example: Find the product of 2 matrices.

Matrix functions in Excel Picture 10

+ Step 1: In the box you want to display matrix products, enter the command as shown:

Matrix functions in Excel Picture 11

Step 2: Press Enter , highlight the data range K6: L8 -> press F2 -> Ctrl + Shift + Enter . The result is as shown below:

Matrix functions in Excel Picture 12

In this step, there is a small note in Step 2 if you highlight the number of rows and columns incorrectly, as shown in the figure:

Matrix functions in Excel Picture 13

Note: Here matrix 1 (3 rows, 3 columns) x matrix 2 (3 rows, 2 columns) => product matrix has a row index and a column index equal to matrix 2.

Good luck!