Question: Need Excel solution please help me. Fast as possible. Thanks. And please Excel with solution please. b. Develop the estimated regression equation that could be

Need Excel solution please help me. Fast as possible. Thanks. And please Excel with solution please.

b. Develop the estimated regression equation that could be used to predict the percentage of successful drilling completions, given 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 core fracture ratio 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!