Recommendation of matrix

Let's think about the following 3-D simultaneous equations. （The variable is x _{1}, x_{2}, x_{3})5x _{1} + 3x_{2} + x_{3} = 34x _{1} + 5x_{2} + 2x_{3} = 4x _{1} + 3x_{2} + 6x_{3} = 6When I transcribe it in a matrix. It is extremely easy when written by a matrix A ×x = b |

Solution of simultaneous equations

The simultaneous equations can be written by the following matrix equation Ax = bDo multiplication a inverse-matrix A in both sides. ^{-1}A^{-1}( A x ) = A^{-1}b( A^{-1}A ) x = A^{-1}b From A^{-}^{1}A = E E x = A^{-1}bx = A^{-1}bSolution x calculates in this. |

The simultaneous equations is solved with EXCEL

(1) Input of matrix (

The matrix and the vector area are secured for an arbitrary cell, and the value is input. |

(2) Calculation of inverse-matrix (

Select the inverse-matrix A^{-1} erea in an arbitrary position. . And set the Function MINVERSE (matrix A) . Note) When you set the function to two or more areas The OK button is not pushed. Enter is ended by the key input while pushing the Ctrl Shift key. The inverse-matrix calculated in this. |

(3)Calculation of inverse-matrix

Set a solution(x) earea in an arbitrary position. When you set the Function MMULT( Reverse-matrix( A), Vector(^{-1}))bSolution ( x ) However, it is round. the solution of the simultaneous equations was obtained. It is easy |

(4) Checking answer

Obtained solution (x) is used. Ax Calculation, and the value agreement with . bResult of checking answer and vector are
corresponding. bIt is happy, and happy. |

Science and technology calculation with EXCEL

〒673-0036 Japan Hyogo Prefecture Akeshi City Matsue 62-14

God foot co Ltd

Please let me hear the impression