lae techniques using excell

3
20 -4 -10 30 -4 18 -11 -18 -10 -11 30 20 det(I1) 30 -4 -10 -18 18 -11 20 -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== 2 Find determinant for Matrix I1 3 Find determinant for Matrix I2 4 Find determinant for Matrix I3 5 Find I1, I2 and I3 formula== 6 The asnwer wil be appeared separately Method 2 1 Find inverse matrix formula== 2 Multiply inverse matrix with the 3x1 matrix given formula== 3 The answer will be appeared silmutaneously

Upload: humaira-mirza

Post on 10-Feb-2016

217 views

Category:

Documents


4 download

DESCRIPTION

excel hm

TRANSCRIPT

Page 1: LAE Techniques Using Excell

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

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

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