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
Hi, I am preparing for Indian Forest Service (UPSC). Can you please help me to get previous years question papers (Chemcial Engineerign) (atleast 5).
Define condensate lift?
What is a common failure mechanism for above ground atmospheric storage tanks?
Is it advisable to cool a fin fan by spraying demineralized water on it?
y we do not differ b/w atomic mass and atomic wieght? from engrtauseef2008@gmail.com
What is a 'saltation velocity' and how is it used in designing pneumatic conveying systems?
Explain what types of valves are recommended for slurry services?
What is a black body?
What are the different types of equipments for the conveyance of solids?
Calculate the line size for a cooling water line with a volumetric flowrate of 1200m3/h of water. Density of water = 1000kg/m3
Are there any methods of preventing cracking of carbon steel welds in refining environments?
How can I evaluate the thermal relief requirements for double block-in of 98% sulfuric acid?
Explain what are the advantages of using gear pumps?
testing formula for oxygen by ammonium chloride,ammonium hydroxide and copper
What are the specialized grinding methods?