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

QUANTUM COMPUTING - EXAMPLE 32.2 : (a) If | 001 > = | 1 >, | 111 > = | 7 >, find the 2 possible values of ( | 001 > + | 1 > + | 7 > ) ( | 111 > ). (b) In quantum money, a duplicate will have probability P of passing the verification test of a bank, if the total number of photons on the bank note is N. The would be counterfeiter has a probability p of success in duplicating the quantum money correctly for each photon. Guess the relationship of P, p and N as a mathematical formula involving natural logarithm ln.

1 Answers

Name some common problems associated with dilute phase pneumatic conveying?

0 Answers

What is control valve ?

2 Answers TCL,

Why do we apply on iron articles?

0 Answers

what is isochronus and droop speed?

0 Answers

Explain how can I evaluate the thermal relief requirements for double block-in of 98% sulfuric acid?

0 Answers

solution =2oolitre ,solute =Polyelectrolyte,Solution=water ,we have to prepare 1% solution.how much solute And Solvent?