The owner of a cleaning service would like to predict the amount of? time, in? minutes, required to clean a house? (y) based on the square footage of the house ?(x1?), the total number of rooms in the house ?(x2?), the number of bathrooms it has ?(x3?), and the size of the cleaning crew ?(x4?). Data from randomly selected homes can be found in the accompanying table. Complete parts a through e below.
Time? (mins) Square Feet Rooms Bathrooms Crew
110 2381 12 3.5 4
112 2159 9 2.5 2
115 2192 11 2.5 4
119 2147 9 3 3
119 2515 11 4 4
125 2208 9 2.5 4
131 1630 8 2 3
132 1548 8 2 3
138 1932 8 2.5 3
140 1814 8 2.5 4
141 1640 7 1.5 3
143 2271 11 3.5 3
144 1711 8 2.5 3
145 2205 10 2.5 3
146 1599 7 1.5 2
146 2015 8 2.5 3
146 2209 10 3.5 3
147 2050 9 2 3
147 2238 11 3.5 3
147 2706 11 3.5 3
148 2256 12 3.5 3
148 2485 10 3.5 3
149 2270 10 3 3
150 2176 10 2 3
152 2334 10 2.5 3
154 2797 14 4 3
154 2679 12 3.5 3
154 3007 13 4 3
158 3097 13 4 .5 3
159 2727 12 4 3
160 2407 11 3 3
160 3188 14 4.5 3
160 3319 14 4.5 3
162 1719 7 1.5 3
162 1927 9 2.5 3
162 2550 13 4 3
163 2188 9 2.5 2
163 2571 13 3.5 3
164 2592 13 3.5 3
165 3517 13 4.5 3
167 2601 13 4 3
170 2351 13 3 3
173 2773 13 4 2
175 2783 14 4.5 4
177 2878 15 4.5 2
178 2936 13 4 2
179 2365 13 3 2
179 3035 12 4 2
197 3230 15 4.5 2
241 2599 15 4.5 2
Time? (mins) Square Feet Rooms Bathrooms Crew
a. Use technology to construct a regression model using all the independent variables. Complete the regression model below.
ModifyingAbove y = _____ + ( ) x1 + ( ) x2 + ( ) x3 + ( ) x4
?(Round to two decimal places as? needed.)
b. Test the significance of each independent variable using alphaαequals=0.05.
c. Interpret the? p-value for each independent variable.
d. Construct a? 95% confidence interval for the regression coefficients for the size of the cleaning crew variable and interpret the meaning.
LCL =
UCL=
e. Using the results from part? d, comment on the significance of the size of the cleaning crew variable.