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).



Question 30 – Solve the simultaneous equation using simple Excel program : r + s – t = 7..

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

More Chemical Engineering Interview Questions

Question 29 – For a Vernier scale that consists of 0.11 cm per section, estimate the length on actual standard ruler of 0.1 cm per section for 2.39 m and 0.91 m.

1 Answers  


which is the major cement producing state in western India ?

2 Answers   BNPM,


Explain the different characteristics that can affect the flow of bulk solids and how?

0 Answers  


To how much height the liquid willbe thrown out to atmosphere from a pump with a discharge pressure of 5bar

4 Answers   TCL,


how much maximum power can be generated by 320v, 10kg-cm synchronus motor if shaft is roteted mechanically at 50 to 60 rpm?

0 Answers  


What is the method involved in analyzing powders for composition?

0 Answers  


plz send the interview questions in the written test asked by hindustan petroleum corporation ltd.Iam a b>tech in chemical engineering.My written test is on feb 2008.urgent plz.send the questions to avazithraja@rediffmail.com

9 Answers   AZTEC, Bapex, HPCL,


what are lubricants using in compression.

1 Answers  


QUANTUM COMPUTING - EXAMPLE 32.9 : In quantum computing, find the equations of S = (a | 0 > + b | 1 >) (g | 0 > + d | 1 >) in term of | 00 >, | 01 >, | 10 > and / or | 11 > when ad = 0.

1 Answers  


sir/mam . I am a fresh student of chemical engineeing. i've somuch fear to face intervies. I become neverse when entered into company. what shall I do? please suggest me some tips to face the interview.

3 Answers  


MASS TRANSFER - EXAMPLE 4.1 : A concentric, counter-current heat exchanger is used to cool lubricating oil. Water is used as the coolant. The mass flow rate of oil into the heat exchanger is 0.1 kg / s = FO. For oil, the inlet temperature TIO = 100 degree Celsius and the outlet temperature TOO = 55 degree Celsius. For water, the inlet temperature TIW = 35 degree Celsius and the outlet temperature TOW = 42 degree Celsius. What is the mass flow rate of water in kg / s, FW needed to maintain these operating conditions? Constant for heat capacity of oil is CO = 2131 J /(kg K) and for water is CW = 4178 J /(kg K). Use the equation (FO)(CO)(TIO ?TOO) = (FW)(CW)(TOW ?TIW).

1 Answers  


What are the types of clarifier used in water treatement plant?

1 Answers   Adani,


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4452)
  • Electrical Engineering Interview Questions Electrical Engineering (16637)
  • 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)