This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: 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 Rsquared 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. Moving Company Page 2 Cubic Feet (x) Hours (y) 545 24.00 400 13.50 562 26.25 540 25.00 220 9.00 344 20.00 569 22.00 340...
View
Full
Document
 Fall '11
 i dont know

Click to edit the document details