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 the significance of the angle of repose holds in the chemical industry?
What is an effective means of removing silicon from aluminum?
Hi.. Me going to tke test for management trainee(technical) Post I am an chemical engineering student . Can u guide how to prepare for this test.Can u send me test paper pattern..?
hai....i am chandrika. if anybody having test questions for HAL,HPCL,ONGC,IOL...PLS SEND THE QUES WITH SOLVED ANSWERS TO ME TO MY MAIL ID chandrismiles@yahoo.co.uk
Explain how do you design a vapor-liquid separator or a flash drum?
Explain the process of including heat exchangers in ammonia refrigeration system?
what is mass flow rate of steam of 7 kg/cm2 pressure in 1 inch id. pipe.
What is an isochoric process?
Explain the difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?
what is the apt definitions for apparent power ,active power and reactive power?and explanation about different types of lamps?
What are the specialized crushing methods?
What types of metals are typically removed via chemical precipitation?
Why is double the amount of gas collected in one of the test tubes in electrolysis of water than th amount collected in the other? Name this gas?
Explain how can you keep our seawater used for heat rejection clean before entering our heat exchangers?
Why should chemical equation be balanced?