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: VRTPTbVVabVRTPidealRKandwhere a = 0.427 R2Tc2.5/Pc, b = 0.0866 R Tc/Pc, andR = 0.0821 liter-atm/K. TheRedlich-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.5K. 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.
access the rest of the document.