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

PROCESS DESIGN - EXAMPLE 21.1 : According to rules of thumb in chemical process design, consider the use of an expander for reducing the pressure of a gas when more than 20 horsepowers can be recovered. The theoretical adiabatic horsepower (THp) for expanding a gas could be estimated from the equation : THp = Q [ Ti / (8130a) ] [ 1 - (Po / Pi) ^ a ] where 3 ^ 3 is 3 power 3 or 27, Q is volumetric flowrate in standard cubic feet per minute, Ti is inlet temperature in degree Rankine, a = (k - 1) / k where k = Cp / Cv, Po and Pi are reference and systemic pressures respectively. (a) Assume Cp / Cv = 1.4, Po = 14.7 psia, (temperature in degree Rankine) = [ (temperature in degree Celsius) + 273.15 ] (9 / 5), nitrogen gas at Pi = 90 psia and 25 degree Celsius flowing at Q = 230 standard cubic feet per minute is to be vented to the atmosphere. According to rules of thumb, should an expander or a valve be used? (b) Find the outlet temperature To by using the equation To = Ti (Po / Pi) ^ a.

1 Answers  


Explain 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  


Given, T1=600C, constant temperature of wall 800 , length of wit exchanger L=3m, dia=25 mm, Cp=14.91 KJ/kg.K, density ρ=914 kg/m3,mean velocity vm= 2 m/s, film heat transfer coefficient hf=72 Kcal/h.m2.K, what is the outlet temperature?

0 Answers  


Please tell me what type of questions will be asked in a petrochemical company

2 Answers  


cetane no. and sulphur required in diesel fuel for euro-IV

2 Answers   IOCL,






What is the method of determining maximum differential pressure during hydro testing of shell and tube heat exchangers?

0 Answers  


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

0 Answers  


how to find a liquid flow's direction in a closed pipe by merely seeing it(without pressure gauges)...

4 Answers  


I want to do Mtech In CHEMICAL ENGINEERING FROM IIT< BUT people say that u dont get enough money, I still want to do mtech but not mba , Please tell me about my future What should i do, I have done B. E in chemical and working as a chemical engineer only , Please guide me COZ MONEY IS NEEDED In todays world but i still want to make my career in chemical engineering

9 Answers  


QUANTUM BIOLOGY - EXAMPLE 33.10 : The wavefunction starts out in a superposition of possible states in a closed black box like this : Ψ (kitty) = 0.7071 Ψ (alive) + 0.7071 Ψ (dead) where Ψ (kitty) = wavefunction of a kitten, Ψ (alive) = wavefunction of a living kitten, Ψ (dead) = wavefunction of a dead kitten. By prediction and calculation, find the probability of : (a) a living kitten inside the black box; (b) a dead kitten inside the black box.

1 Answers  


Question 66 – The drag coefficient Cd = 0.05 and lift coefficient Cl = 0.4 for a levelled flow aircraft are measured. The velocity of the aircraft is v = 150 ft / s with its weight W = 2677.5 pound-force. (a) Find the value of the lift of the aircraft, L, when it is also its weight. (b) The drag of the aircraft, D = Cd M, L = Cl M. Find the value of D. (c) The power required is P = Dv. If 1 pound-force x (ft / s) = 1.356 W, find the value of P in the unit of Watt or W.

1 Answers  


How to caliculate the boil up rate, dia and height in both packed and tray distillation columns and any referance books for the design.

0 Answers  


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