Name: Sapitan, Christian James M. Sapitan
Student Number: 2022-102855
CYS: BS EE - 3B
LAB ACTIVITY 8 - BASIC MATRIX OPERATIONS
Use Excel’s MDETERM array function to see whether there is a solution to the simultaneous equations represented by each of the coefficient and right-hand-side matrices shown.
a. [Coeff1] 3 0 5 b. [Coeff2] 1 2 0 c. [Coeff3] 4 3 3
8 7 8 0 1 1 3 8 4
0 3 7 2 5 1 3 2 8
[rhs1] 3[rhs2] 4[rhs3] 7
8 3 3
2 3 2
Det(Coeff1) 195 Det(Coeff2) 0Det(Coeff3) 134
Yes No No
If the solution exists, solve the equations by using matrix methods.
If the solution does not exist, simply type N/A.
[Coeff1-inv] 0.128205 0.076923 -0.179487 [Coeff2-inv] N/A N/A N/A [Coeff3-inv] 0.41791 -0.134328 -0.089552
-0.287179 0.107692 0.082051 N/A N/A N/A -0.089552 0.171642 -0.052239
0.123077 -0.046154 0.107692 N/A N/A N/A -0.134328 0.007463 0.171642
[xa] 0.641026 [xb] N/A [xc] 2.343284
0.164103 N/A -0.216418
0.215385 N/A -0.574627
Is there a solution?
(Yes or No)
