Data Hours Feet 24.00 545 13.50 400 26.25 562 25.00 540 9.00 220 20.00 344 22.00 569 11.25 340 50.00 900 12.00 285 38.75 865 40.00 831 19.50 344...

The owner of an intra -city 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 had proved useful in the past, but he would like to be able to develop a more accurate method of predicting the labor hours by using the amount of cubic feet moved. In a preliminary effort to provide a more accurate method, he has collected data for 36 moves, in which the travel time was an insignificant portion of the labor hours worked.The data are in the Excel file, MOVING.xls downloadable from File or click Companion Website at www.peasronhighered.com/levine, and go to the Excel Date Files link.