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

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 Posted / kang chuen tat (malaysia - pen

1 Answers
2461 Views
I also Faced
E-Mail Answers

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

How is plate heat exchangers used in an ammonia refrigeration system?

0 Answers

Why is post-weld heat treatment sometimes necessary for welded vessels?

0 Answers Aramco,

Your favourite area of interest

7 Answers Ambuja, CPCL, Genpact, Lilliput,

Question 64 – According to a heuristic of chemical engineering plant design, assume a pressure difference dP = 4 psi for each 10-ft rise in elevation. A pump is needed to pump liquid from a storage tank at a lower elevation to a heating tank at a higher elevation with the elevation difference of 60 ft. (a) Find the pressure loss due to such elevation. (b) If the required minimum inlet pressure to the heating tank is 9 psi, with 1 control valve is installed between pump and heating tank, what is the dP minimum required for the control valve and the entrance to the heating tank when the heuristic mentions that at least 10 psi is required for the control valve? (c) The pressure at the inlet of the pump is 8 psi and the flowrate of the liquid produces pressure head of 50 psi. What is the total pressure produced by the pump? (d) Assume a pipeline dP of 2 psi / 100 ft for liquid flow in a pipe according to heuristic, what is the approximate maximum length of the pipe in ft that can be installed between the pump and the heating tank?

1 Answers

when liquid stored in spherical vessel,equilibrium shift towards liquid.what is the benefit of it?

1 Answers

how to decide reflux ratio & its calculation

1 Answers

distance education chemical engineer degree aprooved courses any?

1 Answers

what is unit operation?

8 Answers Sun Pharma, Zydus Cadila,

ENGINEERING MATHEMATICS - EXAMPLE 8.3 : Solve the first order differential equation : (Z + 1)(dy/dx) = xy in term of ln |y| = f(x). Z = (x)(x).

1 Answers

Is it advisable to cool a fin fan by spraying demineralized water on it?