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 RedlichKwong 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
literatm/K. The
RedlichKwong 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 RedlichKwong 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.
 Fall '11
 BradBundy

Click to edit the document details