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.
- 1 Answers
- 2163 Views
- I also Faced
- E-Mail Answers
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
How can we derive power factor equation p=vi cos phi?
How many years you are having experience in supervising others in lab environment?
What is the process of including heat exchangers in ammonia refrigeration system?
How to size the cooling tower sump / basin for any given circulation rate? What is the guideline?
What is condensate lift?
What is the easiest way to extract hydrogen from water and the safest way to store it?
Define a barometric condenser?
Explain about different types of lamps?
How can you separate hydrogen peroxide into hydrogen and oxygen?
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
which accomplishments in your present position are you proud of and why?
MY generator water cooler inlet line height - 11 mtr inlet water line height - 7 mtr water come into the line from overhead tank, O/H tank height - 20 mtr the first tapping in the inlet line is 2" line which down to 4 mtr level plateform., second tapping in inlet water line goes to a pump 6" line installed at 4 mtr level plateform, pump capacity 200m3/hr, head- 30 mtr, hp-40. the outlet of pump of 6" water line connected to a header of 6 mtr long of 6" line, on this header the six tapping are connected, 4 nos. 3" line goes to 11 mtr height water cooler the pressure of the line is 0.15 to 0.25 kg/cm2, 2" and 4" pipe line connected to a cooler at 4 mtrlevel plateform. my question is, at 11 mtr height level the quantity of water and flow is not sufficient for my cooler, the temp. of cooler is rises much more. you are requested to suggest the modification of pipe line/ pump for take more water flow and pressure (desired pressure is 1 kg/cm2)
What does the catalytic converter on an automobile do?
i am appearing in railway section engg. exam of chemical eng. therefore i want previous papers and study material of chemical eng.
Explain the difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?
