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 - 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 |
Why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?
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).
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.
What are the specialized crushing methods?
What are some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?
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.
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)?
Explain the Deacon reaction?
How to caliculate the boil up rate, dia and height in both packed and tray distillation columns and any referance books for the design.
What is the chemical name of Silica gel?
print a pattern of abcdcba abc cba ab ba a a ab ba abc cba abcdcba
What are the some common causes of control valve noise?