MP1 Spring 2020 1. See attached spreadsheet with A versus x data. a. Plot it and see what form of fit you think might work. (It is adsorption data) b. Suppose a Michaelis form might be appropriate …. A = a/(b+cx)^2 find a, b c 2. Suppose we are using the ideal gas law PV = NRT. R = 10.73 for psia,lbmol, 0R, ft3. Make a 2 x table to show the volume of 1 lbmole of methane at T from 100 to 300 F, and p from 500 to 2000 psia. Use a step size of 50 F and 500 psia. Put T across the top. a. Use direct calculation with copying b. Use the data table function c. Create a function in VBA to calculate V with arguments N,T,P d. Make a plot of V vs P with 4 lines at T = 100, 150 , 200, and 250 3. Consider the function f(x) = (x-3)*e0.01x/x3 a. Plot it from -2 to 10 b. What are the roots in this interval … i. Visually .. from plot ii. Using goal seek iii. Using solver c. What is the maximum on the interval d. What is the minimum on the interval 4. If we want to build a conical tank of volume 1000 m3 but want to minimize the surface area, what will D and H be? What is the ratio? Would the ratio of D/H change if we change the volume? Try it and see what the ratio is at a volume of 10,000 m3. x A 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 5,19 3,74 3,42 2,81 1,67 1,19 2,55 1,55 1,78 2,23 1,91 0,79 0,30 1,61 1,53 0,67 0,41 1,55 1,10 -0,14 1,42 0,58 0,35 0,72 1,29 0,26 x -2 -1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 A 0,612624 3,960199 -2,0201 -0,12753 0 0,016263 0,01682 0,014748 0,012507 0,010579 0,009006 0,007736 0,006709 0,005872 0,005184 0,004611 0,004131 0,003725 0,003378 0,003079 0,002821 0,002595 0,002398 0,002223 0,002069
Purchase answer to see full attachment