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

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

2376


When should one be concerned with the tube wall temperature on the cooling waterside of a shell and tube exchanger?

1020


What is the purpose of capacitor?

1974


Is there a difference in mtd (mean temperature difference) between 'e' and 'j' (divided flow) type shell and tube heat exchangers?

1080


solution =2oolitre ,solute =Polyelectrolyte,Solution=water ,we have to prepare 1% solution.how much solute And Solvent?

2236


what are the chemicals used in PFR and MFR to Process?

3210


What is a good relation to use for calculating tube bundle diameter?

1013


What are the steps taken to operate a tank-blanketing valve?

1157


Explain the procedure to estimate the friction factor involved in heat exchanger tubes?

1084


What is an isochoric process?

1109


What are the reasons of removal of particles from effluent gas?

1070


i want sample inteview question of chemical engg for BARC

3124


What is the difference between horizontal and vertical heat exchanger?

1287


Explain the largest application for surfactants?

1063


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?

2273