Reference no: EM13985503
Please do as stated in the questions, use excel spreadsheet also show formulas and please organize
You can use transport processes and separation process principle by John Geankoplis chapter 8 and 10.
With the aid of figure below, write a solver for Problem 1 using Excel.
Problem 1. Evaporation of Sugar Solution in Double Effect Evaporator. A double-effect evaporator with reverse feed is used to concentrate 4536 kg/h of a 10 wt % sugar solution to 50%. The feed enters the second effect at 37.8°C. Saturated steam at 115.6°C enters the first effect and the vapor from this effect is used to heat the second effect. The absolute pressure in the second effect is 13.65 kPa abs. The overall coefficients are U1 = 2270 and U2 = 1705 W/m2 - K.

Effect 1
|
|
|
Effect 2
|
|
|
xF
|
0.1
|
|
12
|
2807.13
|
kg/h
|
TF
|
37.8
|
C
|
V2
|
1728.87
|
kg/h
|
S
|
2129.508001
|
kg/h
|
x2
|
0.161589
|
|
Ts1
|
115.6
|
C
|
Ts2
|
85.87607
|
C
|
Ti
|
88.32106885
|
|
ri
|
52.35822
|
C
|
xi
|
0.5
|
|
Ts3
|
51.90818
|
C
|
U
|
907.2
|
OA
|
Ps2
|
13.65
|
kpa
|
F
|
4536
|
kg/h
|
|
|
|
V1
|
1899.930046
|
kg/h
|
|
|
|
cpsuperheat
|
1.884
|
kJikaK
|
|
|
|
Problem 2. A pure gas, A is entering to a counter-current tray tower separation unit and leaves the tower with 1.5 mot % of gas, B. The inert gas flow rate is 500 mot gas/h.m2. The liquid entering the tower contains 0.1 mot % 13 and it is leaving the tower with 0.02 mot % B.
Equilibrium curve for this tower is given by y = -817140x3 + 6500 x2 + 16.755 x where x and y are mole fractions.
a) Determine whether this processes is a stripping process or an absorption process.
b) What is the total liquid and vapor flow rates at the entrance and exit of the tower?
c) Determine the inert liquid flow rate.
d) What is the equation of the operating line?
e) How many theoretical trays does that tower have? Obtain your solution graphically using Excel. Analytical answers will not be accepted. (If the process is a stripping process, start from the concentrated end and step off, if the process is an absorption, start from the dilute end to draw the stairs)
(Use solver while determining the points for the stairs.lf you don't draw the sta. using Excel, if you do the rest correctly, you will get max. 5 pts from this part)
Problem 3. Ina counter-current stage tower, gas C is absorbed in a liquid. Equilibrium relationship is given by y = 3x. The total inlet gas flow to the tower is 50 mol/h and total inlet pure liquid flow rate is 120 mol/h. The entering gas contains 1 mot % C. Exiting total gas flow rate is 49.7 mol/h and the exiting gas of the mole fraction y1 = 0.004024145.
a) What is the exiting total liquid flow rate and composition?
b) Can you assume that the operating line for this case is a straight line? If you can justify that assumption, use the inlet and outlet compositions to draw the operating line and tit a linear equation for the operating line.
c) How many stages the tower has? Obtain the number of stages graphically using Excel with the given equilibrium relationship and a suitable operating line.
d) Can you use analytical equations to obtain the number of stages for this case? If you can, what justifies the use of analytical equations?
e) How many stages do you get if you use the analytical equation?
The heating areas for both effects are equal. Use boiling-point-rise and heat-capacity data. Calculate the area and steam consumption.
Variable with probability density function
: Let X be a random variable with probability density function 630x4(1 - x)4, 0 1,f(x) = 0, otherwise.
|
Test the hypothesis that choice of major
: Test the hypothesis that the choice of the major by undergraduate students in this university is independent of their gender. Use α = 0.01.
|
Opinion on collective bargaining by teachers
: The following table gives the opinion on collective bargaining by a random sample of 200 employees of a school system, belonging to a teachers' union.
|
Determining the normal distribution
: Assuming that the samples come from a normal distribution: Test that the mean SAT score for math in 1999 is greater than that in 1989 at α = 0.05. Assume the variances are equal.
|
What is the total liquid and vapor flow rates
: Determine whether this processes is a stripping process or an absorption process and what is the total liquid and vapor flow rates at the entrance and exit of the tower?
|
Problem regarding the equality of variances between the iqs
: The IQs of 17 students from one area of a city showed a mean of 106 with a standard deviation of 10, whereas the IQs of 14 students from another area showed a mean of 109 with a standard deviation of 7.
|
Difference between the two population means
: At the conclusion of the instructional period, a reading test gave results y1 = 74, y2 = 71, s1 = 9, and s2 = 10. What is the attained signi?cance level if you wish to see if there is evidence of a real difference between the two population means?..
|
Problem regarding the sample standard deviation
: A random sample of 40 of these batteries was tested, resulting in a sample mean life of 41 months with a sample standard deviation of 16 months. Test at α = 0.01 whether the manufacturer's claim is correct.
|
Determining the average price of a gallon of gas
: According to the Bureau of Labor Statistics (1996), the average price of a gallon of gasoline in all U.S. cities in the United States in January 1996 was $1.129. A later random sample in 24 cities found the mean price to be $1.24 with a standard d..
|