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 |
For what ration of Lengh/Dia. of tank (Jacketed tank), maximum heat transfer area is available?
Question 61 – A biochemical trolley of mass 15 kg is towing a trailer of mass 5 kg along a straight horizontal pathway. The trailer and the trolley are connected by a light inextensible tow-bar. The engine of the trolley exerts a driving force of magnitude 100 N. The trailer and the trolley experience resistances of magnitude 10 N and 30 N respectively. (a) Form 2 equations with unknowns T and a, that represents the equilibrium for the 2 systems of the trolley and trailer. (b) Solve the simultaneous equations from the 2 equations that are obtained in part (a) of this question. T is the tension of the tow-bar and a is the acceleration.
What chemical is used to expand air bags in such a short amount of time?
Explain how can I evaluate the thermal relief requirements for double block-in of 98% sulfuric acid?
who is the first atomic scientist in india?
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 are the steps required to design a vapor-liquid separator or flash drum?
What is the difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?
Please describe tar, asphalt and bitumine
Question 50 - An aqueous solution with 2.5 g of a protein dissolved in 600 cubic centimeters of a solution at 20 degree Celsius was placed in a container that has a water-permeable membrane. Water permeated through the membrane until the h - level of the solution was 0.9 cm above the pure water. (a) Calculate the absolute temperature of the solution, T in Kelvin, where T (Kelvin) = T (degree Celsius) + 273.15. (b) Calculate the osmotic pressure, P of the solution by using the formula P = hrg where h is level of the solution, r is density of water with 1000 kg per cubic meter, g = 9.81 N / kg as gravitational acceleration. (c) Calculate the concentration of the protein solution, C in kg / cubic meter. (d) Calculate the molecular weight of the protein, (MW) = CRT / P where R = 8.314 Pa cubic meter / (mol K) as ideal gas constant.
What is the reason for removing silicon from aluminum?
What is a good approximation for the heat transfer coefficient of hydrocarbons inside 3/4" tubes?
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)