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
What is the Import Procurement Cycle ? and what are the customization steps in SAP ?
Hallow everybody, we want to know in a NPk fertilizer process plant (Bulk Blender) we are in doubt if use square or rectangular hopper jus to avoid the vault effect durin the flow of of raw material like Phosphorus, Potasium and zeolite..Please any advise will be appresated Isdray
Explain what is a quick way to calculate frictional pressure drops in carbon steel pipe?
What is the easiest way to extract hydrogen from water and the safest way to store it?
What is difference between overall heat transfer coefficient & individual heat transfer coefficient?
hai can anyone send me soft copy of o.p gupta or tell me downloading link please please at saify_0@hotmail.com
What are some common precipitating agents used to remove metals from aqueous waste streams?
How much will be the increment for postal assistant yearly?
Name some common problems associated with dense phase pneumatic conveying?
What are some good strategies for curing tube vibration in shell and tube exchangers?
What are some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?
Explain what is the significance of the minimum flow required by a pump?
Explain what is the best way to configure a bypass line in slurry services?
Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel
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