ENGINEERING MATHEMATICS - EXAMPLE 8.4 : Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. B

ENGINEERING MATHEMATICS - EXAMPLE 8.4 : Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. By using the Excel computer programming - either by Solver or Goal Seek, find the value of v for the Van der Waals equation (P - a / v ^2) (v - b) = RT where a = 18.82, b = 0.1193, P = 2, R = 0.082, T = 5000 for benzene. Describe briefly how to use Solver and Goal Seek in Excel program of computer to find the solution quickly.

Question Posted / kangchuentat

1 Answers
2102 Views
I also Faced
E-Mail Answers

ENGINEERING MATHEMATICS - EXAMPLE 8.4 : Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. By using the Excel co..

Answer / kangchuentat

ENGINEERING MATHEMATICS - ANSWER 8.4 : Rearranging the equation gives P v^3 - (Pb + RT) v^2 - av + ab = 0. By using Excel program of computer v = 0.19322. Solver : FILE -> Options -> Add-Ins -> Solver Add-in. Goal seek : DATA -> What-If-Analysis -> Goal Seek. In both functions, Set cell / Objective, To value / Value Of, By changing cell / Changing Variable Cells should be used where To value / Value Of = 0, By changing cell / Change Variable Cells is the assumed v value, Set cell / Objective is the equation of function. 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

How much steam required for 1MW power production form 30 bar G super heated steam(350 C), outlet of turbine 4.5 bar

0 Answers

repected sir i have given gate exam today.......... if i ll get the better rank in that ....what is the next process .....shall i give another one test......or wat....i dint get properlly..... plz help me or mail me on Nish_gasti@yahoo.co.in

0 Answers IOCL,

how can I find out a sulfuric acid recovery plant disigner?

0 Answers ONGC,

What is the process of including heat exchangers in ammonia refrigeration system?

0 Answers

On what basis are materials to be crushed evaluated apart from size?

0 Answers

Can any one send me the sample test papers of IOCL entry exam to be held on 6th july 2008. Also plz send the interview questions that cud probably be asked........i wud be highly obliged if u can send a few test paers and other stuff @ inderjeetd@gmail.com.........Inderpreet

0 Answers IOCL,

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

Explain the factors involved in considering the choice of dry screw compressor?

0 Answers

What is a "saltation velocity"?

0 Answers

What is the purpose of capacitor? What does capacitor load means? How does it connect?

0 Answers

Explain the different types of equipments for the conveyance of solids?

0 Answers

Why methanol like petroleum compounds are stored in underground storage tanks?

2 Answers MPCL, NFIL, Reliance, UPL,

For more Chemical Engineering Interview Questions Click Here