6 1 6-6 41 -2 -3 Let A = Calculate the inverse of A using Excel. (Entries are ro

Question

6 1 6-6 41 -2 -3 Let A = Calculate the inverse of A using Excel. (Entries are rounded to two decimal places.) 0.010.29-0.17 0.05 0.2 -0.91 0.87 0.38 0.08-0.23 0.05 0.05 0.11 -0 0.02 0.16 a) 0.01 0.2 0.12 0.04 1-0.13 1.05 -0.33 0.74 0.09-0.05 -0.06 0.08 0.09 0.32 -0.23 0.24 b) 0.02 0.1 0.08 0.04 1 0.2 -1.07 0.54 0.77 0.13 -0.29 0.04 0.08 0.02 -0.37 0.05 0.25 c) 0.010.14-0.09 0.03 0.18 -0.19 0.42 0.51 0.08-0.19 0.03 0.06 0.11 -0.08 0.01 0.17 d) 0.03 0.1 0 0.13 e) 1-0.13 -0.140.31 0.37 0.13-0.14 -0.09 -0.09 0.09 -0.06 -0.04 0.11

Explanation / Answer

Matrix A 6 1 6 -6 4 1 -2 -3 -3 2 -2 -5 6 1 3 1 A-1           0.01           0.14         (0.09)           0.03         (0.18)         (0.19)           0.42           0.51 Ans is D           0.08         (0.19)           0.03           0.06         (0.11)         (0.08)           0.01           0.17 Steps of Inverse Matrix using excel Just type the matrix as shown in excel Select the array of blank cells corresponding to order of matrix Put the formula '=Minverse(Array values) for example =Minverse(C4: F7) along with press shift + CTRL and ENTER Result will be as given above.

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.