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
- 1845 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
The process conditions of the fuel gas are as follows: Temperature = 25 deg C Pressure = 4 bar g Calculate the line size for the fuel gas supply line to the superheater
What compounds are responsible for the odors that come from wastewater treatment plants?
How can hexavalent chromium be removed from aqueous waste streams?
What are some common precipitating agents used to remove metals from aqueous waste streams?
What are the merits of using a falling film evaporator?
At what temperature is glass fused to steel in the making of glass-lined equipment?
What are the types of load?
Define viscosity?
How can one determine if a particular solid can be fluidized as in a fluidized bed?
Define condensate lift?
What type of heat exchangers are most commonly used for a large-scale plant-cooling loop using seawater as the utility?
hi can anyone tell me some technical questions asked in iocl
Are there any special considerations to be taken into account for combusting ammonia?
What is the largest application for surfactants?
What is the import procurement cycle?
