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
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
oil field interview question
What is a "saltation velocity"?
What is a good source of information for the design of pressure vessels?
What is the best way to control an oversized, horizontally oriented shell and tube steam heater?
On what basis are materials to be crushed evaluated apart from size?
What is a black body?
what are the chemicals used in PFR and MFR to Process?
Explain how can you estimate a gas flow based on two pressure measurements?
What is fuel requirement of 20kg/hr of incineration having material calorific value 6500 kcal/kg and diesel calorific value 10707 Kcal/Kg (PCC=850 degC and SCC 1050 Deg c)
Explain how is waste heat boilers categorized?
What is vapour flooding and liquid floodin in 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
What is the angle of repose?
Explain the different characteristics that can affect the flow of bulk solids and how?