Homework Help is Here – Start Your Trial Now!
Engineering
Chemical Engineering
Using the method of non-linear regression in Excel, prepare a plot of lnγ1, lnγ2, GE/RT and P-x-y diagram showing both the correlated and experimental values. This correlation and plotting procedures shall be executed using Wilson equations.

Using the method of non-linear regression in Excel, prepare a plot of lnγ1, lnγ2, GE/RT and P-x-y diagram showing both the correlated and experimental values. This correlation and plotting procedures shall be executed using Wilson equations.

Introduction to Chemical Engineering Thermodynamics
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
See similar textbooks
icon
Related questions
Question

Using the method of non-linear regression in Excel, prepare a plot of lnγ1, lnγ2, GE/RT and P-x-y diagram showing both the correlated and experimental values. This correlation and plotting procedures shall be executed using Wilson equations.

. VLE data for methyl tert-butyl ether(1)/dichloromethane(2) at 308.15 K are as follows: P/kPa yi P/kPa yi 85.265 0.0000 0.0000 59.651 0.5036 0.3686 83.402 0.0330 0.0141 56.833 0.5749 0.4564 82.202 0.0579 0.0253 53.689 0.6736 0.5882 80.481 0.0924 0.0416 51.620 0.7676 0.7176 76.719 0.1665 0.0804 50.455 0.8476 0.8238 72.422 0.2482 0.1314 49.926 0.9093 0.9002 68.005 0.3322 0.1975 49.720 0.9529 0.9502 65.096 0.3880 0.2457 49.624 1.0000 1.0000
Transcribed Image Text:. VLE data for methyl tert-butyl ether(1)/dichloromethane(2) at 308.15 K are as follows: P/kPa yi P/kPa yi 85.265 0.0000 0.0000 59.651 0.5036 0.3686 83.402 0.0330 0.0141 56.833 0.5749 0.4564 82.202 0.0579 0.0253 53.689 0.6736 0.5882 80.481 0.0924 0.0416 51.620 0.7676 0.7176 76.719 0.1665 0.0804 50.455 0.8476 0.8238 72.422 0.2482 0.1314 49.926 0.9093 0.9002 68.005 0.3322 0.1975 49.720 0.9529 0.9502 65.096 0.3880 0.2457 49.624 1.0000 1.0000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Introduction to Chemical Engineering Thermodynami…
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…
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…
Elements of Chemical Reaction Engineering (5th Ed…
Chemical Engineering
ISBN:
9780133887518
Author:
H. Scott Fogler
Publisher:
Prentice Hall
Process Dynamics and Control, 4e
Process Dynamics and Control, 4e
Chemical Engineering
ISBN:
9781119285915
Author:
Seborg
Publisher:
WILEY
Industrial Plastics: Theory and Applications
Industrial Plastics: Theory and Applications
Chemical Engineering
ISBN:
9781285061238
Author:
Lokensgard, Erik
Publisher:
Delmar Cengage Learning
Unit Operations of Chemical Engineering
Unit Operations of Chemical Engineering
Chemical Engineering
ISBN:
9780072848236
Author:
Warren McCabe, Julian C. Smith, Peter Harriott
Publisher:
McGraw-Hill Companies, The
SEE MORE TEXTBOOKS