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 do we use carburizing/nitriding chemicals for?
Explain how can you keep our seawater used for heat rejection clean before entering our heat exchangers?
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
What is the angle of repose and what are its applications in the chemical industry?
I am a student of class 12. With PCMB group. But I Am not good at math. So I wanted to ask whether Chemical engineering can be a good option for me.???
What is a good relation to use for calculating tube bundle diameter?
send me previous year question paper for ongc gt 2011 written exam
How can I treat a waste stream containing both hexavalent chromium and arsenic?
What type of pump may be appropriate for a liquid near saturation, a low flow rate, and very limited npsha?
What are some of the consequences of an undersized kettle type reboiler?
How can metals be removed from aqueous waste streams?
Explain how can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?
Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture?
What are the main terms in unit operations? What are its characteristics?
which accomplishments in your present position are you proud of and why?