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

Water flows through a pipe with circular cross sectional area at the rate of V / t = 80 L / s where V is the volume and t is time. Let Av = 80 L / s where A is cross sectional area and v is velocity of fluid. For point 1, the radius of the pipe is 16 cm. For point 2, the radius of the pipe is 8 cm. Find (a) the velocity at point 1; (b) the velocity at point 2; (c) the pressure at point 2 by using Bernoulli’s equation where P Rgy 0.5 RV = constant. P is the pressure, R = density of fluid, V = square of fluid’s velocity, g = gravitational constant of 9.81 N / kg and y = 2 m = difference of height at 2 points. The pressure of point 1 is 180 kPa.

1 Answers  


could anyone send me model question papers or outline of graduate trainee(chemical engg) post?

0 Answers   NPCIL,


BIOPROCESS ENGINEERING - EXAMPLE 14.1 : In differential centrifugation of cells with diameter D in centimeter, the square of D is given by D x D = [18n ln (RF / RI) ] / [ (RP - RFF) Wt ] where n is the fluid viscosity (poise), RF is the final radius of rotation (cm), RI is the initial radius of rotation (cm), RP is cell density (g / ml), RFF is the fluid density (g/ml), W the square for the rotational velocity in (radians / s) (radians / s), t is the time required to sediment from RI to RF (s). Derive an equation for W as a function for D, n, RF, RI, RP, RFF and t, with the stated units above, in radian & degree.

1 Answers  


what is meaning of pid how it is useing controlers

4 Answers  


What is the maximum permissible Earth to Neutral voltage in an electrical system.

0 Answers  






Why whenever a reciprocating compressor is switched ON or OFF it is put into unloading mode?

0 Answers  


Question 51 - A batch reactor is designed for the system of the irreversible, elementary liquid-phase hydration of butylene oxide that produces butylene glycol. At the reaction temperature T = 323 K, the reaction rate constant is k = 0.00083 L / (mol - min). The initial concentration of butylene oxide is 0.25 mol / L = Ca. The reaction is conducted using water as the solvent, so that water is in large excess. (a) Let the molecular weight of water is 18 g / mol and the mass of 1 kg in 1 L of water, calculate the molar density of water, Cb in the unit of mol / L. (b) Determine the final conversion, X of butylene oxide in the batch reactor after t = 45 min of reaction time. Use the formula X = 1 - 1 / exp [ kt (Cb) ] derived from material balance. (c) Find the equation of t as a function of X.

1 Answers  


PLEASE ANY ONE READ THIS MESSAGE ANSWER ME AT MY EMAIL ID surendrasaroj18@gmail.com sir i am prepairing for section engineer exam taken by railway my branch is chemical engineering i want previous paper of chemical engineering of section engineer exam taken by railway. please answer me as soon as possible thankyou

0 Answers  


ENGINEERING NUMERICAL METHODS - EXAMPLE 19.2 : For a mixture of benzene (B), toluene (T) and xylene (X), the equation applies where x for B, T and X will sum up to 1. The equation of x for each component is x = (L / V + 1) (F) / (L / V + K). The data of F for each component are : 0.5 for B, 0.35 for T, 0.15 for X. The data of K for each component are : 1.98 for B, 0.76 for T, 0.24 for X. When x for B + x for T + x for X = 1, find the values of (a) L / V; (b) x for each component of B, T, X respectively. You may use Excel program - Data : What-If-Analysis for Goal Seek to perform the iterative calculations.

1 Answers  


On what basis are materials to be crushed evaluated apart from size?

0 Answers  


Dear guys we adding hypo at climax plant and that water is inlet to DM plant so with hypo water that can affect my resins of cation and anion. if it is affect life of my anion and cation so what kind of steps should be take.

0 Answers   Hindustan Unilever Limited,


What is the principles of crayogenic expansion turbin

1 Answers   Goyal Group,


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)