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 - EXAMPLE 19.1 : Solve the simultaneous equation using simple Excel pr..

Answer / 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

More Chemical Engineering Interview Questions

What is a good method of minimizing shell side pressure drop in a shell and tube exchanger?

0 Answers  


How can I remove/decrease TDS from sewage waste water? At the moment it is 900gm/l. What is recommended TDS level to dispose sewage water in sea?

2 Answers   OGDCL,


Mention some of the specialized grinding methods?

0 Answers  


CHEMICAL ENERGY BALANCE - EXAMPLE 11.2 : Calculate the cooling duty, H required to condense and cool acetone from 100 degree Celsius to 25 degree Celsius at atmospheric pressure. The heat of vaporization for acetone at its normal boiling point is 30.2 kJ / mol. The boiling point of acetone at atmospheric pressure is 56 degree Celsius. The flowrate of acetone through the condenser is 100 mol / s = N. Value of sensible heat needed to increase the temperature of acetone in liquid form from 25 to 56 degree Celsius is 4.06 kJ / mol. Value of sensible heat needed to increase the temperature of acetone in vapor form from 56 to 100 degree Celsius is 3.82 kJ / mol. Unit of H is kJ / s.

1 Answers  


BIOPROCESS ENGINEERING - EXAMPLE 14.3 : The kinetic behavior of an enzyme could be described using Michalis - Menten equation : Vo = Vmax [S] / (Km + [S]). Derive this equation from [ES] = [E]total [S] / (Km + [S]), Vmax = Kcat [E]total, Vo = Kcat [ES].

1 Answers  






What's -74C, dew point is better the -70C dew point In draying unit .

0 Answers  


What is the working of vaccum distilation coloumn in a petroleum refinary?

4 Answers  


Why do we apply on iron articles?

0 Answers  


why Torispherical heads are used in pressure vessels?

1 Answers   India Cements,


How can hexavalent chromium be removed from aqueous waste streams?

0 Answers  


Is there any way to repair a valve that is passing leaking internally without taking our process offline?

0 Answers  


Explain how can you prevent bridging in a dilute phase pneumatic conveying system?

1 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4452)
  • Electrical Engineering Interview Questions Electrical Engineering (16636)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)