Question: Please help me with Excel. c. Develop the estimated multiple regression equation that could be used to predict the percentage of successful drilling completions, given
Please help me with Excel.
c. Develop the estimated multiple regression equation that could be used to predict the percentage of successful drilling completions, given the slant differential and the core fracture ratio. 1. What is the regression equation? Explain it. 2. What is R-square and what does it tell you? 3. What does the P value of the model tell us? 4. Explain what proportion of the variable in the sample values to the proportion of successful drilling projects does this model explain? 5. What is the implication of this regression model to management (the big question)? Provide objective evidence graphs as appropriate. 6. Provide the residual plots in this document.
| Well | District | Slant Rate Differential | Core Fracture Ratio | Successful Drilling Completion % |
| Alcorn #3 | Central Pavilion | 6.5 | 0.040 | 33.7 |
| Crying Hats 8 | East Pavilion | 7.2 | 0.028 | 61.1 |
| Trail End 3 | East Pavilion | 7.4 | 0.033 | 37.3 |
| Antelopes 8 | East Pavilion | 6.2 | 0.026 | 25.9 |
| Meteor Show 2 | East Pavilion | 7.2 | 0.024 | 61.7 |
| Horse Corral 3 | East Pavilion | 8.8 | 0.014 | 92.7 |
| Striking It Rich 2 | East Pavilion | 7.4 | 0.019 | 62.7 |
| Striking It Rich 4 | Central Pavilion | 5.7 | 0.027 | 12.3 |
| Friends 2 | East Pavilion | 4.6 | 0.032 | 32.0 |
| Three Sisters 5 | East Pavilion | 5.8 | 0.033 | 18.4 |
| Striking It Rich 6 | East Pavilion | 8.3 | 0.020 | 78.3 |
| Dark Canyon 2 | East Pavilion | 8.1 | 0.021 | 72.3 |
| Shadow House 4 | East Pavilion | 7.2 | 0.041 | 50.1 |
| Campfire 2 | East Pavilion | 6.5 | 0.014 | 79.8 |
| Starry Night 7 | South Pavilion | 6.9 | 0.024 | 56.1 |
| Warrior 3 | Central Pavilion | 6.4 | 0.041 | 31.3 |
| Warrior 4 | Central Pavilion | 6.5 | 0.047 | 41.1 |
| Red Door 3 | East Pavilion | 6.2 | 0.043 | 52.0 |
| Starry Night 9 | South Pavilion | 6.7 | 0.022 | 55.7 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
