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.
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 the most common carrier gas used in pneumatic conveying?
Name some guidelines for designing for liquid and gas velocities in process plant piping?
What is the order of a chemical reaction, , if the rate of formation of 'C', increases by a factor of 2.82 on doubling the concentration of 'A' and increases by a factor of 9 on trebling the concentration of 'B'?
Explain what is the method involved in analyzing powders for composition?
Explain how are vessel lined with glass or how are they coated?
repected sir i have given gate exam today.......... if i ll get the better rank in that ....what is the next process .....shall i give another one test......or wat....i dint get properlly..... plz help me or mail me on Nish_gasti@yahoo.co.in
Explain about different types of lamps?
What are the Major Utility Systems in a Pharma Plant? How are they interrelated?
Do you have any idea on recombinant protein expression?
When specifying a cooling tower, should I look up historic wet bulb temperatures for my area or should I take measurements?
i need last year question paper of GATE exam of chemical stream.but i failed i geting exam papers.soits humble request to u that if any body found last years GATE exam paper of chemical stream then send it to on this mail address.i shall be thankful to u for this. mail address:- sachin_4255@yahoo.co.in thank you.
pleas tell me about chemical engineering apptitude test..
How can wet carbon dioxide be responsible for a corrosion problem in iron-containing metals?
Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture?
How do you design a vapor-liquid separator or a flash drum?