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
What are the advantages of using a ball mill over other conventional methods of crushing?
Explain what information is needed to specify a mixer?
What is the maximum recommend pipe velocity for dry and wet gases?
hello everyone do anyone have interview questions for any chemical industry please email me at ravijallu.nitj@gmail.com
A shiny brown colored element ‘x’ on heating in air becomes black in cooler name the element ‘x’and black colored compound formed?
What is some common piping materials used to transport slurries?
I HAVE DOMAIN KNOWLEDGE IN PROCESS MANUFACTURINGAND I GOT AN APPARTUNITY AS A BUSINESS ANALYST AND I DNT HAVE ANY KNOWLEDGE ON ORACLE APPS/GIVE ME ANY VALUBLE SUGGESTION?
What are the assumptions made on conservation equation?
how we can find solubility of liquid in amyl alcohol and relative solubility of amyl alcohol
What are pcbs?
How are vessel lined with glass or how are they coated?
What are some of the consequences of an undersized kettle type reboiler?
Can any one send me the sample test papers of IOCL entry exam to be held on 6th july 2008. Also plz send the interview questions that cud probably be asked........i wud be highly obliged if u can send a few test paers and other stuff @ inderjeetd@gmail.com.........Inderpreet
Define wet bulb globe temperature?
What type of flow measurement devices is best for slurries?