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