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

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  


I HAVE BEEN SELECTED FOR IOCL PANIPAT INTERVIEW,ACCTUALLY IAM DOING APPRENTIES TRAINEE IN CPCL.IAM GOING TO ATTEND THE IOCL PANIPAT INTERVIEW.SO PLEASE HELP ME HOW I PREPARE FOR INTERVIEW BY SUBJECT AND ALSO BY FIELD.

0 Answers   IOCL,


What are the strategies acquired to cure tube vibration and exchangers in a shell?

0 Answers  


plz send me hpcl and reliance entrance test papers on my id s,kumar_bk@yahoo.co.in

1 Answers   Reliance,


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

0 Answers  






QUANTUM CHEMISTRY AND CHEMICAL ENGINEERING - EXAMPLE 31.10 : There are 6 spin orbitals in p subshell in a ground state carbon atom. Only 2 electrons fill the p subshell. Number of different ways for n electrons to occupy the k spin orbitals are k! / [ (n!) (k-n)! ]. Find the number of different configurations of electrons to occupy the p subshell in a carbon atom.

1 Answers  


CHEMICAL MATERIAL BALANCE - EXAMPLE 2.1 : Two methanol-water mixtures are contained in separate tanks. The first mixture contains 40.0 wt % methanol and the second contains 70.0 wt % methanol. If 200 kg of the first mixture is combined with 150 kg of the second, what are the mass and composition of the product? The symbol of weight percent is wt %.

1 Answers  


Question 109 - (a) Acceptable wavefunction in quantum mechanics in the range of : negative infinity < x < positive infinity, vanishes at least at one boundary. Which of the following is the wavefunction or are the wavefunctions of acceptable theory : P = x, P = | x |, P = sin x, P = exp (-x), P = exp (-| x |)? State the reason. (b) Let linear momentum operator P = -ih d / dz. The wavefunction is S = exp (-ikz) where i x i = -1, k and h are constants. Find the linear momentum of such wavefunction by using the term P x S.

1 Answers  


For amonia manufacturing process if pressure, temperature would be increase over optimum level what would be happen?And what steps should be taken?

0 Answers  


Explain the steps required to design a vapor-liquid separator or flash drum?

0 Answers  


UNIT OPERATION - EXAMPLE 9.4 : Acetone and ethanol are separated using a distillation column with a partial condenser and partial reboiler. An equimolar, sub-cooled liquid feed enters at 100 kmol / hr and condenses 1 mole of vapor for every 6 moles of feed. The separation requires a distillate vapor that is 95 mol % acetone and bottoms liquid that is 5 mol % acetone. The reflux is returned from the condenser to the column as a saturated liquid and the operation is run at (L / V) = 1.4 * (L / V) min. Assume constant overflow conditions. (a) Feed operating line is y = [ q / (q - 1) ] x - z / (q - 1) where z = 0.5 for equimolar liquid mixture of 2 components, q = (L'- L) / F where L' = L + F + (F / 6) for condensation of 1 mole of vapor / 6 moles of feed. What is y = f(x)? (b) The rectifying operating line is y = (L / V) x + (D / V) (xd) where (L / V) min goes through the points A (0.95, 0.95) and B (0.53, 0.69), V = L + D. What is y = f(x)? Let xd = 0.95. (L / V) min is the slope of the 2 points A and B.

1 Answers  


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

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)