How to Make a 3x3 Matrix in Excel

Save

Making a 3-by-3 matrix in Microsoft Excel is in fact very simple. You need only write numbers in each cell of any 3-by-3 block of cells. What has led to so much confusion regarding matrices in Excel is their functionality. A 3-by-3 matrix by itself provides no use unless you can either multiply it by another matrix, find its inverse or use it to solve a system of equations -- all three of which are possible in Excel.

Multiply Two Matrices

  • Type two matrices in 3-by-3 cell blocks anywhere on the sheet. The matrices need not be adjacent.

  • Highlight an empty 3-by-3 block of cells and press the "F2" key.

  • Press the "=" key on your keyboard and type "MMULT(."

  • Highlight all the cells containing the first matrix; type a comma and highlight all the cells containing the second matrix. Type ")."

  • Press and hold down the "Ctrl" and "Shift" keys, and then press the "Enter" key to finalize the calculation and make the resulting product matrix appear in the 3-by-3 block of cells you highlighted.

Find Matrix Inverse

  • Enter numbers in any 3-by-3 cell block. No more than one row may contain cells in which the numbers are the same.

  • Highlight an empty 3-by-3 block of cells and press the "F2" key.

  • Press the "=" key on your keyboard and type "MINVERSE(."

  • Highlight all the cells containing the original matrix and type ")."

  • Press and hold down the "Ctrl" and "Shift" keys, and then press the "Enter" key to make the inverse of the initial matrix appear in the empty 3-by-3 block of cells.

Solve System of Equations

  • Write the equations in the system of equations you're trying to solve in the form of x + y + z = c. You can write it on a piece of paper or in your computer's notepad. You need the coefficients to build the required matrices. This is an example:
    x + y + z = 10
    2x + 2y + 2z = 20
    3x + 3y + 3z = 30

  • Fill a 3-by-1 cell block with the numbers to the right of the equation: 10, 20 and 30.

  • Setup a 3-by-3 cell block matrix by using the coefficients to the left of the equation. Type
    1, 1 and 1 in the first row; 2, 2 and 2 in the second; 3, 3 and 3 in the third.

  • Highlight an empty 3-by-1 block of cells and press the "F2" key.

  • Press the "=" key on your keyboard and type "MMULT(MINVERSE(."

  • Click all the cells in the 3-by-3 block. Type ")." Type a comma and highlight all the cells containing the 3-by-1 matrix. Type another closed bracket.

  • Press and hold down the "Ctrl" and "Shift" keys, and then press the "Enter" key to make the values for x, y and z appear in the 3-by-1 block of cells you selected.

Tips & Warnings

  • Highlight multiple cells by clicking the first cell, holding down the "Shift" key and clicking the last cell.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!