Question: Please help me with Excel. d. The slant differential for another well in the Cotton Valley Zone drilled during 2013 was 5.7, with a core
Please help me with Excel.
d. The slant differential for another well in the Cotton Valley Zone drilled during 2013 was 5.7, with a core fracture ratio of 0.049. Use the estimated regression equation developed in part c to predict a successful drilling completion during that year. Explain what the result means.
| 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
