When a liquid mixture is boiled, the vapor that leaves the vessel is enriched in the more volatile component of the mixture. The vapor and liquid in a boiling vessel are in equilibrium, and vapor-liquid equilibrium (VLE) data are available for many mixtures. The data are usually presented in tabular form, as in the table at the end of this problem statement, which represents VLE data for mixtures of methanol (MeOH) and ethanol (EtOH) boiling at 1 atm. From the graph of the VLE data, we see that, when 50:50 liquid mixture of the alcohol is boiled, the vapor will contain about 60% methanol (Figure 6.39). sion in Excel vapor Mass fraction methanol 1.0 0.8 0.6 0.4 0.2 0.0 0.0 Methanol - Ethanol VLE 0.2 0.4 0.6 0.8 Mass fraction methanol in liquid VLE data are commonly used in designing distillation columns, but an equa- tion relating vapor mass fraction to liquid mass fraction is a lot handier than tabu- lated values. 1.0 Use trendlines on the tabulated VLE data to obtain an equation relating the mass fraction of methanol in the vapor (y) to the mass fraction of vapor in the liq- uid (x). Test several different linear models (e.g., polynomials) to see which model gives a good fit to the experimental data. Data: The VLE values shown next were generated by using Excel, with the assumption that these similar alcohols form an ideal solution. The X column rep- resents the mass fraction of methanol in the boiling mixture. (Mass fraction of ethanol in the liquid is calculated as 1 - x for any mixture.) The mass fraction of methanol in the vapor leaving the solution is shown in the Y column. These data are available in electronic form at the text's website http://www. coe.montana.edu/che/Excel. Хмеон 1.000 0.882 0.765 0.653 0.545 0.443 0.344 0.250 0.159 0.072 0.000 Үмеон 1.000 0.929 0.849 0.764 0.673 0.575 0.471 0.359 0.241 0.114 0.000
When a liquid mixture is boiled, the vapor that leaves the vessel is enriched in the more volatile component of the mixture. The vapor and liquid in a boiling vessel are in equilibrium, and vapor-liquid equilibrium (VLE) data are available for many mixtures. The data are usually presented in tabular form, as in the table at the end of this problem statement, which represents VLE data for mixtures of methanol (MeOH) and ethanol (EtOH) boiling at 1 atm. From the graph of the VLE data, we see that, when 50:50 liquid mixture of the alcohol is boiled, the vapor will contain about 60% methanol (Figure 6.39). sion in Excel vapor Mass fraction methanol 1.0 0.8 0.6 0.4 0.2 0.0 0.0 Methanol - Ethanol VLE 0.2 0.4 0.6 0.8 Mass fraction methanol in liquid VLE data are commonly used in designing distillation columns, but an equa- tion relating vapor mass fraction to liquid mass fraction is a lot handier than tabu- lated values. 1.0 Use trendlines on the tabulated VLE data to obtain an equation relating the mass fraction of methanol in the vapor (y) to the mass fraction of vapor in the liq- uid (x). Test several different linear models (e.g., polynomials) to see which model gives a good fit to the experimental data. Data: The VLE values shown next were generated by using Excel, with the assumption that these similar alcohols form an ideal solution. The X column rep- resents the mass fraction of methanol in the boiling mixture. (Mass fraction of ethanol in the liquid is calculated as 1 - x for any mixture.) The mass fraction of methanol in the vapor leaving the solution is shown in the Y column. These data are available in electronic form at the text's website http://www. coe.montana.edu/che/Excel. Хмеон 1.000 0.882 0.765 0.653 0.545 0.443 0.344 0.250 0.159 0.072 0.000 Үмеон 1.000 0.929 0.849 0.764 0.673 0.575 0.471 0.359 0.241 0.114 0.000
Introduction to Chemical Engineering Thermodynamics
8th Edition
ISBN:9781259696527
Author:J.M. Smith Termodinamica en ingenieria quimica, Hendrick C Van Ness, Michael Abbott, Mark Swihart
Publisher:J.M. Smith Termodinamica en ingenieria quimica, Hendrick C Van Ness, Michael Abbott, Mark Swihart
Chapter1: Introduction
Section: Chapter Questions
Problem 1.1P
Related questions
Question
excel spreadsheet
Transcribed Image Text:**6.6 Vapor–Liquid Equilibrium**
When a liquid mixture is boiled, the vapor that leaves the vessel is enriched in the more volatile component of the mixture. The vapor and liquid in a boiling vessel are in equilibrium, and vapor–liquid equilibrium (VLE) data are available for many mixtures. The data are usually presented in tabular form, as in the table at the end of this problem statement, which represents VLE data for mixtures of methanol (MeOH) and ethanol (EtOH) boiling at 1 atm. From the graph of the VLE data, we see that, when a 50:50 liquid mixture of the alcohol is boiled, the vapor will contain about 60% methanol (Figure 6.39).
**Graph Explanation:**
The graph titled "Methanol – Ethanol VLE" shows the relationship between the mass fraction of methanol in the vapor and liquid phases. The x-axis represents the mass fraction of methanol in the liquid, ranging from 0.0 to 1.0. The y-axis shows the mass fraction of methanol in the vapor, also ranging from 0.0 to 1.0. The plot demonstrates a positive correlation where the vapor phase becomes richer in methanol compared to the liquid phase as the methanol fraction increases.
**VLE Data**
VLE data are commonly used in designing distillation columns, but an equation relating vapor mass fraction to liquid mass fraction is a lot handier than tabulated values.
Use trendlines on the tabulated VLE data to obtain an equation relating the mass fraction of methanol in the vapor (y) to the mass fraction of vapor in the liquid (x). Test several different linear models (e.g., polynomials) to see which model gives a good fit to the experimental data.
**Data:** The VLE values shown next were generated by using Excel, with the assumption that these similar alcohols form an ideal solution. The X column represents the mass fraction of methanol in the boiling mixture. (Mass fraction of ethanol in the liquid is calculated as 1 − x for any mixture.) The mass fraction of methanol in the vapor leaving the solution is shown in the Y column.
These data are available in electronic form at the text’s website: http://www.coe.montana.edu/che/Excel.
\[
\begin{array}{cc}
X_{\text{MeOH}} & Y_{\text{Me
Expert Solution
Step 1
-Test the linear and polynomials models to verify the experimental data:
Let us consider the given data,
The tabled data and graph is shown below:
Screenshot of the Excel sheet
Step by step
Solved in 5 steps with 7 images
Recommended textbooks for you
Introduction to Chemical Engineering Thermodynami…
Chemical Engineering
ISBN:
9781259696527
Author:
J.M. Smith Termodinamica en ingenieria quimica, Hendrick C Van Ness, Michael Abbott, Mark Swihart
Publisher:
McGraw-Hill Education
Elementary Principles of Chemical Processes, Bind…
Chemical Engineering
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY
Elements of Chemical Reaction Engineering (5th Ed…
Chemical Engineering
ISBN:
9780133887518
Author:
H. Scott Fogler
Publisher:
Prentice Hall
Introduction to Chemical Engineering Thermodynami…
Chemical Engineering
ISBN:
9781259696527
Author:
J.M. Smith Termodinamica en ingenieria quimica, Hendrick C Van Ness, Michael Abbott, Mark Swihart
Publisher:
McGraw-Hill Education
Elementary Principles of Chemical Processes, Bind…
Chemical Engineering
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY
Elements of Chemical Reaction Engineering (5th Ed…
Chemical Engineering
ISBN:
9780133887518
Author:
H. Scott Fogler
Publisher:
Prentice Hall
Industrial Plastics: Theory and Applications
Chemical Engineering
ISBN:
9781285061238
Author:
Lokensgard, Erik
Publisher:
Delmar Cengage Learning
Unit Operations of Chemical Engineering
Chemical Engineering
ISBN:
9780072848236
Author:
Warren McCabe, Julian C. Smith, Peter Harriott
Publisher:
McGraw-Hill Companies, The