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.
- 1 Answers
- 1662 Views
- I also Faced
- E-Mail Answers
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
What is a good estimate for the absolute roughness for epoxy lined carbon steel pipe?
What are the strategies acquired to cure tube vibration and exchangers in a shell?
How can arsenic be removed from aqueous waste streams?
need the type of technical questions in written test
What are the problems that are associated with the expansion joints?
Name some common problems associated with dense phase pneumatic conveying?
Define wet bulb globe temperature?
how will we calculate the heat of formation through electron...??
Explain under what circumstances are vortex flowmeters the most accurate?
have any one question paper of institute of plasma research center for aptitute as well as technical?
I am pg student of chemical engg. I am intrested Heat Transfer Subject . I want information about advance heat transfer related PG PROJECT
could any one plzz give me the placement tech papers taken by iocl,and bpcl in chemical stream..... my id is.... mishra.gaurang@gmail.com
Dielectric materials in static fields
design calculations for reactor
What is the method of determining maximum differential pressure during hydro testing of shell and tube heat exchangers?
