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 the difference between horizontal and vertical heat exchanger?
Explain what are the disadvantages of using gear pumps?
Plz if anybody has placement paper of HAL mail me i m Chemical engg my id er.kotnala@gmail.com
What does the catalytic converter on an automobile do?
Explain the different characteristics that can affect the flow of bulk solids and how?
What is the basic difference between dispersion & distribution in any polymer blend or alloy??
How does hollow shaft impeller works? Does it based on principle of pitot tube?
What is the most common carrier gas used in pneumatic conveying?
What is the average salary for chemical engineers?
Mention some of the specialized grinding methods?
Explain the use of gear pumps in motor?
How can you quickly estimate the horsepower of a pump?
How can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?
sir,please give me some exam paper for referance. Thanks & Regards,
how does refractive index detector work?