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


Please Help Members By Posting Answers For Below Questions

What is the import procurement cycle?

736


What is some common piping materials used to transport slurries?

795


What is vapour flooding and liquid floodin in distillation?

1280


Explain the common failure mechanism for above ground atmospheric storage tanks?

712


Hi. I have completed my masters in chemical engineering from M S University in year 2008 and now going to do MS Chemical engineering in Lamar University. I am planning to appear for interview in two weeks from now. What are the expected questions from VO regarding masters after masters ? and wat should i expect to give reply ? kindly give your suggestions. Thanks

1697






I am a Diploma Chemical Engineer by Nirma Uni; and BEng (Hons) Energy & Environmental Engineer by Napier Uni; Edinburg, UK. HPCL chemical engineering test will held on 14th July,09. So, Please send me some previous chemical engineering papers Objective types Or material to give the test.

3154


What is the purpose of capacitor? What does capacitor load means? How does it connect?

769


I will complete chemical engg next yr from a deemed university. Earlier I dropped 2 yrs after std 12th. Then I got 2 yr back while completing engg, due to reasons beyond my control. Will I face any problem while applying for job. More so not many core companies come to our collg for placement. So i want to know which all companies can I apply to get a job?

1859


what is designing step of heat exchanger

2717


How can you separate hydrogen peroxide into hydrogen and oxygen?

746


We are having proplem with the persperation smell in ETT/ECHO room in our cardiac hospital.The 2 Ton of AC is not conditioning the environment. We have to use exhaust fan to through out of the room bad air. Could anyone suggest how to coup with this effectively using chemical engineering. Any permanent solution to neutralise the bad smell.The Air freshners are not doing enough instead making a bad odour.

1857


Hi, Please give me chemical engineering paper for IOCL exam for entire written exam, GD and personel interview model questions to my email id. (chemistnathan@rediffmail.com) Rgds, Ragu

3040


hi can u send me all d technical qus pepar of DRDO?my email id is palmzk@gmail.com

2072


What are some common precipitating agents used to remove metals from aqueous waste streams?

789


What are the merits of using a falling film evaporator?

787