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 whenever a reciprocating compressor is switched ON or OFF it is put into unloading mode?
Explain how can viscosity affect the design of a mixer?
What type of pump may be appropriate for a liquid near saturation, a low flow rate, and very limited npsha (net positive suction head available)?
Define pneumatic conveying?
what is mean by chemical engineering and its scope in industry
Explain what are the methods involved to test helium leak testing in a vacuum system?
sir, kindly explain to me that how to calculate volume of torrispherical vessel which is used in pharma company ss reactor bottom dish volume. thank u.
What are demand of crotonaldehyde99% in the worldand its international market ?
What factors go into designing the vapor space of kettle type reboiler?
What chemical is used to expand air bags in such a short amount of time?
friends....i have been searching the model paper for HPCL officer trainee for chemical eng....tat apptitude section...if u people got any information regarding tat...please send me to my mail...my id is: maruthu.flower@gmail.com...pls send me wtever information u knew....thank u....
Explain what is the significance of the minimum flow required by a pump?
What is the import procurement cycle? What are the customization steps in sap?
Repected sir/Madam, I am goingb to face IOCL technical as well as HR interview, can you forward your hellpfull hand for toward me to sort out my problem by giving some imp interview quetion which is generally asked in chemical industries such like IOCL,HPCL,ONGC,BPCL,RIL,etc I will always thankfull to you,for sharing your profficient knowledge with me and making me somewhat technically sound
How can wet carbon dioxide be responsible for a corrosion problem in iron-containing metals?