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

how much time will take 20000 liter water to cool from 80-30 0C ? Assume all parameters constant

1 Answers  


how interstage pressure of multistage compressor is calculated?

2 Answers  


DIFFERENTIAL EQUATIONS - EXAMPLE 20.1 : By using Excel program either on laptop or desktop PC, solve the differential equation dy / dx = -2y + x + 4 with h = 0.005, initial values : x = 0, y = 1. The 4th order Runge-Kutta method provides : y(N + 1) = y(N) + (1/6) (k1 + 2k2 +2k3 + k4), k1 = h [ -2y(N) + x(N) + 4 ], k2 = h { -2 [ y(N) + k1 / 2 ] + x(N) + h / 2 + 4 }, k3 = h { -2 [ y(N) + k2 / 2 ] + x(N) + h / 2 + 4 }, k4 = h { -2 [ y(N) + k3 ] + x(N) + h + 4 }. What is the value of y at x = 0.5?

1 Answers  


Why is post-weld heat treatment sometimes necessary for welded vessels?

0 Answers   Aramco,


QUANTUM CHEMISTRY AND CHEMICAL ENGINEERING - EXAMPLE 31.9 : When an algebraic product is defined on the space, the Lie bracket is the commutator [x,y] = xy - yx according to Lie algebra in mathematics. If [p,x] f(x) = px f(x) - xp f(x), p = -ih d / dx, find the value of [p,x] in term of i and h.

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  


Is it advisable to cool a fin fan by spraying demineralized water on it?

0 Answers  


What is some common piping materials used to transport slurries?

0 Answers  


is petroleum a mixture of hydrocarbon?

5 Answers  


ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.13 (CORRECTION) : (i) In the Present Value Multiplication Rule, let PV = present value, Ra = interest rate for first discount, A = duration for first discount; Rc = interest rate for second discount, C = duration for second discount. Let PV = [ 1 / (1 + Ra) ^ A ] [ 1 / (1 + Rc) ^ C ] where ^ is the symbol of power : 3 ^ 2 = 3 x 3, 2 ^ 3 = 2 x 2 x 2. (a) For discounts involving 8 % / year for 3 years and 10 % / year for 9 years, find the value of PV. (b) If Re = interest rate for third discount, E = duration of third discount, form a mathematical equation of PV as a function of A, C, E, Ra, Rc, Re. Note : Discounts are available in the purchase of certain biochemical engineering instruments. (ii) Let R = nominal interest rate related to growth rate of money, r = real interest rate related to growth rate of purchase power. If I = inflation, where the unit of R, r and I is %, find the mathematical relationship of r as a function of R and I.

1 Answers  


what is designing step of heat exchanger

0 Answers   Reliance,


Question 64 – 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  


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)