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).
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 |
What are the advantages of using gear pumps?
what is designing step of heat exchanger
Explain about different types of lamps?
What is the difference between multi grade filter and dual media filter?
1 Answers Dalkia, Oil and Gas Jobs,
we have 2 O2/Comb Analyzers Servomex Model 2700 in service for one of the furnaces in our chemical plant. It is giving High Temperature Alarm. Checked Temperature and found it to be 800 Deg C whereas Set Point is 700 Deg c. It is strange why is temperature not at SP. Also response is 23 % with 21 % Inst Air and with N2 reading is not coming down. please clarrify this issuses very urgent
What are the factors involved in designing kettle type reboiler?
What is carbon sequestration?
What is % of piping & equipment cost for a chemical plant having batch process?
What types of pneumatic conveying systems are typically used?
How can we derive power factor equation p=vi cos phi?
what is factories act?tell about factories act?
What are some of the consequences of an undersized kettle type reboiler?
Civil Engineering (5086)
Mechanical Engineering (4453)
Electrical Engineering (16638)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)