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).
- 1 Answers
- 1992 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Name the some common problems associated with bellow expansion joints?
What industries require filtered compressed air?
Are you having any experience in antibody designing?
Explain the method of determining maximum differential pressure during hydro testing of shell and tube heat exchangers?
What are the advantages and disadvantages of using gear pumps?
Why is post-weld heat treatment (stress relieving) sometimes necessary for welded vessels?
Name the three classes of organic solvents?
Explain what are some typical applications for glass-lined reactors?
Is there a rule of thumb to estimate the footprint of a cooling tower during design phase?
How can you estimate a gas flow based on two pressure measurements?
solution =2oolitre ,solute =Polyelectrolyte,Solution=water ,we have to prepare 1% solution.how much solute And Solvent?
What are the greenhouse gases in earth's atmosphere?
DEAR SIR, IS IT ANY BARC TECHNICAL OR INTERVIEW QUESTION BOOK IN CHEMICAL ENGG LAST YEARS IN MARKET? ALSO GIVE THE PATTERN HOW TO PREPARE AND WHAT TYPE OF QUESTION THEY ASKED?
I want previous year question paper of ONGC for chemical engg.
Explain how can I evaluate the thermal relief requirements for double block-in of 98% sulfuric acid?
