MAT510 Homework Assignment 6 Data Analysis (2016-05-25).xlsx

MAT510 Homework Assignment 6 Data Analysis...

Info icon This preview shows pages 1–6. Sign up to view the full content.

Old Process Week Elapsed time 1 31.7 2 27 3 33.8 4 30 5 32.5 6 33.5 7 38.2 8 37.5 9 29 10 31.3 11 38.6 12 39.3 SUMMARY OUTPUT Regression Statistics Multiple R 0.5745518821 R Square 0.3301098652 Adjusted R Square 0.2631208517 Standard Error 3.4883134897 Observations 12 ANOVA df SS MS F Significance F Regression 1 59.9633566434 59.963357 4.927821 0.0507057521 Residual 10 121.6833100233 12.168331 Total 11 181.6466666667 Coefficients Standard Error t Stat P-value Lower 95% Intercept 29.324242424 2.1469085422 13.658822 8.57E-008 24.5406320896 X Variable 1 0.6475524476 0.2917074284 2.2198696 0.0507058 -0.0024122071 RESIDUAL OUTPUT Observation Predicted Y Residuals 1 29.971794872 1.7282051282 2 30.619347319 -3.6193473193 3 31.266899767 2.5331002331 4 31.914452214 -1.9144522145 5 32.562004662 -0.062004662 6 33.20955711 0.2904428904 7 33.857109557 4.3428904429 0 2 4 6 0 5 10 15 20 25 30 35 40 45 f(x) = 0.6475524476x + 29.324242424 R² = 0.3301098652
Image of page 1

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

8 34.504662005 2.9953379953 9 35.152214452 -6.1522144522 10 35.7997669 -4.4997668998 11 36.447319347 2.1526806527 12 37.094871795 2.2051282051 New Process Week Elapsed time 1 24 2 25.8 3 31 4 23.5 5 28.5 6 25.6 7 28.7 8 27.4 9 28.5 10 25.2 11 24.5 12 23.5 SUMMARY OUTPUT Regression Statistics Multiple R 0.1713144422 R Square 0.0293486381 Adjusted R Square -0.0677164981 Standard Error 2.5093057575 Observations 12 ANOVA df SS MS F Significance F Regression 1 1.9038461538 1.9038462 0.3023602 0.5944737741 Residual 10 62.9661538462 6.2966154 Total 11 64.87 Coefficients Standard Error t Stat P-value Lower 95% Intercept 27.1 1.5443709351 17.547598 7.68E-009 23.6589271325 X Variable 1 -0.1153846154 0.209838689 -0.549873 0.5944738 -0.5829343491
Image of page 2
Image of page 3

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

Image of page 4
Image of page 5

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

Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern