Assignment 1 - Week Labor (hrs) 1 2 3 4 5 6 7 8 9 10 11 12...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Week Y X1 X2 X3 1 100 5.1 90 20 2 85 3.8 99 22 3 108 4.9 58 19 4 116 6.1 16 15 5 92 4.5 54 20 6 63 3.3 42 26 7 79 5.3 12 25 8 101 5.2 32 21 9 88 4 56 24 10 71 4.2 64 29 11 122 6.1 78 10 12 85 3.9 90 30 13 50 3.8 74 28 14 114 5.9 89 14 15 104 4.5 90 21 16 111 6 40 20 17 110 8.1 55 16 18 100 2.9 64 19 19 82 4 35 23 20 85 4.8 58 25 X1 X3 5.1 20 3.8 22 4.9 19 6.1 15 4.5 20 3.3 26 5.3 25 5.2 21 4 24 4.2 29 6.1 10 3.9 30 3.8 28 5.9 14 4.5 21 6 20 8.1 16 2.9 19 4 23 4.8 25 Labor (hrs) Pounds Shipped (1,000s) % of Units Shipped by Truck Average Shipment Weight (lbs)
Background image of page 1

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

View Full DocumentRight Arrow Icon
SUMMARY OUTPUT Regression Statistics Multiple R 0.6498317 R Square 0.4222812 Adjusted R Square 0.3901857 Standard Error 14.662265 Observations 20 ANOVA df SS MS F Significance F Regression 1 2828.5239 2828.5239 13.157027 0.0019267165 Residual 18 3869.6761 214.982 Total 19 6698.2 Coefficientstandard Erro t Stat P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0% Intercept 44.778805 13.772734 3.2512649 0.004433 15.843365323 73.714244 15.843365 73.714244 X1 10.066638 2.7752721 3.6272616 0.0019267 4.2360076317 15.897268 4.2360076 15.897268 RESIDUAL OUTPUT Observation Predicted Y Residuals ndard Residuals 1 96.118659 3.8813414 0.2719702 2 83.032029 1.9679708 0.1378981 3 94.105331 13.894669 0.973616 4 106.1853 9.8147034 0.6877279 5 90.078676 1.9213242 0.1346295 6 77.99871 -14.99871 -1.050977 7 98.131986 -19.13199 -1.340601 8 97.125322 3.8746776 0.2715033 9 85.045357 2.9546432 0.2070354 10 87.058684 -16.05868 -1.125251 11 106.1853 15.814703 1.1081551 12 84.038693 0.961307 0.0673599 13 83.032029 -33.03203 -2.314594 14 104.17197 9.828031 0.6886618 15 90.078676 13.921324 0.9754838 16 105.17863 5.8213672 0.4079101 17 126.31857 -16.31857 -1.143462 18 73.972055 26.027945 1.8238091 19 85.045357 -3.045357 -0.213392 20 93.098667 -8.098667 -0.567483 2 3 4 5 6 7 8 9 -50 0 50 X1 Residual Plot X1 Residuals
Background image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.0307163 R Square 0.0009435 Adjusted R Square -0.05456 Standard Error 19.281367 Observations 20 ANOVA df SS MS F ignificance F Regression 1 6.3197064 6.3197064 0.0169989 0.8977119 Residual 18 6691.8803 371.77113 Total 19 6698.2 Coefficientstandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0%Upper 95.0% Intercept 91.931722 11.345665 8.1028057 2.04E-007 68.095364 115.76808 68.095364 115.76808 X2 0.0228809 0.1754941 0.1303799 0.8977119 -0.345819 0.3915804 -0.345819 0.3915804 RESIDUAL OUTPUT Observation Predicted Y Residuals ndard Residuals 1 93.991003 6.0089966 0.3201877 2 94.196932 -9.196932 -0.490056 3 93.258814 14.741186 0.78548 4 92.297816 23.702184 1.2629643 5 93.167291 -1.167291 -0.062199 6 92.89272 -29.89272 -1.592825 7 92.206293 -13.20629 -0.703694 8 92.663911 8.3360892 0.4441862 9 93.213053 -5.213053 -0.277776 10 93.3961 -22.3961 -1.19337 11 93.716433 28.283567 1.5070821 12 93.991003 -8.991003 -0.479083 13 93.624909 -43.62491 -2.324541 14 93.968122 20.031878 1.0673931 15 93.991003 10.008997 0.5333266 16 92.846958 18.153042 0.9672798
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/23/2011 for the course SCM 475 taught by Professor Rosales during the Spring '11 term at Michigan State University.

Page1 / 10

Assignment 1 - Week Labor (hrs) 1 2 3 4 5 6 7 8 9 10 11 12...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online