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
Explain can large temperature differences in vaporizers cause operational problems?
Explain the steps required to design a vapor-liquid separator or flash drum?
what is AZ431 & how to check it by using multimeter?
How can you control the ph level in our cooling water with respect to ammonia contamination?
DEAR SIR, IS IT ANY BARC TECHNICAL OR INTERVIEW QUESTION BOOK IN CHEMICAL ENGG LAST YEARS IN MARKET? ALSO GIVE THE PATTERN HOW TO PREPARE AND WHAT TYPE OF QUESTION THEY ASKED?
What are the problems that are associated with the expansion joints?
Explain the use of gear pumps in motor?
What diffrence between flush distillation & batch distillation ?
i m a frsh chemical engineer now i m confuse to attend the interview so anybody pls send model question papers to this christ_vivek33@yahoo.com
Hi, This is Naveen, plz if anybody have experience of IOCL interview, send me question.
What are the advantages of using gear pumps?
How is plate heat exchangers used in an ammonia refrigeration system?
Where barrel pump use?
can anyone send me the written test paper of Indian oil corporation ltd. My email id is pratuljakhmola@yahoo.com
What is difference between Piping Standard & Piping Specification ?