Question: Please show steps on Excel!!!!! 1. Write the following sets of simultaneous equations in matrix form and check the determinant in Excel with MDETERM to
Please show steps on Excel!!!!!
1. Write the following sets of simultaneous equations in matrix form and check the determinant in Excel with MDETERM to see whether there is a solution. If the solution exists, solve the equations using matrix inverse methods. Turn in your written answers and your Excel file with an example calculation for each dimension matrix (3 x 3, and 4 x 4). Name the sheet Problem 1". a) X1 + 8x2 + 4x3 = 0 -X1 + X2 + 7x3 = 7 6x1 + 7x2 -2x3 = 3 b) 7x2 + x3 = 3 3x1 + 6x2 + 3x3 = 8 -3X: + 8x2 -X3 = 2 3x1 + 5x3 = 3 8x1 + 7x2 + 8x3 = 8 3x2 +7x3 =2 4y + 2y2 + y + 5y4 = 52.9 3y + y2 + 4y3 + 7y4 = 74.2 2y + 3y2 +y3 +6y4=58.3 3y1 + y2 + y3 +3y4 = 34.2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
