ENGINEERING MATHEMATICS - EXAMPLE 8.4 : 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 / kangchuentat
ENGINEERING MATHEMATICS - ANSWER 8.4 : 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
Explain the factors involved in designing kettle type reboiler?
What are the some common causes of control valve noise?
Can large temperature differences in vaporizers cause operational problems?
What are the effects of oils on the properties of Polyolefins?
What are the criteria’s involved in choosing mass balances for components?
Are there any general rules for flushing slurry lines?
What is a good device to use for obtaining viscosity data for a non-newtonian fluid?
Define pneumatic conveying?
Explain the method adopted to minimize shell side pressure drop in a shell?
How can you quickly estimate the horsepower of a pump?
How can you separate hydrogen peroxide into hydrogen and oxygen?
i m a frsh chemical engineer now i m confuse to attend the interview so anybody pls send model question papers to this christ_vivek33@yahoo.com
What are the specialized crushing methods?
what is mean by chemical engineering and its scope in industry
Define viscosity?