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.
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
Why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?
We wanted to know how to impart various colors to copper wire by simply dipping them into various chemicals, formulations, etc. This copper wire is to be used by us for our hobby of making various art objects from copper wire.
What is some common piping materials used to transport slurries?
List the advantages and disadvantages of a pfr?
based on percentage problems
Explain how can you determine the proper pipe thickness for a slurry line?
What do you understand by wet bulb globe temperature?
Hi, This is Naveen, plz if anybody have experience of IOCL interview, send me question.
Given, T1=600C, constant temperature of wall 800 , length of wit exchanger L=3m, dia=25 mm, Cp=14.91 KJ/kg.K, density ρ=914 kg/m3,mean velocity vm= 2 m/s, film heat transfer coefficient hf=72 Kcal/h.m2.K, what is the outlet temperature?
What diffrence between flush distillation & batch distillation ?
Please help to get IOCL/HPCL or other chemical engineering paper pls send kathir_skv@yahoo.com Regards, kathirvel
What is the procedure to estimate the friction factor involved in heat exchanger tubes?
I want to know that what type of questions may be come for fertilizer company for written exam?
Can condensate control in a reboiler cause water hammer problems?
What is the use of gear pumps in motor?