Question

In: Statistics and Probability

An analyst wanted to predict the time required to complete a construction project using four variables...

An analyst wanted to predict the time required to complete a construction project using four variables - size of the contract ?1x1 (in $1000 units), number of workdays adversely affected by the weather ?2x2, number of subcontractors involved in the project ?4x4, and a variable ?3x3 that measured the presence ( ?3=1x3=1) or absence ( ?3=0x3=0) of a workers' strike during the construction. Fifteen construction projects were randomly chosen, and each of the four variables as well as the time to completion were measured. The full model shown below uses ?1x1, ?2x2, ?3x3, ?4x4, ?1?3x1x3, ?2?3x2x3, and ?4?3x4x3.

Estimate Std. Error t value
(Intercept) 13.692 8.674 1.579
x1 0.028 0.016 1.708
x2 -1.046 0.838 -1.248
x3 66.781 86.623 0.771
x4 2.068 1.624 1.274
x1:x3 -0.035 0.018 -1.942
x2:x3 5.105 1.567 3.257
x4:x3 -7.297 9.122 -0.8

a) Find the estimaing equation for the presence of workers on strike.
?̂ y^ =  -  ?1x1 +  ?2x2 -  ?4x4

b) Find the estimating equation for the absence of workers on strike.
?̂ y^ =  +  ?1x1 -  ?2x2 +  ?4x4

c) Interpret ?2(???)=0.9102R2(adj)=0.9102
% of the variation in   time to completion contract size workdays affected number subcontractors workers strike status  can be explained by   time, contract size, workdays affected, and number subcontractors contract size, workdays affected, number subcontractors, and worker strike status time, workdays affected, number subcontractors, and worker strike status time, contract size, number subcontractors, and worker strike status .

Solutions

Expert Solution

The estimated regression equation is,

y =13.692 + 0.028 x1 - 1.046 x2 + 66.781 x3 +   2.068 x4 - 0.035 x1:x3 + 5.105 x2:x3 - 7.297 x4:x3

a.

Estimated equation for the presence of workers on strike (x3 = 1)

y =13.692 + 0.028 x1 - 1.046 x2 + 66.781 x3 +   2.068 x4 - 0.035 x1:x3 + 5.105 x2:x3 - 7.297 x4:x3

y =13.692 + 0.028 x1 - 1.046 x2 + 66.781 (1) +   2.068 x4 - 0.035 x1:1 + 5.105 x2:1 - 7.297 x4:1  

y = (13.692 + 66.781) + (0.028 - 0.035 ) x1 + (-1.046 + 5.105 ) x2 + (2.068 - 7.297 ) x4

y = 80.473 - 0.007 x1 + 4.059 x2 - 5.229 x4

b.  

Estimated equation for the absence of workers on strike (x3 = 0)

y =13.692 + 0.028 x1 - 1.046 x2 + 66.781 x3 +   2.068 x4 - 0.035 x1:x3 + 5.105 x2:x3 - 7.297 x4:x3

y =13.692 + 0.028 x1 - 1.046 x2 + 66.781 (0) +   2.068 x4 - 0.035 x1:0 + 5.105 x2:0 - 7.297 x4:0  

y = 13.692 + 0.028 x1  - 1.046 x2 +   2.068 x4

c.

91.02%  of the variation in time to completion of project is explained by variables size of the contract ?1, number of workdays adversely affected by the weather ?2, number of subcontractors involved in the project ?4, and a variable ?3 that measured the presence or absence of a workers' strike during the construction.


Related Solutions

The mean time required to complete a certain type of construction project is 52 weeks with...
The mean time required to complete a certain type of construction project is 52 weeks with a standard deviation of 3 weeks. Answer questions 4–7 using the preceding information and modeling this situation as a normal distribution. 4. What is the probability of the completing the project in no more than 52 weeks? a) 0.25 b) 0.50 c) 0.75 d) 0.05 5. What is the probability of the completing the project in more than 55 weeks? a) 0.1587 b) 0.5091...
The mean time required to complete a certain type of construction project is 52 weeks with...
The mean time required to complete a certain type of construction project is 52 weeks with a standard deviation of 3 weeks. Answer questions 4–7 using the preceding information and modeling this situation as a normal distribution. What is the probability of the completing the project in no more than 52 weeks? 0.25 0.50 0.75 0.05 What is the probability of the completing the project in more than 55 weeks? 0.1587 0.5091 0.7511 0.0546 What is the probability of completing...
The time required to complete a project is normally distributed with a mean of 78 weeks...
The time required to complete a project is normally distributed with a mean of 78 weeks and a standard deviation of 10 weeks. The construction company must pay a penalty if the project is not finished by the due date in the contract. If a construction company bidding on this contract wishes to be 90 percent sure of finishing by the due date, what due date (project week #) should be negotiated?
Complete the four cases using your individually assigned values for the variables. Be very careful to...
Complete the four cases using your individually assigned values for the variables. Be very careful to use your individually assigned variables. Your answers will be graded as wrong, if you use the wrong variables. Use the time value tables found in your textbook when required to show your work (use the same method as I did in class). Do NOT use finance calculators, excel formulas, etc. to calculate values. You can round to the nearest dollar. Case #1 ( 20...
An automotive researcher wanted to estimate the difference in distance required to come to a complete...
An automotive researcher wanted to estimate the difference in distance required to come to a complete stop while traveling 40 miles per hour on wet versus dry pavement. Because car type plays a role, the researcher used eight different cars with the same driver and tires. The breaking distance (in feet) on both wet and dry pavement is shown in the data below. Car 1 2 3 4 5 6 7 8 Wet 107 101 109 112 105 106 111...
Suppose we wanted to predict the selling price of a house, using its size, in a...
Suppose we wanted to predict the selling price of a house, using its size, in a certain area of a city. A random sample of six houses were selected from the area. The data is presented in the following table with size given in hundreds of square feet, and sale price in thousands of dollars.: Temperature (oF): Xi 16 28 13 22 25 19 Number of Calls: Yi 95 120 70 115 130 85 We are interested in fitting the...
Provide 3 types of construction permits may be required in a construction project and elaborate on...
Provide 3 types of construction permits may be required in a construction project and elaborate on their impact on the construction schedule.
Suppose you wanted to predict Winnings ($) using only the number of poles won (Poles), the...
Suppose you wanted to predict Winnings ($) using only the number of poles won (Poles), the number of wins (Wins), the number of top five finishes (Top 5), or the number of top ten finishes (Top 10). Which of these four variables provides the best single predictor of winnings?
1. A supermarket chain wanted to obtain information on the length of time (in minutes) required...
1. A supermarket chain wanted to obtain information on the length of time (in minutes) required to service customers. They need to decide on the number of service counters needed for stores to be built in the future. To find the distribution of customer service times, a sample of 60 customers’ service times were recorded and are shown here:       3.6        1.9        2.1        .3          .8         .2         1.0        1.4        1.8        1.6 1.4...
The time that takes to complete a certain type of construction projects has a mean of...
The time that takes to complete a certain type of construction projects has a mean of 35.5 months and a standard deviation of 1.5 months. a. According to the Tchebysheff’s theorem, at least what percentage of these projects must have taken between 26.5 months and 44.5 months to complete? b. If in addition we are told that the relative frequency curve for the completion times is a bell-shaped curve, then approximately what percentage of these projects would take more than...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT