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

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

0 Answers  


Question 42 - According to Margules Equation, P = x(1) p(1) g(1) + x(2) p(2) g(2) for a two-component mixture where P is bubble pressure, x is mole fraction, p is saturation pressure, g is constant given by ln g(1) = x(2) A x(2). Find the value of A as a constant when P = 1.08 bar, p(1) = 0.82 bar, p(2) = 1.93 bar in a 50 : 50 mole fraction mixture. Estimate the pressure required to completely liquefy the 30 : 70 mixture using the same equation, by proving P = 1.39 bar. Take note that ln g(2) = x(1) A x(1), ln g(1) = x(2) A x(2).

1 Answers  


ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.33 : An engineering corporation that produces a type of healthy food has A number of shares of $B preferred stock and C number of shares of $H common stock outstanding. In a typical financial year, let the net income obtained = D. The amount retained by the corporation = E. (a) Calculate the amount of money distributed to the shareholders if : (i) D > E; (ii) D = E; (iii) D < E. (b) Let preferred dividend = F, common dividend = G, CH > G. Find the values of F and G, in term of A, B, D and / or E when : (i) (D - E) > AB; (ii) (D - E) < AB; (iii) (D - E) = AB.

1 Answers  


What are the specialized crushing methods?

0 Answers  


What are some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?

0 Answers  






Question 38 - The terminal velocity of a falling object, v is given by v = sqrt [ 4g (R - r) D / (3Cr) ] where sqrt is the square root of, g = 9.81, D = 0.000208, R = 1800, r = 994.6, m = 0.000893. The Reynold number, L is given by L = rD (v) / m. The C for various conditions are : C = 24 / L for L < 0.1; C = 24 (1 + 0.14 L^0.7) / L for 0.1 <= L <= 1000; C = 0.44 for 1000 < L <= 350000; C = 0.19 - 80000 / L for 350000 < L. Find the value of v for the situation above by trial and error, ^ is power, <= is less than or equal to.

1 Answers  


How many pounds (lb) are available in 1 kilogram (kg), 1 metre (m) has how many feet (ft) and 1 meter (m) has how many inches (in)?

1 Answers  


Explain the Deacon reaction?

2 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  


What is the chemical name of Silica gel?

2 Answers  


print a pattern of abcdcba abc cba ab ba a a ab ba abc cba abcdcba

0 Answers  


What are the some common causes of control valve noise?

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)