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

Why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?

0 Answers  


Which type of pneumatic control valve is used mostly Either Air to Open r Air to close the value And guys I need reason for your reason

0 Answers  


PROCESS DESIGN - EXAMPLE 21.3 : According to a heuristic of chemical engineering plant design, assume a pressure difference dP = 4 psi for each 10-ft rise in elevation. A pump is needed to pump liquid from a storage tank at a lower elevation to a heating tank at a higher elevation with the elevation difference of 60 ft. (a) Find the pressure loss due to such elevation. (b) If the required minimum inlet pressure to the heating tank is 9 psi, with 1 control valve is installed between pump and heating tank, what is the dP minimum required for the control valve and the entrance to the heating tank when the heuristic mentions that at least 10 psi is required for the control valve? (c) The pressure at the inlet of the pump is 8 psi and the flowrate of the liquid produces pressure head of 50 psi. What is the total pressure produced by the pump? (d) Assume a pipeline dP of 2 psi / 100 ft for liquid flow in a pipe according to heuristic, what is the approximate maximum length of the pipe in ft that can be installed between the pump and the heating tank?

1 Answers  


What does the catalystic converter on an automobile really do?

0 Answers  


what is ifference between PFR ,MFR and batch reactor?

9 Answers   BARC, IOCL,






How can you estimate a gas flow based on two pressure measurements?

0 Answers  


In engineering economy, the future value of first year is FV = PV (1 i). For second year it is FV = PV (1 i) (1 i). For third year it is FV = PV (1 i) (1 i)(1 i) where FV = future value, PV = present value, i = interest rate per period, n = the number of compounding periods. By induction, what is the future value of $1000 for 5 years at the interest rate of 6%?

1 Answers  


Question 56 - 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  


Why catalyst is charging in chemical reaction as high pressurized pellet of tablet?

2 Answers  


What type of pump may be appropriate for a liquid near saturation, a low flow rate, and very limited npsha (net positive suction head available)?

0 Answers  


Explain how can you determine the proper pipe thickness for a slurry line?

0 Answers  


ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.20 : Assume an engineer buys a $1 bond in period T while the nominal interest rate is R. The inflation rate at T + 1 is anticipated to be I. (a) If the bond is redeemed in period T + 1, how much money will the buyer engineer receive, in term of R, which is not affected by inflation? (b) Find the present value, PV of the proceeds from the bond, in term of R and I. (c) If the bond is redeemed in period T + 1, calculate the real growth or real value of the money that the buyer engineer will receive, in term of r = real interest rate, which is affected by inflation. (d) From the answers in (b) and (c), find the values of x, y and z in the following Fisher equation : (1 + x) = (1 + y) / (1 + z), in term of r, R and I.

1 Answers  


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