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
Hi, I am Gurunathan. I am in need of ONGC, IOCL, DRDO technical test ( chemical engineering)and general aptitude questions. If anyone has kindly post it to me soon.
Explain how can you estimate a gas flow based on two pressure measurements?
How to caliculate the boil up rate, dia and height in both packed and tray distillation columns and any referance books for the design.
hi can u send me all d technical qus pepar of DRDO?my email id is palmzk@gmail.com
what is the difference between car seal close/open valves and lock close/open valves?
Explain what are flameless oxidizers?
What is a good device to use for obtaining viscosity data for a non-newtonian fluid?
What is a good source of surfactant information on the internet?
Hi, This is Naveen, plz if anybody have experience of IOCL interview, send me question.
Dear sir/madam I am in final year BE chemical engineering.Which companies i can apply .Please guide me.It is very helpful for me
how should i prepare for my placements.i am a student of chemical eng,final year,thapar university
Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel
What's -74C, dew point is better the -70C dew point In draying unit .
how did you spend today
Explain some of the consequences of an undersized kettle type reboiler?