Question 30 – 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 / kang chuen tat (malaysia - pen

Answer 30 : 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

can you explain about the design calculations and procedure of boiler

2329


Explain how does a tank-blanketing valve operate?

642


Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel

2188


On what basis are materials to be crushed evaluated apart from size?

661


How can you control the ph level in our cooling water with respect to ammonia contamination?

625






What factors go into designing the vapor space of kettle type reboiler?

660


How i can calculate heat transfer in reactor at unsteady state and what data should i have? I want equation and process to calculate it? As there is steam or brine in jacket

1875


What's -74C, dew point is better the -70C dew point In draying unit .

1583


What is a good source of surfactant information on the internet?

725


Are there any general rules for flushing slurry lines?

622


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

1734


Explain the method of determining maximum differential pressure during hydro testing of shell and tube heat exchangers?

612


What is an additive?

643


What are some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?

800


I am pg student of chemical engg. I am intrested Heat Transfer Subject . I want information about advance heat transfer related PG PROJECT

1841