Question 30 – Solve the simultaneous equation using simple Excel program :

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).

Question Posted / kang chuen tat (malaysia - pen

1 Answers
2512 Views
I also Faced
E-Mail Answers

Question 30 – Solve the simultaneous equation using simple Excel program : r + s – t = 7..

Answer / 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

More Chemical Engineering Interview Questions

plz send the interview questions in the written test asked by hindustan petroleum corporation ltd.Iam a b>tech in chemical engineering.My written test is on feb 2008.urgent plz.send the questions to avazithraja@rediffmail.com

9 Answers AZTEC, Bapex, HPCL,

i need formula for calculating discharge of river, the data i have is variation of water pressure, variation of air pressure,depth of water and length of river. please i need help

1 Answers

Explain how can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?

0 Answers

What is the maximum steam pressure that can be generated?

0 Answers CPCL,

How many pounds (lb) are available in 1 kilogram (kg), 1 metre (m) has how many feet (ft) and 1 meter (m) has how many inches (in)?

1 Answers

Difference between Synthetic foaming agents V/S Protien based foaming agent?

0 Answers

can u tel me d question paper of gail?

0 Answers HPCL,

Explain some common piping materials used to transport slurries?

0 Answers

ENGINEERING NUMERICAL METHODS - EXAMPLE 19.3 : There are 2 simultaneous equations : (A1) x + (B1) y = D1 and (A2) x + (B2) y = D2. (a) By using Excel program, find the values of x and y when A1 = 80, A2 = 150, B1 = 52, B2 = 100, D1 = 3.5 and D2 = 2.3. (b) Write the expression of Excel in the form of =MMULT(MINVERSE(W:X),Y:Z) in order to get the values of x and y. W, X, Y and Z may be A1, A2, B1, B2, D1 and D2.

1 Answers

UNIT OPERATION - EXAMPLE 9.3 : In the distillation of binary systems by Mc Cabe Thiele method, the equation for the line of top section is given by y = [ R / (R + 1) ] x + XD / (R + 1). 2 points on the line are (0.99, 0.99) and (0, 0.36). Find the reflux ratio of R and XD.

1 Answers

What is the practical particle size limit for pneumatic conveying?

0 Answers

What are flameless oxidizers?

0 Answers

For more Chemical Engineering Interview Questions Click Here