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
- 1798 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 are the different characteristics that can affect the flow of bulk solids and how?
Is there any way to slow coke formation in ethylene furnaces?
How can one determine if a particular solid can be fluidized as in a fluidized bed?
What are the three classes of organic solvents?
Why is double the amount of gas collected in one of the test tubes in electrolysis of water than th amount collected in the other? Name this gas?
What is the definition of 'good' cooling tower water?
How can arsenic be removed from aqueous waste streams?
How can you estimate a gas flow based on two pressure measurements?
For a given bulk solid how can the particle size distribution be determined?
Explain how can you quickly estimate the horsepower of a pump?
What kind of concerns is associated with temperature pinch points in condensers?
What is a "saltation velocity"?
Why do we apply on iron articles?
Explain how can viscosity affect the design of a mixer?
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
