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
What is a good way to get started in doing a plant-wide steam consumption analysis?
Hi, I am preparing for Indian Forest Service (UPSC). Can you please help me to get previous years question papers (Chemcial Engineerign) (atleast 5).
Explain the functioning of a three-way catalytic converter.
need the type of technical questions in written test
friends....i have been searching the model paper for HPCL officer trainee for chemical eng....tat apptitude section...if u people got any information regarding tat...please send me to my mail...my id is: maruthu.flower@gmail.com...pls send me wtever information u knew....thank u....
Why are decomposition reactions called the opposite of combination reactions?
Define wet bulb globe temperature?
what is mean by chemical engineering and its scope in industry
Explain how can I evaluate the thermal relief requirements for double block-in of 98% sulfuric acid?
What are some characteristics of bulk solids that can affect their ability to flow properly?
How many grams per liter would there be in a 0.35 n (normality) citric acid solution?
How can you control the ph level in our cooling water with respect to ammonia contamination?
What is % of piping & equipment cost for a chemical plant having batch process?
Is there a quick rule-of-thumb to estimate a gas side heat-transfer rate inside the tubes of a shell and tube heat exchanger?
Name some common causes of control valve noise?