ENGINEERING NUMERICAL METHODS - EXAMPLE 19.1 : Solve the simultaneous equation using simple Excel program : r + s - t = 7, 2r - s = 0, 3r + 2t = 15. Explain the use of functions of MINVERSE and MMULT together with the keyboard C (Ctrl) + S (Shift) + E (Enter).
Answer Posted / kangchuentat
ENGINEERING NUMERICAL METHODS - ANSWER 19.1 : By using Microsoft Excel, r = 3.22, s = 6.44, t = 2.67. MINVERSE, or =minverse is used to inverse the 3 x 3 matrix with constants of r, s, t. MMULT, or =mmult can be used to obtain the answers by functions (inversed matrix of 3 x 3, constants of 7 and 0 and 15). CSE is an Excel function to perform quick calculations for the cells. 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 frequently asked technical questions in chemical engineering during PI?
What are the advantages and disadvantages of using gear pumps?
what is the apt definitions for apparent power ,active power and reactive power?and explanation about different types of lamps?
Do you have any idea on recombinant protein expression?
Explain the working of a spray condenser?
Plz if anybody has placement paper of HAL mail me i m Chemical engg my id er.kotnala@gmail.com
What are some good uses of low-grade steam at 12 atm and 1920c?
What are some common problems associated with bellow expansion joints?
hi can anyone tell me some technical questions asked in iocl
What kind of concerns is associated with temperature pinch points in condensers?
Is there any way to slow coke formation in ethylene furnaces?
What are the merits of using a falling film evaporator?
marketing procedure of iocl
What are the reasons of removal of particles from effluent gas?
What are some good estimates for heat transfer coefficients for coils in tanks?