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
How many years you are having experience in supervising others in lab environment?
What are the problems that are associated with the expansion joints?
PLZ ANYONE SEND ME PLACEMENT PAPERS OF I.O.C.L MY ID---- gaurav.nitw.5609@gmailcom
What is the largest application for surfactants?
What are the some common causes of control valve noise?
I am pg student of chemical engg. I am intrested Heat Transfer Subject . I want information about advance heat transfer related PG PROJECT
Explain what are the methods involved to test helium leak testing in a vacuum system?
What are the criteria’s involved in choosing mass balances for components?
What are some guidelines for designing for liquid and gas velocities in process plant piping?
how should i prepare for my placements.i am a student of chemical eng,final year,thapar university
Corenuts technology interview questions
how will we calculate the heat of formation through electron...??
In a Furnace arch pressure is more than Hearth pressure,then how flue gas travels to stack
In Pressure Sfety Valve(PSV) 2" by pass line why given for process units.
How can you estimate the efficiency of a pump?