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
Explain what is the best way to configure a bypass line in slurry services?
How many grams per liter would there be in a 0.35 n (normality) citric acid solution?
Explain why is post-weld heat treatment (stress relieving) sometimes necessary for welded vessels?
what are the chemicals used in PFR and MFR to Process?
Name some common problems associated with dilute phase pneumatic conveying?
Explain what particle sizes are electrostatic precipitators used to remove?
Define wet bulb globe temperature?
What is a quick way to calculate frictional pressure drops in carbon steel pipe?
What are the reasons of removal of particles from effluent gas?
Explain what are the affinity laws associated with dynamics pumps?
Explain the method adopted to minimize shell side pressure drop in a shell?
What steps can be taken to avoid stress corrosion cracking (SCC) in steel vessels used for storing anhydrous ammonia?
Hi, I am in need of interview questions from Engineers india limited in chemical engineering.if any one has kindly post it to me soon.
Explain what are the methods involved to test helium leak testing in a vacuum system?
Do you have any idea on recombinant protein expression?