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.
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
What is screen analysis and what are its applications in the chemical industry?
Explain what are the affinity laws associated with dynamics pumps?
hi can anyone tell me some technical questions asked in iocl
How can separation of chiral chemicals affect the chemical and/or pharmaceutical industries?
Explain the steps required to design a vapor-liquid separator or flash drum?
Are some heat transfer services more prone to tube vibration that others for a shell and tube exchanger?
What is a good source of surfactant information on the internet?
How is waste heat boilers categorized?
what is the difference between car seal close/open valves and lock close/open valves?
Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture?
What are advantages using hollow shaft impeller?
Is four stage graphite steam jet ejector is possible. Any body can provide its design
Are there flow velocity restrictions to avoid static charge build up in pipelines?
how did you spend today
marketing procedure of iocl