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).
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 |
Question 81 - (a) In natural gas pipe sizing, the length of the pipe from the gas source metre to the farthest appliances is 60 feet. The maximum capacities for typical metallic pipes of 60 feet in length are : 66 cubic feet per hour for pipe size of 0.5 inches; 138 cubic feet per hour for pipe size of 0.75 inches; 260 cubic feet per hour for pipe size of 1 inch. By using the longest run method : (i) Find the best pipe size needed for the capacity of 75 cubic feet per hour. (ii) Estimate the suitable range of capacities for the pipe size of 1 inch. (b) The maximum capacities for typical metallic pipes of 50 feet in length are : 73 cubic feet per hour for pipe size of 0.5 inches; 151 cubic feet per hour for pipe size of 0.75 inches; 285 cubic feet per hour for pipe size of 1 inch. By using the branch method find the best pipe size needed for the capacity of 75 cubic feet per hour when the length of the pipe from the gas source metre to the appliance is 52 feet.
What are the advantages and disadvantages of using gear pumps?
what is mass flow rate of steam of 7 kg/cm2 pressure in 1 inch id. pipe.
why screw compressor use for ammonia compression?
my qualification is b.tech- industrial biotech. i was read about many chemical engineering subject as a allied like unit operation, chemical thermodynamics, chemical reaction engineering , mass transfer and separation, downstream processing and principle of chemical engineering. and i have 2 yrs working exprience on in the field of instrumentation and control... and my query is "can i able work as process technologist" and which subject i want conc. more?........
In engineering economy, the future value of first year is FV = PV (1 i). For second year it is FV = PV (1 i) (1 i). For third year it is FV = PV (1 i) (1 i)(1 i) where FV = future value, PV = present value, i = interest rate per period, n = the number of compounding periods. By induction, what is the future value of $1000 for 5 years at the interest rate of 6%?
Explain how can you separate hydrogen peroxide into hydrogen and oxygen?
Whal will be the HRC fuse rating of a 3phase 415V,50Hz,0.85pf,95%efficiency,30KW,1450rpm induction motor,starting with a DOL starter.and describe the Fuse rating calculation.
What factors should be compared when evaluating cooling tower bids?
DIFFERENTIAL EQUATIONS - EXAMPLE 20.3 : A differential equation is given as y” + 5y’ + 6y = 0, y(0) = 2 and y’(0) = 3. By using Laplace transform, an engineer has correctly produced the equation L {y} = (2s + 13) / [(s + 2)(s + 3)] = A / (s + 2) + B (s + 3). (a) Find the values of A and B. (b) The inversed Laplace transform of 1 / (s + a) is given by exp (-at) where a is a constant. If the statement : L {y} = 9 L { exp (-2t) } - 7 L { exp (-3t) } is correct, find the equation of y as a function of t as a solution to the differential equation stated in the beginning of this question. When L {d} = 9 L {b} - 7 L {c}, then d = 9b - 7c with b, c and d are unknowns.
what is the relation between velocity & pressure. tel me if pressure in water line is increased what wil b effect on velocity ?
Explain how can you determine the largest impeller that a pump can handle?
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)