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

which is the major cement producing state in western India ?

2 Answers BNPM,

what is isothermal process?

1 Answers Coromandel,

How can I remove/decrease TDS from sewage waste water? At the moment it is 900gm/l. What is recommended TDS level to dispose sewage water in sea?

2 Answers OGDCL,

NATURAL GAS ENGINEERING - QUESTION 26.3 : The United States of America Energy Information Administration reports the following emissions in million metric tons of carbon dioxide in the world for year 2012 : Natural gas : 6799, petroleum : 11695, coal : 13787. Coal-fired electric power generation emits around 2000 pounds of carbon dioxide for every megawatt hour generated, which is almost double the carbon dioxide released by a natural gas-fired electric plant per megawatt hour generated. If 1 metric ton = 1000 kg and 1 pound = 0.4536 kg, estimate the total energy generated by natural gas in the world for year 2012, in gigawatt hour.

1 Answers

How to TDS removed found in lab apparatus.

1 Answers

what are lubricants using in compression.

1 Answers

What are the uses of quicklime?

0 Answers

What is the wet bulb globe temperature?

0 Answers

send me previous year question paper for ongc gt 2011 written exam

0 Answers ONGC,

Hi, few days back i attended an interview. Currently my employment status is contract basis and interviewer didn't ask me abt mode of employment and he is thinking that am permanent employee in this organization and during the time of joining how I would avoid this problem.

1 Answers

what is designing step of heat exchanger

0 Answers Reliance,

how can I find out a sulfuric acid recovery plant disigner?

0 Answers ONGC,

For more Chemical Engineering Interview Questions Click Here