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
i am a student of thapar university final year.can anybody please help me with the exam pattern of the companies:engineers india ltd. ; iocl ; UOP, HPCL. If psbl plz send me the previous years questions on this email id k_arora1987@yahoo.com. i d be really greatful
When should one be concerned with the tube wall temperature on the cooling waterside of a shell and tube exchanger?
What is the purpose of capacitor?
Is there a difference in mtd (mean temperature difference) between 'e' and 'j' (divided flow) type shell and tube heat exchangers?
solution =2oolitre ,solute =Polyelectrolyte,Solution=water ,we have to prepare 1% solution.how much solute And Solvent?
what are the chemicals used in PFR and MFR to Process?
What is a good relation to use for calculating tube bundle diameter?
What are the steps taken to operate a tank-blanketing valve?
Explain the procedure to estimate the friction factor involved in heat exchanger tubes?
What is an isochoric process?
What are the reasons of removal of particles from effluent gas?
i want sample inteview question of chemical engg for BARC
What is the difference between horizontal and vertical heat exchanger?
Explain the largest application for surfactants?
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?