Question

3. (50 points) Write a VBA code to implement Cramer's rule, then apply your code to solve below system of linear equations: 2 1 -2 3 -12-4 -1 2 -2 1 3X3-2 -3 1 4 2 -1 24 3 Specific requirements: 1) Input the coefficient matrix and constant vector in spreadsheet, then select and read them from spreadsheet; 2) Check solution existence, if solution not exits, please prompt a message "Solution not exits!" then stop the calculation; 3) Return result x vector to spreadsheet; 4) your code can be used to solve any arbitrary system of linear equations. Hint: you can use "Application. WorksheetFunction.MDeterm(A)" to find the determinant of matrix [A.

Answer 1

Step 1: input Augmented matrix and find the determinants of individual matrices by changing columns of constant matrix

checking for existance of solution is =IF(H9=0,"solution does not exist","solution exists")

and fin the X (X1,X2,X3, X4, X5) matrix by dividing determinants of D1, D2, D3, D4 and D5 matrices with D matrix respectively

The solution excel file is attached below

Input Complete augumented matrix
1	4	1	2	2	5
2	1	-2	3	-1	-4
-1	2	-2	1	3	-2
-3	1	4	2	-1	3
2	2	1	-3	2	6
	1	4	1	2	2
	2	1	-2	3	-1		-178
D	-1	2	-2	1	3
	-3	1	4	2	-1
	2	2	1	-3	2
	5	4	1	2	2
	-4	1	-2	3	-1
D1	-2	2	-2	1	3		-356
	3	1	4	2	-1
	6	2	1	-3	2
	1	5	1	2	2
	2	-4	-2	3	-1
D2	-1	-2	-2	1	3		356
	-3	3	4	2	-1
	2	6	1	-3	2
	1	4	5	2	2
	2	1	-4	3	-1
D3	-1	2	-2	1	3		-534
	-3	1	3	2	-1
	2	2	6	-3	2
	1	4	1	5	2
	2	1	-2	-4	-1
D4	-1	2	-2	-2	3		-178
	-3	1	4	3	-1
	2	2	1	6	2
	1	4	1	2	5
	2	1	-2	3	-4
D5	-1	2	-2	1	-2		-534
	-3	1	4	2	3
	2	2	1	-3	6
	0
X1=	2
X2=	-2
X3=	3
X4=	3
X5=	3