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


Please Help Members By Posting Answers For Below Questions

i have done B.TECH in che.tech.and doing MBA . why you doing mba why u have not join any job.

1948


What is carbon sequestration?

687


can anybody give me syallbus of chemical engineering for section engineer in railway.

2101


Explain how can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?

756


Explain why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?

676






What is vapour flooding and liquid floodin in distillation?

1281


Explain how can viscosity affect the design of a mixer?

696


Where the Induced draft, forced draft & balanced draft furnace are to be used? Selection of furnaces are based on which criteria?

3182


The process conditions of the fuel gas are as follows: Temperature = 25 deg C Pressure = 4 bar g Calculate the line size for the fuel gas supply line to the superheater

1863


If sum one has HAL placement paper plz mail me ,I m Chemical Engg.my id is er.kotnala@gmail.com

2151


What is a common source of error in determining the percent spent caustic in refinery applications?

715


What is some common piping materials used to transport slurries?

796


What are the frequently asked technical questions in chemical engineering during PI?

1232


I will complete chemical engg next yr from a deemed university. Earlier I dropped 2 yrs after std 12th. Then I got 2 yr back while completing engg, due to reasons beyond my control. Will I face any problem while applying for job. More so not many core companies come to our collg for placement. So i want to know which all companies can I apply to get a job?

1860


Explain how does a tank-blanketing valve operate?

731