Unit6HW

# Unit6HW - Unit 6 Multiple Regression Introduction Adapting...

This preview shows pages 1–3. Sign up to view the full content.

Unit 6: Multiple Regression Introduction The Staffing Problem (II) Introducing Multiple Regression Summary Adapting Basic Concepts Interpreting the Multiple Regression Equation Summary Performing in Excel Residual Analysis Summary Quantifying the Predictive Power of Multiple Regression Summary Solving the Staffing Problem (II) Exercise 1: Empire Learning Exercise 2: The Empire Strikes Back Challenge: Children of the Empire New Concepts in Multiple Regression The Staffing Problem (III) Multicollinearity Diagnosing and Treating Multicollinearity Summary Lagged Variables Summary Dummy Variables Summary Solving the Staffing Problem (III) Exercise 1: The Kiwana Quandary Exercise 2: The Return of the Empire At left you will see an outline of the topics covered in Unit 6: Multiple Regression. 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.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Tab 1 Page 2 MPG (Y) Horsepower (X1) Weight (X2) 43.1 48 1985 19.9 110 3365 19.2 105 3535 17.7 165 3445 18.1 139 3205 20.3 103 2830 21.5 115 3245 16.9 155 4360 15.5 142 4054 18.5 150 3940 27.2 71 3190 41.5 76 2144 46.6 65 2110 23.7 100 2420 27.2 84 2490 39.1 58 1755 28.0 88 2605 24.0 92 2865 20.2 139 3570 20.5 95 3155 28.0 90 2678 34.7 63 2215 36.1 66 1800 35.7 80 1915 20.2 85 2965 23.9 90 3420 29.9 65 2380 SUMMARY OUTPUT 30.4 67 3250 Regression Statistics 36.0 74 1980 Multiple R 0.8656887142 22.6 110 2800 R Square 0.7494169499 36.4 67 2950 Adjusted R Square 0.7387538414 27.5 95 2560 Standard Error 4.176601738 33.7 75 2210 Observations 50 44.6 67 1850 32.9 100 2615 ANOVA 38.0 67 1965 df SS MS F Significance F 24.2 120 2930 Regression 2 2451.973702357 1225.9868511785 70.2812832589 7.50524272104267E-015 38.1 60 1968 Residual 47 819.868097643 17.4440020775 39.4 70 2070 Total 49 3271.8418 25.4 116 2900 31.3 75 2542 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 34.1 68 1985 Intercept 58.1570824468 2.6582482084
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

Unit6HW - Unit 6 Multiple Regression Introduction Adapting...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online