MAT 510

lenci104
Week7assignment6Excelspreadsheet3.xlsx
Home>Mathematics homework help>Statistics homework help>MAT 510

Old & New Process

Old Process New Process
Week Elapsed Time Week Elapsed Time
1 31.7 13 24
2 27 14 25.8
3 33.8 15 31
4 30 16 23.5
5 32.5 17 28.5
6 33.5 18 25.6
7 38.2 19 28.7
8 37.5 20 27.4
9 29 21 28.5
10 31.3 22 25.2
11 38.6 23 24.5
12 39.3 24 23.5
Average 33.53 26.35
SD 4.06 2.43

old process

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.9633566434 4.9278209667 0.0507057521
Residual 10 121.6833100233 12.1683310023
Total 11 181.6466666667
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Bo 29.3242424242 2.1469085422 13.6588223705 0.0000000857 24.5406320896 34.1078527589 24.5406320896 34.1078527589
B1 0.6475524476 0.2917074284 2.2198695833 0.0507057521 -0.0024122071 1.2975171022 -0.0024122071 1.2975171022
RESIDUAL OUTPUT
Observation Predicted Y Residuals Standard Residuals
1 29.9717948718 1.7282051282 0.5196083538
2 30.6193473193 -3.6193473193 -1.0882059495
3 31.2668997669 2.5331002331 0.7616110036
4 31.9144522145 -1.9144522145 -0.5756060709
5 32.562004662 -0.062004662 -0.0186425441
6 33.2095571096 0.2904428904 0.0873256014
7 33.8571095571 4.3428904429 1.3057490207
8 34.5046620047 2.9953379953 0.9005890675
9 35.1522144522 -6.1522144522 -1.8497468683
10 35.7997668998 -4.4997668998 -1.352916059
11 36.4473193473 2.1526806527 0.6472326878
12 37.0948717949 2.2051282051 0.6630017571

Old Process Chart

1 2 3 4 5 6 7 8 9 10 11 12 1.7282051282051256 -3.6193473193473231 2.5331002331002281 -1.9144522144522185 -6.2004662004667921E-2 0.29044289044288973 4.3428904428904431 2.9953379953379908 -6.1522144522144586 -4.4997668997669003 2.152680652680651 2.2051282051281973

X Variable 1

Residuals

New Process

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.9038461538 0.3023602424 0.5944737741
Residual 10 62.9661538462 6.2966153846
Total 11 64.87
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Bo 28.4846153846 3.9490206647 7.2130833954 0.0000288124 19.6856490143 37.2835817549 19.6856490143 37.2835817549
B1 -0.1153846154 0.209838689 -0.5498729329 0.5944737741 -0.5829343511 0.3521651203 -0.5829343511 0.3521651203
RESIDUAL OUTPUT
Observation Predicted Y Residuals Standard Residuals
1 26.9846153846 -2.9846153846 -1.2474729373
2 26.8692307692 -1.0692307692 -0.4469039646
3 26.7538461538 4.2461538462 1.7747553128
4 26.6384615385 -3.1384615385 -1.311775666
5 26.5230769231 1.9769230769 0.8262900641
6 26.4076923077 -0.8076923077 -0.3375893258
7 26.2923076923 2.4076923077 1.0063377045
8 26.1769230769 1.2230769231 0.5112066934
9 26.0615384615 2.4384615385 1.0191982503
10 25.9461538462 -0.7461538462 -0.3118682343
11 25.8307692308 -1.3307692308 -0.5562186035
12 25.7153846154 -2.2153846154 -0.9259592936

New Process Chart

13 14 15 16 17 18 19 20 21 22 23 24 -2.9846153846153847 -1.0692307692307672 4.2461538461538488 -3.138461538461538 1.9769230769230788 -0.80769230769230305 2.407692307692308 1.2230769230769241 2.4384615384615387 -0.74615384615384528 -1.3307692307692278 -2.2153846153846146

X Variable 1

Residuals

Correlation

SUMMARY OUTPUT
1 31.7
Regression Statistics 2 27
Multiple R 0.5515749462 3 33.8
R Square 0.3042349213 4 30
Adjusted R Square 0.2726092359 5 32.5
Standard Error 4.1937600613 6 33.5
Observations 24 7 38.2
8 37.5
ANOVA 9 29
df SS MS F Significance F 10 31.3
Regression 1 169.1906173913 169.1906173913 9.6198680768 0.0052057152 11 38.6
Residual 22 386.927715942 17.5876234519 12 39.3
Total 23 556.1183333333 13 24
14 25.8
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 15 31
Bo 34.7362318841 1.7670428392 19.657832348 0 31.0716093301 38.400854438 31.0716093301 38.400854438 16 23.5
B1 -0.3835652174 0.1236672374 -3.1015912169 0.0052057152 -0.6400353705 -0.1270950643 -0.6400353705 -0.1270950643 17 28.5
18 25.6
19 28.7
20 27.4
RESIDUAL OUTPUT 21 28.5
22 25.2
Observation Predicted Y Residuals Standard Residuals 23 24.5
1 34.3526666667 -2.6526666667 -0.6467429127 24 23.5
2 33.9691014493 -6.9691014493 -1.6991267795
3 33.5855362319 0.2144637681 0.0522881083 Correlation -0.0077382654
4 33.2019710145 -3.2019710145 -0.7806680298
5 32.8184057971 -0.3184057971 -0.0776300676
6 32.4348405797 1.0651594203 0.2596950136
7 32.0512753623 6.1487246377 1.499111868
8 31.6677101449 5.8322898551 1.4219623507
9 31.2841449275 -2.2841449275 -0.5568941481
10 30.9005797101 0.3994202899 0.0973820966
11 30.5170144928 8.0829855072 1.9707012782
12 30.1334492754 9.1665507246 2.2348837832
13 29.749884058 -5.749884058 -1.4018711097
14 29.3663188406 -3.5663188406 -0.8694991586
15 28.9827536232 2.0172463768 0.4918219895
16 28.5991884058 -5.0991884058 -1.2432259219
17 28.2156231884 0.2843768116 0.0693335087
18 27.832057971 -2.232057971 -0.5441949008
19 27.4484927536 1.2515072464 0.3051282138
20 27.0649275362 0.3350724638 0.0816935441
21 26.6813623188 1.8186376812 0.443399484
22 26.2977971014 -1.0977971014 -0.2676523605
23 25.9142318841 -1.4142318841 -0.3448018779
24 25.5306666667 -2.0306666667 -0.4950939714

Correlation Chart

-2.6526666666666721 -6.9691014492753709 0.21446376811593382 -3.2019710144927629 -0.31840579710145533 1.0651594202898451 6.1487246376811555 5.8322898550724567 -2.2841449275362393 0.39942028985506539 8.0829855072463701 9.1665507246376698 -5.7498840579710233 -3.5663188405797186 2.0172463768115847 -5.0991884057971113 0.2843768115941927 -2.2320579710144983 1.2515072463768 0.33507246376810684 1.8186376811594087 -1.0977971014492844 -1.4142318840579797 -2.0306666666666757

X Variable 1

Residuals