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

What happens when fuel is burned , what are compounds released??

3 Answers Reddy Labs,

In Galvonised iron and stainsteel pipes, in which pipe friction losses will more and why ?

0 Answers

diffirance between heat transfer & thermodynamics

3 Answers Shinsung Petrochemicals,

what is isochronus and droop speed?

0 Answers

What information is needed to specify a mixer?

0 Answers

Explain how can one determine if a particular solid can be fluidized as in a fluidized bed?

0 Answers

How 'saltation velocity' is used in designing pneumatic conveying systems?

0 Answers

Explain what types of metals are typically removed via chemical precipitation?

0 Answers

How many years you are having experience in supervising others in lab environment?

0 Answers

Can you pls tell me how to calculate the amphere rating of cable in case of three phase supply but all load is single phase

0 Answers

Can asphalt be recycled to form a useful product?

0 Answers

Explain the different characteristics that can affect the flow of bulk solids and how?

0 Answers

For more Chemical Engineering Interview Questions Click Here