View the step-by-step solution to:

# Unit 5: Regression Basics Introduction Leo's Bisque Debacle and the Staffing Problem Introducing the Regression Line Summary The Uses of Regression...

answers need to be show on the fx tab
Mathematical process and interpretation should be located outside the question text-box. I should be able to click on each respective answer and see the mathematical process in the fx-bar. Part of the grade on the course final is assigned to the actual mathematical performance
Unit 5: Regression Basics Introduction Leo's Bisque Debacle and the Staffing Problem Introducing the Regression Line Summary The Uses of Regression Using Regression for Forecasting The Structure of a Relationship Summary Exercise 1: Soft Drink Consumption Calculating the Regression Line The Accuracy of a Line Summary Identifying the Regression Line Summary Performing Regression Analysis in Excel Exercise 1: Soft Drink Consumption Revisited Deeper into Regression Quantifying the Predictive Power of Regression Summary Residual Analysis Summary Graphing Residual Lines and Residuals in Excel The Significance of Regression Coefficients Testing for a Linear Relationship Summary Revisiting R-squared and p Summary Solving the Staffing Problem Exercise 1: Inventories and Capacity Utilization Exercise 2: Clever Solutions Exercise 3: Productivity and Compensation At left you will see an outline of the topics covered in Unit 5: Regression Basics. There are two homework problems associated with this unit. There is one tab for each problem in this workbook. Once you have completed the unit online, you should attempt these problems and submit them to your coach for assessment and feedback.
1 Page 2 Cubic Feet Hours 545 24.00 400 13.50 562 26.25 540 25.00 220 9.00 344 20.00 569 22.00 340 11.25 900 50.00 285 12.00 865 38.75 831 40.00 344 19.50 360 18.00 750 28.00 650 27.00 415 21.00 275 15.00 557 25.00 1028 45.00 793 29.00 523 21.00 564 22.00 312 16.50 757 37.00 600 32.00 796 34.00 577 25.00 500 31.00 695 24.00 1054 40.00 486 27.00 442 18.00 1249 62.50 995 53.75 1397 79.50 The owner of a moving company would like to be able to predict the number of hours required to complete a move by using the number of cubic feet of items moved. He has collected data for 36 moves in which the origin and destination were within the city limits of Coral Gables and in which the travel time was an insignificant portion of the hours worked. Q-1a: What is the slope of the least squares regression line? (Round to four decimals.) Q-1b: What is the y-intercept of the least squares regression line? (Round to four decimals.) Q-1c: Predict the number of hours required to complete a move involving 920 cubic feet of items moved. (Round to one decimal place.) Summarize your findings
Show entire document

1
Cubic Feet (x)
Hours (y)
545
24.00
400
13.50
562
26.25 The owner of a moving company would like to be able to predict the number of hours
required to complete a move by using the number of cubic...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents