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
When specifying a cooling tower, should I look up historic wet bulb temperatures for my area or should I take measurements?
send previousyear question paper for ongc gt 2011 chemical engineering written exam
What is a surfactant?
print a pattern of abcdcba abc cba ab ba a a ab ba abc cba abcdcba
how we can find solubility of liquid in amyl alcohol and relative solubility of amyl alcohol
Explain the working of a spray condenser?
Do you have any idea on recombinant protein expression?
What is a good relation to use for calculating tube bundle diameters?
What is the best way to handle bend or turns in slurry piping systems?
what is the cast iron grade of composition of c-3.06% , Mn- 0.48% , Si-2.38% , S-0.088% , P-0.092% , Cr-0.12% , Ni- 0.012% , Mo-0.00%
Explain how can you separate hydrogen peroxide into hydrogen and oxygen?
What is maximum recommended velocity for steam in a plant pipe network?
What are the criteria’s involved in choosing mass balances for components?
Why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?
Please describe tar, asphalt and bitumine