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 are the effects of oils on the properties of Polyolefins?
Name the some common problems associated with bellow expansion joints?
What is the wet bulb globe temperature?
What is the wet bulb globe temperature (wbgt)?
What does the catalytic converter on an automobile do?
What is carbon sequestration?
Is four stage graphite steam jet ejector is possible. Any body can provide its design
What are some guidelines for designing for liquid and gas velocities in process plant piping?
What is the purpose of capacitor? What does capacitor load means? How does it connect?
Corenuts technology interview questions
what is load and what are the types of load?
What are the disadvantages of using gear pumps?
In a Furnace arch pressure is more than Hearth pressure,then how flue gas travels to stack
what is the hearth and arch pressure in furnace?
What are the advantages and disadvantages of using gear pumps?