BUSA 421 Data Mining (PDF)

PROJECT 2 (DATA MINING)
Question a
The tables below show the output for the regression of Percentage Successful Drilling
Completion and Slant Rate Differential for a random sample of 16 wells drilled in the Cotton
Valley Zone.
Table 1: Model Coefficients for Regression of Percentage Successful Drilling Completion and Slant Rate Differential Coefficients
Intercept -58.7703125
Slant Rate Differential 16.390625
Table 2: Regression Statistics for regression of Percentage Successful Drilling Completion and Slant Rate Differential
Regression Statistics
Multiple R 0.759692807
R Square 0.577133161
Adjusted R Square 0.546928387
Standard Error 15.87319309
Observations 16
The output provided in Table 1: Model Coefficients for Regression of Percentage
Successful Drilling Completion and Slant Rate Differential indicate that the regression equation
for regression of Percentage Successful Drilling Completion and Slant Rate Differential can be
expressed as follows: (to 4.s.f)
PercentageSuccessfulDrillingCompletion=−58.77+16.39(SlantRateDifferential)
The output of Table 2: Regression Statistics for regression of Percentage Successful
Drilling Completion and Slant Rate Differential shows the value of the Adjusted R Square =
1

PROJECT 2 (DATA MINING)
0.5469 (to 4.s.f). The R2 is linear regression measure that gives the value of the percentage of the
variance in the output variable that is explained by the input variable(s) [ CITATION Gal181 \l
1033 \m Jor13]. It is hence appropriate in the determination of the proportion of the variable in
the sample observations (values) to the proportion of successful drilling projects explained by a
model.
This implies that the regression equation given above for the relationship between the Percentage
Successful Drilling Completion and Slant Rate Differential explains 54.69% of the successful
drilling projects in the Cotton Valley Zone for the year 2013.
Question b
The tables below show the output for the regression of Percentage Successful Drilling
Completion and Core Fracture Ratio for a random sample of 16 wells drilled in the Cotton
Valley Zone.
Table 3: Model Coefficients for the regression of Percentage Successful Drilling Completion and Core Fracture Ratio Coefficients
Intercept 97.53825386
Core Fracture Ratio -1600.490884
Table 4: Regression Statistics for the regression of Percentage Successful Drilling Completion and Core Fracture Ratio
Regression Statistics
Multiple R 0.661738595
R Square 0.437897968
Adjusted R Square 0.397747823
Standard Error 18.30079947
Observations 16
2

PROJECT 2 (DATA MINING)
The output provided in Table 3: Model Coefficients for the regression of Percentage
Successful Drilling Completion and Core Fracture Ratio indicate that the regression equation for
regression of Percentage Successful Drilling Completion and Core Fracture Ratio can be
expressed as follows: (to 2 decimal places)
PercentageSuccessfulDrillingCompletion=97.54−1600.49(CoreFractureRatio)
The output of Table 4: Regression Statistics for the regression of Percentage Successful
Drilling Completion and Core Fracture Ratio shows the value of the Adjusted R Square = 0.3978
(to 4.s.f). This implies that the regression equation given above for the relationship between the
Percentage Successful Drilling Completion and Core Fracture Ratio explains 39.78% of the
successful drilling projects in the Cotton Valley Zone for the year 2013.
Question c
The tables below show the output for the regression of Percentage Successful Drilling
Completion and, Slant Rate Differential and Core Fracture Ratio for a random sample of 16
wells drilled in the Cotton Valley Zone.
Table 5: Model Coefficients for the regression of Percentage Successful Drilling Completion and, Slant Rate Differential and Core
Fracture Ratio Coefficients
Intercept -5.763283816
Slant Rate Differential 12.94935632
Core Fracture Ratio -1083.787956
3