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
2378 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

Question 10 - In the US (United States), one barrel is equal to 42 US gallons and equivalent to 0.15898 cubic metres. One British barrel is equal to 36 Imperial gallons and equivalent to 0.163659 cubic metres. If an oil refinery in England sells 42 Imperial gallons of crude oil to a company in US, how much US gallons of crude oils has been sold?

1 Answers

What is the meaning of the critical speed of a turbine, and what are its effects on the shaft line

1 Answers

What is the most common cause of solid size segregation in bulk solid systems?

0 Answers TATA,

Why is double the amount of gas collected in one of the test tubes in electrolysis of water than th amount collected in the other? Name this gas?

0 Answers

Explain what types of valves are recommended for slurry services?

0 Answers

Question 70 - According to Adolf Eugen Fick (1829 - 1901) : rate of diffusion v increases with less wall thickness t, increased area A and decreased molecular weight of a fluid M. The diffusion constant D decreased with increasing M. (a) By assuming v, t, dP, A, M and D changes proportionally of each other, find the equation of v as a function of t, dP, A and D. (b) The ratio of self diffusion constant D, at T = 273 K and P = 0.1 MPa, for gases B and C are 1.604 : 0.155. If only 2 gases exist in such a system : hydrogen and nitrogen, find the type of gas for B and C with reference to their molecular weights M. (c) By using the equation of kinetic energy 0.5 MV = constant where V = square of v, find the ratio of V for B and V for C, or V(B) / V(C), as a function of M(B) and M(C), where M(B) is molecular weight of B and M(C) the molecular weight of C : Graham's Law of Diffusion.

1 Answers

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

0 Answers

what is the difference between material balance and mass balance

4 Answers

What is the pattern of interview questions and which field is of high importance viz., Mass Transfer, Heat Transfer, Petroleum Refining etc ?

2 Answers Cairn, IOCL, Reliance,

what is load and what are the types of load?

0 Answers

Explain what is a good way to get started in doing a plant-wide steam consumption analysis?

0 Answers

hi sir/madam i need placement paper of last years of DRDO in chemical sream...... send me the question paper as soon as possible on my email address praveen.zone@gmail.com

0 Answers

For more Chemical Engineering Interview Questions Click Here