Chapter 4. Problem Solving with Excel
Molar Volume and Compressibility from Redlich-Kwong Equation
Concepts Demonstrated
Analytical solution of the cubic Redlich-Kwong equation for compressibility factor and calculation of the molar volume at various reduced temperature and pressure values.
Numerical Methods Utilized
Solution of a set of explicit equations.
Excel Options and Functions Demonstrated
Explicit solution involving definition of constants and arithmetic formulas, arithmetic functions, creating series, absolute and relative addressing, if statements and logical functions, two-input data tables and XY (scatter) plots.
Problem Definition
The R-K equation is usually written (Shacham et al.)[1]
Equation 4-1.
where
Equation 4-2.
Equation 4-3.
and
P |
Get Problem Solving in Chemical and Biochemical Engineering with POLYMATH, now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
