Find Equation Roots with Excel

The video tutorial demonstrates how to find roots of equations using Excel. It starts with solving a simple cubic equation and progresses to the more complex Redlich-Kwong equation of state for real gases. The tutorial explains setting up equations in Excel, using Solver for optimization, and understanding the physical significance of the roots in the context of gas behavior.

What assumptions are made about ideal gases compared to real gases?

What is the significance of the liquid and vapor routes in the context of the Red Lee Kwang equation?

What is the role of the universal gas constant in the equations discussed?

How can one estimate the molar volume for the vapor route based on the ideal gas law?