13.50 The owner of a moving company typically has his most experienced manager p

Question

13.50 The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business objective of developing a more accurate method of predicting labor hours. In a preliminary effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved and the number of pieces of large furniture as the independent variables and has collected data for 36 moves in which the origin and destination were within the borough of Manhattan in New York City and the travel time was an insignificant portion of the hours worked. E: Determine whether there is a significant relationship between labor hours and the two independent variables (the number of cubic feet moved and the number of pieces of large furniture) at the 0.05 level of significance F: Determine the p-value in (e) and interpret its meaning. G: Interpret the meaning of the coefficient of multiple determination in this problem H: Determine the adjusted r2. I: At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. Indicate the most appropriate regression model for this set of data J: Determine the p-values in (i) and interpret their meaning K: Construct a 95% confidence interval estimate of the population slope between labor hours and the number of cubic feet moved. How does the interpretation of the slope here differ from that in Problem 12.44 on page 443? L: What conclusions can you reach concerning labor hours?

Hours Feet Large Elevator 24.00 545 3 Yes 13.50 400 2 Yes 26.25 562 2 No 25.00 540 2 No 9.00 220 1 Yes 20.00 344 3 Yes 22.00 569 2 Yes 11.25 340 1 Yes 50.00 900 6 Yes 12.00 285 1 Yes 38.75 865 4 Yes 40.00 831 4 Yes 19.50 344 3 Yes 18.00 360 2 Yes 28.00 750 3 Yes 27.00 650 2 Yes 21.00 415 2 No 15.00 275 2 Yes 25.00 557 2 Yes 45.00 1028 5 Yes 29.00 793 4 Yes 21.00 523 3 Yes 22.00 564 3 Yes 16.50 312 2 Yes 37.00 757 3 No 32.00 600 3 No 34.00 796 3 Yes 25.00 577 3 Yes 31.00 500 4 Yes 24.00 695 3 Yes 40.00 1054 4 Yes 27.00 486 3 Yes 18.00 442 2 Yes 62.50 1249 5 No 53.75 995 6 Yes 79.50 1397 7 No

Explanation / Answer

Using R I solve this Problem .

library(dplyr)
library(data.table)
data=fread(file.choose())

Determine whether there is a significant relationship between labor hours and the two independent variables (the number of cubic feet moved and the number of pieces of large furniture) at the 0.05 level of significance

> cor.test(data$Hours,data$Feet)

Pearson's product-moment correlation

data: data$Hours and data$Feet

t = 16.522, df = 34, p-value < 2.2e-16

alternative hypothesis: true correlation is not equal to 0

95 percent confidence interval:

0.8902786 0.9707785

sample estimates:

cor

0.9429984

using above result we say that there is significant relationship between between labor hours and feet becasue P-value is less than 0.05.

> cor.test(data$Hours,data$Large)

Pearson's product-moment correlation

data: data$Hours and data$Large

t = 13.105, df = 34, p-value = 7.564e-15

alternative hypothesis: true correlation is not equal to 0

95 percent confidence interval:

0.8360594 0.9554000

sample estimates:

cor

0.9136406

using above result we say that there is significant relationship between between labor hours and Large becasue P-value is less than 0.05.

F: Determine the p-value in (e) and interpret its meaning.

> model=lm(data$Hours~data$Large +data$Feet)

> summary(model)

Call:

lm(formula = data$Hours ~ data$Large + data$Feet)

Residuals:

Min 1Q Median 3Q Max

-9.2921 -2.1574 0.3798 2.6174 9.2571

Coefficients:

Estimate Std. Error t value Pr(>|t|)   

(Intercept) -3.915221 1.673790 -2.339 0.0255 *  

data$Large 4.222834 0.914190 4.619 5.64e-05 ***

data$Feet 0.031924 0.004604 6.934 6. 36e-08 ***

---

Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 3.98 on 33 degrees of freedom

Multiple R-squared: 0.9327, Adjusted R-squared: 0.9287

F-statistic: 228.8 on 2 and 33 DF, p-value: < 2.2e-16

interpritation - you can see above both P-value are less than 0.05 that means both the variable are significant ,

  

G: Interpret the meaning of the coefficient of multiple determination in this problem

> R2=summary(model)$r.squared
> R2
[1] 0.9327368

Here R2 is 0.93 means there is 93% variation explained responce variable in two independent variable .

H: Determine the adjusted r2.

> adj_R2=summary(model)$adj.r.squared
> adj_R2
[1] 0.9286602

adjusted R2 = 0.9286.

K: Construct a 95% confidence interval

> confint(model)
2.5 % 97.5 %
(Intercept) -7.32057240 -0.50987045
data$Large 2.36289934 6.08276843
data$Feet 0.02255721 0.04129148

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Best of Luck <<<<<<<<<<<<<<<<<<<<<<<<<<<,

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.