Oil Well Drilling Costs Again the problem of estimating the

Oil Well Drilling Costs Again the problem of estimating the costs of drilling oil wells, which was originally discussed in Problem 2. The data set given in OS 13.2.3 contains the variables geology, downtime, and rig-index in addition to the variable geology is a score that measures the geological properties of the materials that have to be drilled through. Harder mate rails have larger scores, and so larger values of the geology variable indicate that harder materials have to be drilled through to complete the oil well. The variable downtime measure the number of hours that the drilling rig is idle due to factors such as inclement weather and interruptions for borehole and geological tests. The variable rig-indexcompares the daily rental costs of the drilling rig to the cost in 1980. Thus, an index of 1 implies that the rental costs are identical to those in 1980, and an index of 2 implies that the rental costs are twice what they were in 1980. Fit the multiple linear regression model y=beta0 + beta1X_1 + beta2X_2 + beta3X_3 + beta4X_4 With the response variance y as the cost and with X_1 as the depth, X_2 as geology score, X_3 as the downtime, and X_4 as the rig-index, and make plots of cost again each of the four input variables. Explain why the variable geology should be removed from the model. Dose this surprise you? What is the sample correlation coefficient between cost and geology ? What is the sample correlation coefficient between depth and geology? Why do you think that geology is not needed in the model? Should any other variables be removed from the model? What is the final model that you would recommend for use?

Solution