ENGINEERING NUMERICAL METHODS - EXAMPLE 19.3 : There are 2 simultaneous equations : (A1) x + (B1) y = D1 and (A2) x + (B2) y = D2. (a) By using Excel program, find the values of x and y when A1 = 80, A2 = 150, B1 = 52, B2 = 100, D1 = 3.5 and D2 = 2.3. (b) Write the expression of Excel in the form of =MMULT(MINVERSE(W:X),Y:Z) in order to get the values of x and y. W, X, Y and Z may be A1, A2, B1, B2, D1 and D2.

Answer Posted / kangchuentat

ENGINEERING NUMERICAL METHODS - ANSWER 19.3 : (a) Excel program will produce the answers of x = 0.025, y = 0.01. (b) =MMULT(MINVERSE(A1:B2),D1:D2). The answer is given by Kang Chuen Tat; PO Box 6263, Dandenong, Victoria VIC 3175, Australia; SMS +61405421706; chuentat@hotmail.com; http://kangchuentat.wordpress.com.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the steps taken to operate a tank-blanketing valve?

497


how can i prepare for gate chemical in kolkata

1733


pls send me model paper of NPCIL for executive trainee. and syllabus of executive trainee 2015.

2315


What are the different types of equipments for the conveyance of solids?

561


What are flameless oxidizers?

640






What are the steps taken to operate a tank-blanketing valve?

636


Can large temperature differences in vaporizers cause operational problems?

691


What are advantages using hollow shaft impeller?

3435


What do you understand by wet bulb globe temperature?

699


could any one plzz give me the placement tech papers taken by iocl,and bpcl in chemical stream..... my id is.... mishra.gaurang@gmail.com

1750


What does the catalystic converter on an automobile really do?

657


I want previous year question paper of ONGC for chemical engg.

1776


What is a good source of information for the design of pressure vessels?

584


What are the problems that are associated with the expansion joints?

646


On what basis are materials to be crushed evaluated apart from size?

652