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 can viscosity affect the design of a mixer?
What is difference between overall heat transfer coefficient & individual heat transfer coefficient?
what is the purpose of capacitor? and capacitor load means what? how does it connect?
How can we derive power factor equation p=vi cos phi?
How can metals be removed from aqueous waste streams?
What are the some common causes of control valve noise?
Are there any special considerations to be taken into account for combusting ammonia?
is extractive distillationӞH
Explain the some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?
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
Define wet bulb globe temperature?
how will we calculate the heat of formation through electron...??
Explain the advantages of using a ball mill over other conventional methods of crushing?
When specifying a cooling tower, should I look up historic wet bulb temperatures for my area or should I take measurements?
DEAR SIR, IS IT ANY BARC TECHNICAL OR INTERVIEW QUESTION BOOK IN CHEMICAL ENGG LAST YEARS IN MARKET? ALSO GIVE THE PATTERN HOW TO PREPARE AND WHAT TYPE OF QUESTION THEY ASKED?