lae techniques using excell
DESCRIPTION
excel hmTRANSCRIPT
![Page 1: LAE Techniques Using Excell](https://reader036.vdocuments.us/reader036/viewer/2022082823/563db956550346aa9a9c5894/html5/thumbnails/1.jpg)
20 -4 -10 30-4 18 -11 -18
-10 -11 30 20
det(I1) 30 -4 -10-18 18 -1120 -11 30
det(I2) 20 30 -10-4 -18 -11
-10 20 30
det(I3) 20 -4 30-4 18 -18
-10 -11 20
Method 1
1 Find determinant for original matrix formula==> mdeterm(matrix)2 Find determinant for Matrix I13 Find determinant for Matrix I24 Find determinant for Matrix I35 Find I1, I2 and I3 formula==> divide determinant I1, I2 and I3 with determinant of original matrix6 The asnwer wil be appeared separately
Method 2
1 Find inverse matrix formula==>select 3x3 boxes and key-in the formula minverse(array). After selecting the array, hold down control and shift keypad, then enter2 Multiply inverse matrix with the 3x1 matrix given formula==>select 3x1 boxes and key-in the formula mmult(matrix 3x3, matrix 3x1), hold down control and shift key pad, then enter3 The answer will be appeared silmutaneously
![Page 2: LAE Techniques Using Excell](https://reader036.vdocuments.us/reader036/viewer/2022082823/563db956550346aa9a9c5894/html5/thumbnails/2.jpg)
det(I) 5220det(I1) 12910det(I2) 3100det(I13) 8920I1 2.473 2.473I2 0.594 0.594I3 1.709 1.709
formula==> mdeterm(matrix)
formula==> divide determinant I1, I2 and I3 with determinant of original matrix
formula==>select 3x3 boxes and key-in the formula minverse(array). After selecting the array, hold down control and shift keypad, then enterformula==>select 3x1 boxes and key-in the formula mmult(matrix 3x3, matrix 3x1), hold down control and shift key pad, then enter
![Page 3: LAE Techniques Using Excell](https://reader036.vdocuments.us/reader036/viewer/2022082823/563db956550346aa9a9c5894/html5/thumbnails/3.jpg)
formula==>select 3x3 boxes and key-in the formula minverse(array). After selecting the array, hold down control and shift keypad, then enterformula==>select 3x1 boxes and key-in the formula mmult(matrix 3x3, matrix 3x1), hold down control and shift key pad, then enter