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
Why in a continuous plant for a Hot standby screw pump system the interlock for auto starting of the other pump ( when the running pump stopped suddenly) is given with header pressure only? why not with flow rate or current of the pump?
What is gibbs free energy?
Explain the different characteristics that can affect the flow of bulk solids and how?
Do you have recombinant protein expression experience? Explain?
Who built the first production scale pla (polylactic acid) facility?
how did you spend today
Are there any methods of preventing cracking of carbon steel welds in refining environments?
For a heat exchanger, will the overall heat transfer coefficient increase along with an increase in lmtd (log mean temperature difference) around the unit?
Explain some common piping materials used to transport slurries?
Define a surfactant?
What do we use carburizing/nitriding chemicals for?
What is a "saltation velocity"?
What is happening when paint dries?
Dear sir/madam I am in final year BE chemical engineering.Which companies i can apply .Please guide me.It is very helpful for me
What is screen analysis?