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.
- 1 Answers
- 1889 Views
- I also Faced
- E-Mail Answers
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
How can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?
Are there any general rules that should be considered when designing a slurry piping system?
Can large temperature differences in vaporizers cause operational problems?
What are the factors involved in considering the choice of dry screw compressor?
what is designing step of heat exchanger
Is there any way to remove residual product left in pipes after a batch operation?
In case of welded vessels why is stress relieving in the form of post-weld treatment necessary?
hi can anyone tell me some technical questions asked in iocl
hai i A neelakanteswara rao ,selected for the interview on 15th july 2008. I completed my diploma in chemical engineering.let me know how to face the interview& the type of technical questions.
Explain the common failure mechanism for above ground atmospheric storage tanks?
What are the some common problems associated with dilute phase pneumatic conveying?
Mention some of the specialized crushing methods?
y we do not differ b/w atomic mass and atomic wieght? from engrtauseef2008@gmail.com
Why are decomposition reactions called the opposite of combination reactions?
I would like to know how to size a partial combustion reactor processing methane and oxygen, as a function of the flowrate and of the pressure.
