Matrix solving using Tables 11.2 and 14.2 as examples

Put Table 11.2 into an Excel spreadsheet with the top of the numerical term column (0.10) in cell C2. The matrix covers cells C2-J8. Label as shown in Table 11.2. 

Select cells B13-B19 (by, for example, selecting cell B13, holding down the Shift key and arrowing down to cell B19). 

Leave these cells selected then type—mmult(minverse(D2 J8),C2 C8) then simultaneously press Ctrl+Shift+Enter. 

Cells B13-B19 contain the solution to the matrix. Label as shown in Table 11.2. 

Subsequent problems can be solved without repeating the above steps. The Section 11.13 example problem is solved, for example, by putting 0.130, 0.143, and 0.727 into cells C2, C3, and C4, respectively. The solution appears automatically in cells B13-B19. 

---

Appendix H Matrix solving using Tables 11.2 and 14.2 as examples... 

---