Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How can viscosity affect the design of a mixer?

1059


What is difference between overall heat transfer coefficient & individual heat transfer coefficient?

1071


what is the purpose of capacitor? and capacitor load means what? how does it connect?

2360


How can we derive power factor equation p=vi cos phi?

1006


How can metals be removed from aqueous waste streams?

950


What are the some common causes of control valve noise?

1022


Are there any special considerations to be taken into account for combusting ammonia?

1151


is extractive distillationӞH

2117


Explain the some guidelines for sizing a psv for a fire scenario on a vessel in a refinery service?

1041


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

2449


Define wet bulb globe temperature?

1024


how will we calculate the heat of formation through electron...??

2106


Explain the advantages of using a ball mill over other conventional methods of crushing?

980


When specifying a cooling tower, should I look up historic wet bulb temperatures for my area or should I take measurements?

1092


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?

3635