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 condensate lift?
Please colleagues I need to choice a proper hopper shape for a Fertilizer bulk blender flowing throut a high humidity raw material like zeolite, so we are in doubt whether use squard or rectangular hopper shape to avoid the so call voul effect that can create obstruction
What is the most common carrier gas used in pneumatic conveying?
What is some good advice for specifying allowable pressure drops in shell and tube exchangers for heavy hydrocarbons?
How much will be the increment for postal assistant yearly?
Explain the steps taken to operate a tank-blanketing valve?
Why whenever a reciprocating compressor is switched ON or OFF it is put into unloading mode?
What is the difference between horizontal and vertical heat exchanger?
Why is double the amount of gas collected in one of the test tubes in electrolysis of water than th amount collected in the other? Name this gas?
Explain the different types of equipments for the conveyance of solids?
What are the customization steps in sap?
Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel
What is a quick way to calculate frictional pressure drops in carbon steel pipe?
pleas tell me about chemical engineering apptitude test..
How can you quickly estimate the horsepower of a pump?