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
- 1854 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
Define an additive?
When should one be concerned with the tube wall temperature on the cooling waterside of a shell and tube exchanger?
For what ration of Lengh/Dia. of tank (Jacketed tank), maximum heat transfer area is available?
What industries require filtered compressed air?
Name the some common problems associated with bellow expansion joints?
Name some common causes of control valve noise?
Explain why does catalytic converter used in an automobile?
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?
send previousyear question paper for ongc gt 2011 chemical engineering written exam
whats the allowed tolerance of pipe to pipe butt joint mismatching
Explain the different ways in which solids can be blended?
I want to know that what type of questions may be come for fertilizer company for written exam?
How can you prevent bridging in a dilute phase pneumatic conveying system?
Name some guidelines for designing for liquid and gas velocities in process plant piping?
What are flameless oxidizers?
