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 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
oil field interview question
I am currently doing my btech in computer science in Coimbatore.I had intererest to do btech in chemical enginerring but couldnt get a seat. Now what are my options ,scope and future if i take mtech in chemical enginerring? And can i apply for any deemed colleges for mtech chemical enginerring through gate taking my present state into consideration(btech in cse and mtech in chemical enginerring)
wha is Adsorption column chromatography?
What is difference between Piping Standard & Piping Specification ?
How can you keep our seawater used for heat rejection clean before entering our heat exchangers?
What are the assumptions made on conservation equation?
In Galvonised iron and stainsteel pipes, in which pipe friction losses will more and why ?
What is carbon sequestration?
What are the effects of oils on the properties of Polyolefins?
How can you quickly estimate the horsepower of a pump?
What is the method involved in analyzing powders for composition?
Re: Sugar Cane Bagasse What are the 1. Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture? 2. What is bu;lk density of bagasse at 50% moisture, 40% moisture and 25% moisture? 3. What is specific gravity of bagasse at 50% moisture, 40% moisture and 25% moisture? 4. What is the specific heat of flue gases generated from boiler fuelled by bagasse? 5. What is the specific gravity of flue gases generated from boiler fuelled by bagasse?
Explain the different types of equipments for the conveyance of solids?
Hi, I want to validate an analytical procedure of a specified impurity, but this impurity is unavailable for me. can I use the API instead of impurity in the linearity test? in Which reference can I find such information?
Please colleagues I need to choice a proper hopper shape for a Fertilizer bulk blender flowing throut a high humidity raw material like zeolite, so we are in doubt whether use squard or rectangular hopper shape to avoid the so call voul effect that can create obstruction