Question 57 – 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.
- 1 Answers
- 1816 Views
- I also Faced
- E-Mail Answers
Answer Posted / kang chuen tat (malaysia - pen
Answer 57 – (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 some good advice for specifying allowable pressure drops in shell and tube exchangers for heavy hydrocarbons?
Name some common problems associated with dilute phase pneumatic conveying?
Difference between Synthetic foaming agents V/S Protien based foaming agent?
How is waste heat boilers categorized?
Explain the some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?
i am appearing in railway section engg. exam of chemical eng. therefore i want previous papers and study material of chemical eng.
Can you pls tell me how to calculate the amphere rating of cable in case of three phase supply but all load is single phase
Plz if anybody has placement paper of HAL mail me i m Chemical engg my id er.kotnala@gmail.com
Explain what is the significance of the minimum flow required by a pump?
What is a good method of analyzing powders for composition?
Hi, This is Naveen, plz if anybody have experience of IOCL interview, send me question.
What types of valves are recommended for slurry services?
Explain some good strategies for curing tube vibration in shell and tube exchangers?
What industries require filtered compressed air?
hello everyone do anyone have interview questions for any chemical industry please email me at
