One of the most promising methods for extracting crude oil employs a carbon dioxide (CO) flooding...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
One of the most promising methods for extracting crude oil employs a carbon dioxide (CO) flooding technique. When flooded into oil pockets, CO2 enhances oil recovery by displacing the crude oil. In a microscopie investigation of the CO2 flooding process, flow tubes were dipped into sample oil pockets containing a known amount. The oil pockets were flooded with co, and the percentage of oil displaced was recorded. The experiment was conducted at three different flow pressures and three di fferent dipping angles. The displacement test data are recorded in Table 2. Table 2 Pressure (xi) (Pounds per Square Inch) Dipping Angle (x2) (Degrees) Oil Recovery (y) (Percentage) 1000 60.58 72.72 79.99 1000 15 1000 30 1500 66.83 1500 15 80.78 1500 30 89.78 2000 69.18 2000 15 80.31 2000 30 91.99 a.) Write a complete sccond-order model with interaction relating percentage oil recovery y to pressure x, and dipping angle xz. b.) It is believed that the second order terms can be left out of the model. Write a complete first order model with interaction relating percentage oil recovery y to pressure xi and dipping angle x2. c.) Microsoft Excel was used to obtain the two models in questions a.) and b.) and the following results was obtained: SUMMARY OUT PUT FOR QUESTION 2 Regression Statistics Multiple R R Square 0.981851006 0.964031398 Adjusted R Square 0.942450237 Standard Error 2.508384606 Observations 9. ANOVA df Significance F MS Regression Residual 3 843.1908333 281.0636111 44.67004274 0.000493383 5 31.45996667 6.291993333 Total 8 874.6508 Coefficients Standard Error t Stat Upper 95% P-value Lower 95% Intercept X Variable 1 X Variable 2 X Variable 3 54.5 5.034158413 10.82603993 0.000116695 41.55930497 67.44069503 0.007696667 0.003238311 2.376753688 0.06341952 -0.000627662 0.016020995 0.554111111 0.259962823 2.131501365 0.086240036 -0.114143507 1.222365729 0.000113333 0.000167226 0.67772701 0.528031686 -0.000316533 0.0005432 SUMMARY OUT PUT FOR QUESTION 2 Regression Statistics Multiple R R Square Adjusted R Square 0.986458697 Standard Error 0,997457774 0.994922012 1.216753422 Observations ANOVA Significance F 5 870.2093333 174.0418667117.5570232 0.001223007 df MS Regression Residual 3 4.441466667 1.480488889 Total 8 874.6508 Coefficients Standard Eror t Stat Lower 95% Upper 95% P-value Intercept X Variable 1 X Variable 2 X Variable 3 X Variable 4 X Variable 5 26.19333333 7.579656577 3.45574144 0.040766103 2.071460635 50.31520603 0.047716667 0.010443308 4.56911419 0.019666674 0.014481369 0.080951965 0.760111111 0.170474187 4.4588047190.021002747 0.217585654 1.302636568 0.000113333 8.11169E-05 1.397160649 0.256772122 -0.000144817 0.000371484 -1.334E-05 3.4415E-06-3.876218589 0.030400321 -2.42924E-05-2.38761E-06 -0.006866667 0.003823887-1.795729451 0.170407335 -0.019035993 0.00530266 Is there sufficient evidence to support the statement made in b.)? Motivate your answer statistically. Use a = 0.05. One of the most promising methods for extracting crude oil employs a carbon dioxide (CO) flooding technique. When flooded into oil pockets, CO2 enhances oil recovery by displacing the crude oil. In a microscopie investigation of the CO2 flooding process, flow tubes were dipped into sample oil pockets containing a known amount. The oil pockets were flooded with co, and the percentage of oil displaced was recorded. The experiment was conducted at three different flow pressures and three di fferent dipping angles. The displacement test data are recorded in Table 2. Table 2 Pressure (xi) (Pounds per Square Inch) Dipping Angle (x2) (Degrees) Oil Recovery (y) (Percentage) 1000 60.58 72.72 79.99 1000 15 1000 30 1500 66.83 1500 15 80.78 1500 30 89.78 2000 69.18 2000 15 80.31 2000 30 91.99 a.) Write a complete sccond-order model with interaction relating percentage oil recovery y to pressure x, and dipping angle xz. b.) It is believed that the second order terms can be left out of the model. Write a complete first order model with interaction relating percentage oil recovery y to pressure xi and dipping angle x2. c.) Microsoft Excel was used to obtain the two models in questions a.) and b.) and the following results was obtained: SUMMARY OUT PUT FOR QUESTION 2 Regression Statistics Multiple R R Square 0.981851006 0.964031398 Adjusted R Square 0.942450237 Standard Error 2.508384606 Observations 9. ANOVA df Significance F MS Regression Residual 3 843.1908333 281.0636111 44.67004274 0.000493383 5 31.45996667 6.291993333 Total 8 874.6508 Coefficients Standard Error t Stat Upper 95% P-value Lower 95% Intercept X Variable 1 X Variable 2 X Variable 3 54.5 5.034158413 10.82603993 0.000116695 41.55930497 67.44069503 0.007696667 0.003238311 2.376753688 0.06341952 -0.000627662 0.016020995 0.554111111 0.259962823 2.131501365 0.086240036 -0.114143507 1.222365729 0.000113333 0.000167226 0.67772701 0.528031686 -0.000316533 0.0005432 SUMMARY OUT PUT FOR QUESTION 2 Regression Statistics Multiple R R Square Adjusted R Square 0.986458697 Standard Error 0,997457774 0.994922012 1.216753422 Observations ANOVA Significance F 5 870.2093333 174.0418667117.5570232 0.001223007 df MS Regression Residual 3 4.441466667 1.480488889 Total 8 874.6508 Coefficients Standard Eror t Stat Lower 95% Upper 95% P-value Intercept X Variable 1 X Variable 2 X Variable 3 X Variable 4 X Variable 5 26.19333333 7.579656577 3.45574144 0.040766103 2.071460635 50.31520603 0.047716667 0.010443308 4.56911419 0.019666674 0.014481369 0.080951965 0.760111111 0.170474187 4.4588047190.021002747 0.217585654 1.302636568 0.000113333 8.11169E-05 1.397160649 0.256772122 -0.000144817 0.000371484 -1.334E-05 3.4415E-06-3.876218589 0.030400321 -2.42924E-05-2.38761E-06 -0.006866667 0.003823887-1.795729451 0.170407335 -0.019035993 0.00530266 Is there sufficient evidence to support the statement made in b.)? Motivate your answer statistically. Use a = 0.05.
Expert Answer:
Answer rating: 100% (QA)
Solutiow StepI Multiple Pegremicn Amalyeni sen r regremion nobscuva... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these general management questions
-
One of the most important functions we will encounter in this book is the Cobb-Douglas function: y = (x,)"(x,)", where a and are positive constants that are each less than 1. a. Show that this...
-
You may have noticed that one of the most frequently offered product categories online is pharmaceuticals. However, the number of physical pharmacies, such as CVS, Rite Aid, and Target, continue to...
-
One of the most widely accepted and longest held beliefs is the controllability principle, which says that organization units and people should be held accountable only for things that they can...
-
1. For each of the following, compute the present value (Do not round intermediate calculations and round your final answers to 2 decimal places. (e.g., 32.16)): 2. For each of the following, compute...
-
A $100,000, 90-day commercial paper certificate issued by Bell Canada Enterprises was sold on its issue date for $98,950. What annual rate of return (to the nearest 0.001%) will it yield to the buyer?
-
Stevie McQueen has run Lightning Car Detailing for the past 10 years. His static budget and actual results for June 2011 are provided next. Stevie has one employee who has been with him for all 10...
-
True or False: If \(P W>0\), then \(I R R>M A R R\).
-
On January 1, 2015, Johnsonville Enterprises acquired 80 percent of Stayer Companys outstanding common shares in exchange for $3,000,000 cash. The price paid for the 80 percent ownership interest was...
-
In some ways, a qualitative portfolio manager could never really be an index portfolio manager, whereas a quantitative portfolio manager could be. Explain why.
-
The MFG Corporation is planning to produce and market three different products. Let x1, x2, and x3 denote the number of units of the three respective products to be produced. The preliminary...
-
4. Write the truth table for the CMOS Circuit given below and specify which logic gate it represents. (10 points) A B +V Q3 Q4 FL Screenshot(Alt + A)
-
Determine the missing amount for each of the following: Assets Liabilities a. b. C. $ $105,540 $50,790 $ $211,080 $7,260 + + + Owner's Equity $659,620 $32,980 $
-
What does the following function do? What is the complexity? public void output() { Node ptr1 null, ptr2 = null, dup = null; ptr1= head; while (ptr1 != null && ptr1.next != null) { per2 = ptri; }...
-
Sheffield Company showed the following balances at the end of its first year: Cash Prepaid insurance Accounts receivable Accounts payable Notes payable Owner's Capital Owner's Dividends Revenues...
-
Vaughn Company purchased a building on January 2 by signing a long-term $629000 mortgage with monthly payments of $6700. The mortgage carries an interest rate of 12 percent. The entry to record the...
-
For each of the following E-R diagrams transform the diagram to a relational schema (draw the graphical notation). Q1) COURSE Course ID Description Credits {Prerequisite} Q2) COURSE Course ID...
-
Let fi(n), f2 (n), 91 (n), and g2(n) be functions of n = Z+ such that fi(n) 91 (n) = (92(n)). (a) (5 points) Show that the following may not hold: fi (n) g (n) = (f2(n) 92 (n)). (Here, you need to...
-
In Exercises 15 through 30, find the derivative dy/dx. In some of these problems, you may need to use implicit differentiation or logarithmic differentiation. y ex + et -2x 1 + e
-
What are the three most common methods of setting a budget?
-
What is a strategy map?
-
Why is it useful to decompose a flexible budget variance into a rate (price) variance and an efficiency (quantity) variance?
-
You are to open the books of F. Polk, a trader, via the journal to record the assets and liabilities, and are then to record the dialy transactions for the month of May. A trial balance is to be...
-
Why do we have day books? Why don't we just enter every transaction directly into the appropriate ledger accounts?
-
Where is the other side of the double entry for all these expense postings to the ledgers recorded?
Study smarter with the SolutionInn App