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).
Answer Posted / 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 View All Answers
Explain the reasons of removal of particles from effluent gas?
sir, kindly explain to me that how to calculate volume of torrispherical vessel which is used in pharma company ss reactor bottom dish volume. thank u.
why 14.7 pound/inch2 is used in idustries as unit of pressure bcz here not sea level and not a temperature is 0C (zero degree celcius)?????????
What are the problems that are associated with the expansion joints?
For amonia manufacturing process if pressure, temperature would be increase over optimum level what would be happen?And what steps should be taken?
Explain some common piping materials used to transport slurries?
What diffrence between flush distillation & batch distillation ?
What are the criteria’s involved in choosing mass balances for components?
Are you having any experience in antibody designing?
what is isochronus and droop speed?
What is the ignition temp. of Alluminium,Coper&Iron.
Hi, Please give me chemical engineering paper for IOCL exam for entire written exam, GD and personel interview model questions to my email id. (chemistnathan@rediffmail.com) Rgds, Ragu
Name some common problems associated with dilute phase pneumatic conveying?
What is a cstr and what are its basic assumptions?
Explain the method adopted to minimize shell side pressure drop in a shell?