Question

Matrix Inversion in Excel To compute the inverse of a matrix, say matrix G, please note that this operation is only valid for square matrices with non-zero determinants. The inverse matrix of G is denoted as $G^{-1}$. So $G \times G^{-1} = I$ or $G^{-1} \times G = I$, where I is the identity matrix. In Excel, there is a quick way find the inverse of a matrix, simply use the MINVERSE function, as =MINVERSE(). Example $\begin{pmatrix} -1 & 5 & -1 \ -2 & 11 & 7 \ 1 & -5 & 2 \end{pmatrix}$ , use Excel to find its inverse its inverse $G^{-1}$ Solution: Step 1 Enter the values for matrix G into the cells. Step 2 • Highlight all the cells from B7 to D9. • Type =MINVERSE(B2:D4) • Type Ctrl+Shift+Enter at the same time. Otherwise, you will only get a part of the answer.

          Matrix Inversion in Excel
To compute the inverse of a matrix, say matrix G, please note that this operation is
only valid for square matrices with non-zero determinants.
The inverse matrix of G is denoted as $G^{-1}$. So $G \times G^{-1} = I$ or $G^{-1} \times G = I$, where I is the
identity matrix.
In Excel, there is a quick way find the inverse of a matrix, simply use the MINVERSE
function, as =MINVERSE().
Example
$\begin{pmatrix} -1 & 5 & -1 \ -2 & 11 & 7 \ 1 & -5 & 2 \end{pmatrix}$ , use Excel to find its inverse its inverse $G^{-1}$
Solution:
Step 1
Enter the values for matrix G
into the cells.
Step 2
• Highlight all the cells from
B7 to D9.
• Type =MINVERSE(B2:D4)
• Type Ctrl+Shift+Enter at
the same time. Otherwise,
you will only get a part of
the answer.

Matrix Inversion in Excel
To compute the inverse of a matrix, say matrix G, please note that this operation is
only valid for square matrices with non-zero determinants.
The inverse matrix of G is denoted as G^-1. So G × G^-1 = I or G^-1× G = I, where I is the
identity matrix.
In Excel, there is a quick way find the inverse of a matrix, simply use the MINVERSE
function, as =MINVERSE().
Example
< p m a t r i x > , use Excel to find its inverse its inverse G^-1
Solution:
Step 1
Enter the values for matrix G
into the cells.
Step 2
• Highlight all the cells from
B7 to D9.
• Type =MINVERSE(B2:D4)
• Type Ctrl+Shift+Enter at
the same time. Otherwise,
you will only get a part of
the answer.

Added by Esther V.

Question

Please give Ace some feedback