Question: please work this out in excel with step by step instructions. must use solver within excel to work out 8 Solve Probs. 12.16(b) and (c)


8 Solve Probs. 12.16(b) and (c) in Excel using Solver. Compare the effort involved in obtaining these solutions with the effort involved using the matrix-inversion method. 12.16 Solve each of the following systems of simultaneous equations. In each case, verify that the solution is correct using the method described in Prob. 12.14. (a) 15x1+20x2=25 5x1+10x2=12 (b) 4x12x2+x3=6 x1+3x27x3=34 2x15x3=14 x1+x2+5x312x4=29 (c) 7x2+16x4=21 7x1+2x212x4=5 x3x4=6 2.14 Solve the system of simultaneous equations given in Prob. 12.8 using Excel. Verify that the solution is correct by forming the product AX and comparing this product with the original B vector
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
