- Labor Hours 195 170 220 200 230 225 240 225 275 260 Square Ft 100s 20 21 23 23 26 27 29 31 32 35 4 Bell Building 1 (32.68 KiB) Viewed 21 times
- Labor Hours 195 170 220 200 230 225 240 225 275 260 Square Ft 100s 20 21 23 23 26 27 29 31 32 35 4 Bell Building 2 (32.27 KiB) Viewed 21 times
4. Bell Building & Construction would like to predict the total number of labor hours spent framing a house based on the square footage of the house. The data shown below are for a sample of ten houses that have been recently built. (12 pts.) Laber bours Square footage (100% 20 21 23 23 26 22 195 170 220 200 230 225 240 225 275 260 31 32 35 A Run the data analysis regression routine for this problem and attach/email your output. (Note: you don't have to do the plots/diagrams, don't check the boxes to include them) (4 pts.) B Write out the regression equation (2 pts.) c. For a house of 3350 square feet, what is the predicted number of labor hours? (briefly show your work at least how you set up the equation) (2 pts.) D. For the overall equation the p-value is (1 p.) so we can conclude (I pt.) the equation is significant a good predictor of labor hours needed the equation is not significant/not a good predictor of labor hours needed E For the coefficient on square footage the p-value is (1 pt.) so we can conclude (1 pt.) square footage is significant/a good predictor of labor hours needed square footage is not significant/not a good predictor of labor hours needed