{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment7-2010

# Assignment7-2010 - ChE 263 Assignment#7(VBA HW#2 The...

This preview shows page 1. Sign up to view the full content.

ChE 263 Assignment #7 (VBA HW#2) The reading assignment is chapters 5 and 7 of the Text. 1. (Competencies 5.4, 6.1 - 50 points) The Redlich-Kwong equation of state and the Ideal Gas Law are respectively: V RT P T b V V a b V RT P ideal RK and where a = 0.427 R 2 T c 2.5 /P c , b = 0.0866 R T c /P c , and R = 0.0821 liter-atm/K. The Redlich-Kwong equation is more accurate than the Ideal Gas Law because it allows for molecular interactions at high pressures. a. Create an Excel function, entitled PRK(V,T,Pc,Tc) which calculates the pressure from the Redlich-Kwong equation. Make Pc and Tc optional arguments in PRK. Use the critical properties of air as their defaults: Pc = 37.2 atm and Tc = 132.5 K. b. For air, plot pressure vs volume for the range 0.1 L/mol V 10 L/mol for T = 100 K, 300K, and 500K. You should have 3 lines on your plot, one for each temperature. After you have solved the problem, answer the following (for points). Briefly list which skills, learned in class, were used to solve the problem. 2. (Competencies 5.4, 6.6 - 50 points)
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}