Question

Hours	CuFt	#LargeFurniture	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

1. Estimate the labor hours required for a household with a moving size of 2000 CuFt and 6 Large Furniture
2. Based on the model output, we can say that both the size of the move (CuFt) and number of large furniture moved are important considerations when estimating the total number of labor hours required. We can make this claim because

• The FSTAT (F in the ANOVA Table) = 228.80, p-value (Sig.) is 0.00 = True or False?
• p-value for the slope coefficient of number of large furniture is 0.00 = True or False?
• p-value for the slope coefficient of the size of the mode (CuFt) is 0.00 = True or False?

3. Two households have the same moving volume (Cu Ft). One house has 5 large furniture to move while the second house has 8 large furniture to move. The average extra labor hours required for the second house is:

Answer 1

using excel >data analysis >regression we have

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.965783
R Square	0.932737
Adjusted R Square	0.92866
Standard Error	3.979995
Observations	36
ANOVA
	df	SS	MS	F	Significance F
Regression	2	7248.706	3624.353	228.8049	4.55E-20
Residual	33	522.7319	15.84036
Total	35	7771.438
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-3.91522	1.67379	-2.33914	0.025532	-7.32057	-0.50987	-7.32057	-0.50987
CuFt	0.031924	0.004604	6.933877	6.36E-08	0.022557	0.041291	0.022557	0.041291
large furniture	4.222834	0.91419	4.619206	5.64E-05	2.362899	6.082768	2.362899	6.082768

Estimate the labor hours required for a household with a moving size of 2000 CuFt and 6 Large Furniture

Estimated the labor hours =-3.91522 +0.031924*2000+4.222834*6 = 85.269784

yes we can say that both the size of the move (CuFt) and number of large furniture moved are important considerations when estimating the total number of labor hours required. We can make this claim because p values are less than 0.01 and both are significant .

The FSTAT (F in the ANOVA Table) = 228.80, p-value (Sig.) is 0.00 = true

p-value for the slope coefficient of number of large furniture is 0.00 = True

p-value for the slope coefficient of the size of the mode (CuFt) is 0.00 = True

let moving volume (Cu Ft). = 0

5 large furniture to move

Estimated the labor hours =-3.91522 +0.031924*0+4.222834*5 =17.20

8 large furniture to move

Estimated the labor hours =-3.91522 +0.031924*0+4.222834*8 = 29.87

The average extra labor hours required for the second house = 29.87-17.20 =12.67