Question 32 – 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.



Question 32 – Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. By using the Excel computer programming &..

Answer / kang chuen tat (malaysia - pen

Answer 32 : 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

More Chemical Engineering Interview Questions

ENVIRONMENTAL ENGINEERING - QUESTION 22.3 : A well delivers 225 US-gallons per minute of water to a chemical plant during normal system operation. (a) Calculate its flowrate in the unit of mega US-gallon per day or MGD. (b) The following formula is written next to the chlorine feed point : (chlorine feed rate, lb / day) = (flowrate, MGD) X (dose, mg / L) x (8.34). If this formula is correct, then what should the chlorine feed rate to be in pounds per day (lb / day) if the desired dose is 2 mg / L. (c) Prove by calculations that the constant 8.34 in the formula next to the chlorine feed point is correct. Let 1 US-gallon = 3.78541 L and 1 mg = 0.0000022046 pound.

1 Answers  


What is the maximum permissible Earth to Neutral voltage in an electrical system.

0 Answers  


What does the catalytic converter on an automobile do?

0 Answers  


How to caliculate the boil up rate, dia and height in both packed and tray distillation columns and any referance books for the design.

0 Answers  


Suggest the best book for barc written test guide me the syllabus

1 Answers  






what are lubricants using in compression.

1 Answers  


How can you control the ph level in our cooling water with respect to ammonia contamination?

0 Answers  


GENETIC ENGINEERING - EXAMPLE 27.2 : (a) Three genes, I, J and K are available. All these genes are linked with respect to one another. If the percent recombination between I and J is 8 %, that between J and K is 10 %, and that between K and I is 18 %, what is the order of the gene? (b) Twenty six genes, a, b, c, d, e, f, ... x, y and z are available. All these genes are linked with respect to one another. If the percent recombination between a and b is 3 %, between b and c is 3 %, between c and d is 3 %, ... between w and x is 3 %, between x and y is 3 %, between y and z is 3 %, then what is the percentage recombination between b and y?

1 Answers  


What is critical radius of insulation?

0 Answers  


what are the major problem comes in the production process

2 Answers   Atul, Deepak Fertilisers,


ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.19 : In the purchase of a unit of engineering office, a loan has been made to a bank with the following details : Term N = 30 years; interest rate R = 8.07 % / year; security : primary residence; present value pv = $450000; salary = $75000 / year or $56000 / year after tax. (a) Let the discounted present value PV = [ 1 - 1 / (1 + r) ^ n ] / r for arrears, where r = interest rate of discount, n = number of payment, ^ = symbol for power. If the loan repayment was made monthly : (i) calculate the value of r where r = R / k and R is in decimal value; (ii) find the value of n where n = kN; (iii) estimate the value of k where k = number of repayment per year; (iv) calculate the value of PV based on the formula of discounted present value. (b) Calculate the monthly repayment of the loan, MR based on the following formula : pv = PV x MR. (c) Find the percentage of salary remains after paying the loan every month.

1 Answers  


why sphericle shaped vessele used for storage of petrol?

3 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4451)
  • Electrical Engineering Interview Questions Electrical Engineering (16632)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)