Question 32 – 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.
Answer Posted / kang chuen tat (malaysia - pen
Answer 32 : 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 View All Answers
What is a good way to get started in doing a plant-wide steam consumption analysis?
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
based on percentage problems
sir i am appearing in railway exam of section engineer and my branch is chemical engineering i want previous question paper of section engineer of chemical branch please tell me as soon as possible my email id is surendrasaroj18@gmail.com THANKYOU
How to caliculate the boil up rate, dia and height in both packed and tray distillation columns and any referance books for the design.
Explain how can one quickly estimate the additional pressure drop to be introduced with more tube passes?
How can you keep our seawater used for heat rejection clean before entering our heat exchangers?
What industries require filtered compressed air?
Why does catalytic converter used in an automobile?
What is a good device to use for obtaining viscosity data for a non-newtonian fluid?
What is a barometric condenser?
What is the maximum recommend pipe velocity for dry and wet gases?
What are some good tank mixing rules of thumb?
Explain the method adopted to minimize shell side pressure drop in a shell?
Is there a rule of thumb to estimate the footprint of a cooling tower during design phase?