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
hello everyone do anyone have interview questions for any chemical industry please email me at
Explain the some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?
What is a good approximation for the heat transfer coefficient of hydrocarbons inside 3/4" tubes?
What are some good tank mixing rules of thumb?
How can you estimate the efficiency of a pump?
What is a 'saltation velocity' and how is it used in designing pneumatic conveying systems?
How can separation of chiral chemicals affect the chemical and/or pharmaceutical industries?
Name the some common problems associated with bellow expansion joints?
How much will be the increment for postal assistant yearly?
What is a good source of information for the design of pressure vessels?
What is a black body?
Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel
What is % of piping & equipment cost for a chemical plant having batch process?
Hi.. Me going to tke test for management trainee(technical) Post I am an chemical engineering student . Can u guide how to prepare for this test.Can u send me test paper pattern..?
What are the steps taken to operate a tank-blanketing valve?