13.50 The owner of a moving company typically has his most experienced manager predict the total...

90.2K

Verified Solution

Question

Statistics

13.50 The owner of a moving company typically has his mostexperienced manager predict the total number of labor hours thatwill be required to complete an upcoming move. This approach hasproved useful in the past, but the owner has the businessob-jective of developing a more accurate method of predicting laborhours. In a preliminary effort to provide a more accurate method,the owner has decided to use the number of cubic feet moved and thenumber of pieces of large furniture as the independent vari-ablesand has collected data for 36 moves in which the origin anddestination were within the borough of Manhattan in New York Cityand the travel time was an insignificant portion of the hoursworked. The data are organized and stored in Moving .a. State themultiple regression equation.b. Interpret the meaning of the slopesin this equation.c. Predict the mean labor hours for moving 500cubic feet with two large pieces of furniture.d. Perform a residualanalysis on your results and determine whether the regressionassumptions are valid.e. Determine whether there is a significantrelationship between labor hours and the two independent variables(the number of cubic feet moved and the number of pieces of largefurniture) at the 0.05 level of significance.f. Determine thep-value in (e) and interpret its meaning.g. Interpret the meaningof the coefficient of multiple determina-tion in this problem.h.Determine the adjusted r2.i. At the 0.05 level of significance,determine whether each inde-pendent variable makes a significantcontribution to the regres-sion model. Indicate the mostappropriate regression model for this set of data.j. Determine thep-values in (i) and interpret their meaning.k. Construct a 95%confidence interval estimate of the population slope between laborhours and the number of cubic feet moved. How does theinterpretation of the slope here differ from that in Problem 12.44on page 443?l. What conclusions can you reach concerning laborhours?

Answer & Explanation Solved by verified expert
4.4 Ratings (603 Votes)
ANSWERGiven thataThe regression equation is defined asNow the regression analysis is done in excel by followingstepsStep 1 Write the data values in excel The screenshot is shownbelowStep 2 DATA Data Analysis Regression OK Thescreenshot is shown belowStep 3 Select Input Y Range Hours column Input X RangeFeet and Large column then OK The screenshot is shown belowClick on Residual and Residual plot for residual analysisThe result is obtained The screenshot    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students