Use matlab and excel please Note: Most problems in this homework relate to the n
ID: 1884425 • Letter: U
Question
Use matlab and excel please
Note: Most problems in this homework relate to the nonlinear equation 3) 2788.51 T- 52.36 3096.52 760(0.6) exp 15.9008 +(0.4) exp 16.0137-7_-53.67 This is the equation that would need to be solved to determine the bubble point temperature T (in K) of a liquid mixture comprising 60 mole % benzene and 40 mole % toluene at atmospheric pressure 1. Solve Eq. () for the first (red) occurrence of the temperature T to obtain an equation of the form T = g1(T) Starting from the initial value T) = 373.15, calculate the first seven values , , . . . , T; by successive substitution. i.e., using the recursion relation T, = 91(T,-.) Do this problem using both (a) Matlab and (b) Excel. Copies of both the Matlab code and Excel spreadsheet must be provided 2. Solve Eq. (*) for the second (blue) occurrence of the temperature T to obtain an equation of the form T-92(T) Starting from the initial value To 362.47, calculate the first seven values , , . . . , T; by successive substitution. i.e., using the recursion relationExplanation / Answer
1. (a) Matlab code:
A = 15.9008; B = 2788.51; C = 52.36;
D = 16.0137; E = 3096.52; F = 53.67;
Tr(1) = 373.15;
fprintf(' The first seven values of the temperature (red): ')
for i = 1:7
X = 0.4*exp(D-E/(Tr(i)-F));
Tr(i+1) = B/(A-log((760-X)/0.6)) + C;
fprintf(' %g ', Tr(i+1));
end;
1. (b) Excel
In column A cell 1 - type 373.15.
In column B cell 1 - copy and paste the fomula given below:
=2788.51/(15.9008-LN((760-(0.4*EXP(16.0137-(3096.52/(A1-53.67)))))/0.6)) + 52.36
In column A cell 2 - type =B1
Then pull down B1 by one cell.
Then type B2 in column A cell 3
Then pull down B1 by one cell.
Repeat the above procedure till you reach cell 8 in column A.
2. (a) Matlab code
A = 15.9008; B = 2788.51; C = 52.36;
D = 16.0137; E = 3096.52; F = 53.67;
Tb(1) = 362.47;
fprintf(' The first seven values of the temperature (blue): ')
for i = 1:7
Y = 0.6*exp(A-B/(Tb(i)-C));
Tb(i+1) = E/(D-log((760-Y)/0.4)) + F;
fprintf(' %g ', Tb(i+1));
end;
2. (b) Excel
In column A cell 1 - type 362.47.
In column B cell 1 - copy and paste the fomula given below:
=3096.52/(16.0137-LN((760-(0.6*EXP(15.9008-(2788.51/(A1-52.36)))))/0.4)) + 53.67
In column A cell 2 - type =B1
Then pull down B1 by one cell.
Then type B2 in column A cell 3
Then pull down B1 by one cell.
Repeat the above procedure till you reach cell 8 in column A.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.